nicdumz at gmail
Apr 20, 2008, 3:44 AM
Post #2 of 4
(422 views)
Permalink
|
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[at]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[at]lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikitech-l
>
--
Nicolas Dumazet — NicDumZ
Deuxième année ENSIMAG.
_______________________________________________
Wikitech-l mailing list
Wikitech-l[at]lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
|
