Hi I used xml2sql to convert an xml dump to sql, then imported the three tables (text,page,revision) with mysqlimport (i had to make some things^1). now when I browse through the wiki, all categories are empty. what should I do to fix that?.
importDump.php is very slow but it doesn't give empty categories, is it possible to use it to just fill the categories?.
mwdumper.jar doesn't work (at least for me).
^1 = ALTER TABLE `revision` DROP `rev_len`, DROP `rev_parent_id`; because : mysqlimport: Error: Row 1 doesn't contain data for all columns, when using table : revision ALTER TABLE `revision` CHANGE `rev_comment` `rev_comment` LONGBLOB NOT NULL because: mysqlimport: Error: Data too long for column 'rev_comment' at row 4799, when usi ng table: revision
ALTER TABLE `revision` ADD `rev_len` INT UNSIGNED NOT NULL , ADD `rev_parent_id` INT UNSIGNED NULL ;
Well, you need to import the categorylinks table too. It's the table containing category membership, and apparently, you haven't imported it. :)
2008/4/20, Mohamed Magdy mohamed.m.k@gmail.com:
Hi I used xml2sql to convert an xml dump to sql, then imported the three tables (text,page,revision) with mysqlimport (i had to make some things^1). now when I browse through the wiki, all categories are empty. what should I do to fix that?.
importDump.php is very slow but it doesn't give empty categories, is it possible to use it to just fill the categories?.
mwdumper.jar doesn't work (at least for me).
^1 = ALTER TABLE `revision` DROP `rev_len`, DROP `rev_parent_id`; because : mysqlimport: Error: Row 1 doesn't contain data for all columns, when using table : revision ALTER TABLE `revision` CHANGE `rev_comment` `rev_comment` LONGBLOB NOT NULL because: mysqlimport: Error: Data too long for column 'rev_comment' at row 4799, when usi ng table: revision
ALTER TABLE `revision` ADD `rev_len` INT UNSIGNED NOT NULL , ADD `rev_parent_id` INT UNSIGNED NULL ;
-- --alnokta _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Hi, you can also look at the page: http://synarcher.sourceforge.net/#install_linux
See instructions after the words: "Variant 2. Fast upload dump file to MySQL"
-- Andrew
Mohamed Magdy wrote:
Hi I used xml2sql to convert an xml dump to sql, then imported the three tables (text,page,revision) with mysqlimport (i had to make some things^1). now when I browse through the wiki, all categories are empty. what should I do to fix that?.
importDump.php is very slow but it doesn't give empty categories, is it possible to use it to just fill the categories?.
mwdumper.jar doesn't work (at least for me).
^1 = ALTER TABLE `revision` DROP `rev_len`, DROP `rev_parent_id`; because : mysqlimport: Error: Row 1 doesn't contain data for all columns, when using table : revision ALTER TABLE `revision` CHANGE `rev_comment` `rev_comment` LONGBLOB NOT NULL because: mysqlimport: Error: Data too long for column 'rev_comment' at row 4799, when usi ng table: revision
ALTER TABLE `revision` ADD `rev_len` INT UNSIGNED NOT NULL , ADD `rev_parent_id` INT UNSIGNED NULL ;
On Sun, Apr 20, 2008 at 12:13 PM, Mohamed Magdy mohamed.m.k@gmail.com wrote:
Hi I used xml2sql to convert an xml dump to sql, then imported the three tables (text,page,revision) with mysqlimport (i had to make some things^1). now when I browse through the wiki, all categories are empty. what should I do to fix that?.
importDump.php is very slow but it doesn't give empty categories, is it possible to use it to just fill the categories?.
There should be a rebuildAll script which rebuilds all link tables in the maintance directory, afaik.
Bryan
wikitech-l@lists.wikimedia.org