[Mediawiki-l] HELP: wikipedia dump using MWdumper

STSG stshahzad at gmail.com
Wed Oct 18 13:26:23 UTC 2006


Hi! Brion.
Its not working. can u help any more? Please!!!


On 10/17/06, STSG <stshahzad at gmail.com> wrote:
>
> 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 at 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 at Wikimedia.org
> > http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
> >
> >
> >
> >
>



More information about the MediaWiki-l mailing list