Re: [Xmldatadumps-l] Installing dumps too slow

2013-08-23 Thread Byrial Jensen
Den 23-08-2013 01:27, A B skrev: So, how could I do that? One way would be to edit the first part of the sql file which creates the table before using it. Another way which gives better control would be to write your own program to parse the sql file and insert the data into the database.

Re: [Xmldatadumps-l] Installing dumps too slow

2013-08-23 Thread Federico Leva (Nemo)
I've copied the above info to https://meta.wikimedia.org/wiki/Data_dumps/Tools_for_importing#Converting_to_SQL_first Nemo ___ Xmldatadumps-l mailing list Xmldatadumps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/xmldatadumps-l

[Xmldatadumps-l] Page, page-articles and page_len

2013-08-23 Thread A B
Apart of the problems I have related to speed inserting page table data from the SQL dump, there is a thing I don't understand. Why there are about 30 millions INSERT INTO page in page.sql but only about 10 millions in page-articles.sql dump? My goal is to have all pages with its correct

Re: [Xmldatadumps-l] Page, page-articles and page_len

2013-08-23 Thread Byrial Jensen
Den 23-08-2013 17:45, A B skrev: Apart of the problems I have related to speed inserting page table data from the SQL dump, there is a thing I don't understand. Why there are about 30 millions INSERT INTO page in page.sql but only about 10 millions in page-articles.sql dump? The page.sql file