Syed Tanveer Shahzad Gilani wrote:
I am new to wikipedia world. I have a Windows XP
machine running XAMPP. I
have installed Mediawiki 1.7.1 and is working fine. Now I want to dump
English wikipedia. I have read and used a lot many applicable commands but
none seems to work. Today I have used the following command:
java -jar mwdumper.jar --format=sql:1.5
enwiktionary-20060927-pages-articles.xml.bz2 | mysql -u user -p passw wikidb
According to a suggestion I have placed mwdumper.jar and the dump .bz2 file
in the folder where mysql.exe exists. (any other suggestion????)
[snip]
it goes upto 279 pages with out any warning.
When i open wikidb in mysql there is no record in any table , not a single
entry. I have deleted from the page, revision and text tables. There is no
prefix set to wikidb tables. I have looked all forums which i found. And now
its driving me nuts!!
1) Try saving the output to an .sql file rather than piping it directly to
MySQL. This can make it easier to track down problems later:
java bla bla bla > bigfile.sql
2) Now do the SQL import:
mysql -u <username> -p<password> <dbname> < bigfile.sql
Watch the output for errors.
Likely problems:
* You didn't create the tables first, so there's no tables to import into.
* Your tables are named with a prefix and you didn't pass the prefix option, so
they don't go to the right place.
* You created tables with the MediaWiki installer, but didn't clear them afterwards.
The page, revision, and text tables must:
* exist
* be empty
for the import to proceed successfully.
To create the tables manually, source in maintenance/tables.sql from the
MediaWiki distribution.
You can use the TRUNCATE TABLE command to clear existing tables. See
dev.mysql.com for general documentation on MySQL.
-- brion vibber (brion @
pobox.com)