Hi all,
I am trying to import the full english wikipedia in mediawiki 1.4. As its 1.4 it does not have importdump.php. I am trying to use mwdumper. But it gives a strange error.
I used the following command :
java -server -jar mwdumper.jar --format=sql:1.4 pages_full.xml.bz2 | mysql -u root -p wikidb
where "wikidb" was the database i created while installing mediawiki1.4
It asks for password ..which i put in ..then it gives the following error:
Error 1146(42SO2) at line 31 : Table 'wikidb.old' does not exist
And then continues running adding pages and their revisions.So it runs but will it work ? Given i get that error at first ?
... any clues ??
Previously , I have imported into mediawiki1.5 using importdump.php ... but because of some reasons I have to move to 1.4 now..
You help will be highly appreciated
Candy
All the tables are there as created during the mediawiki installation. But it never creates something called wikidb.old ! As i said i have done the importing using importdump.php with mediawiki 1.5. Even then there was no wikidb.old. Did someone try mwdumper as yet ? Did anyone import dump to mediawiki 1.4. If yes what did you use ?
candy
Brion Vibber wrote:
candy wrote:
It asks for password ..which i put in ..then it gives the following error:
Error 1146(42SO2) at line 31 : Table 'wikidb.old' does not exist
Perhaps you didn't create the tables first?
-- brion vibber (brion @ pobox.com)
Wikitech-l mailing list Wikitech-l@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l
You can't use 1.4 scripts to talk to a 1.5 database. The schema has changed quite dramatically between the two versions. Indeed, the "old" table _doesn't_ exist in 1.5 onwards.
Rob Church
On 04/01/06, candy ccanddyy@yahoo.com wrote:
All the tables are there as created during the mediawiki installation. But it never creates something called wikidb.old ! As i said i have done the importing using importdump.php with mediawiki 1.5. Even then there was no wikidb.old. Did someone try mwdumper as yet ? Did anyone import dump to mediawiki 1.4. If yes what did you use ?
candy
Brion Vibber wrote:
candy wrote:
It asks for password ..which i put in ..then it gives the following error:
Error 1146(42SO2) at line 31 : Table 'wikidb.old' does not exist
Perhaps you didn't create the tables first?
-- brion vibber (brion @ pobox.com)
Wikitech-l mailing list Wikitech-l@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l
Wikitech-l mailing list Wikitech-l@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l
I am not trying to use 1.4 script to talk to 1.5 database. And I know the schemas has changed. Let me put it clearly, I installed mediawiki 1.4 and the result was creation of a database (wikidb) with the tables as per the 1.4 schema. Now I downloaded the pages_full.xml.bz2 from the web (17 gig file). And I want to import it.
Option 1: importdump.php - not possible as it is not there in 1.4 mediawiki Option 2: mwdumper - problem error : Error 1146(42SO2) at line 31 : Table 'wikidb.old' does not exist
After that it continues to import the pages..it does not stop.
My worry is, if that error can screw up things.
Mayukh
Rob Church wrote:
You can't use 1.4 scripts to talk to a 1.5 database. The schema has changed quite dramatically between the two versions. Indeed, the "old" table _doesn't_ exist in 1.5 onwards.
Rob Church
On 04/01/06, candy ccanddyy@yahoo.com wrote:
All the tables are there as created during the mediawiki installation. But it never creates something called wikidb.old ! As i said i have done the importing using importdump.php with mediawiki 1.5. Even then there was no wikidb.old. Did someone try mwdumper as yet ? Did anyone import dump to mediawiki 1.4. If yes what did you use ?
candy
Brion Vibber wrote:
candy wrote:
It asks for password ..which i put in ..then it gives the following error:
Error 1146(42SO2) at line 31 : Table 'wikidb.old' does not exist
Perhaps you didn't create the tables first?
-- brion vibber (brion @ pobox.com)
Wikitech-l mailing list Wikitech-l@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l
Wikitech-l mailing list Wikitech-l@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l
candy wrote:
I am not trying to use 1.4 script to talk to 1.5 database. And I know the schemas has changed. Let me put it clearly, I installed mediawiki 1.4 and the result was creation of a database (wikidb) with the tables as per the 1.4 schema. Now I downloaded the pages_full.xml.bz2 from the web (17 gig file). And I want to import it.
Option 1: importdump.php - not possible as it is not there in 1.4 mediawiki Option 2: mwdumper - problem error : Error 1146(42SO2) at line 31 : Table 'wikidb.old' does not exist
There are three possibilities: 1) You didn't put any tables in the database 'wikidb' 2) You put 1.5 tables in the database 'wikidb' 3) You put 1.4 tables with a prefix in the database 'wikidb'
You need to actually look in the database and tell us which before continuing. You also need to be very specific about the steps you are taking.
For some background on how to request help in an effective manner, please see:
http://www.catb.org/~esr/faqs/smart-questions.html http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
-- brion vibber (brion @ pobox.com)
wikitech-l@lists.wikimedia.org