Thanks Brother! I will try what u said and I hope it works. The tables Page,
Revision and Text exist, and are empty. I will try conversion to .sql then
see what happens.
Bye.
On 10/16/06, Brion Vibber <brion(a)pobox.com> wrote:
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)
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l