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(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l

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?.