By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,611 Members | 1,642 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,611 IT Pros & Developers. It's quick & easy.

Analysing WikiPedia dump file.....

P: n/a
I just download wikipedia's wikibooks dump file.
http://download.wikimedia.org/
I have a hard time figuring out what to do with 130MB XML file.
I tried hard to convert it to to a MySQL database with xml2sql but grr...
mysqlimport keeps failing with column id invalid...

How could I use the damn thing!
130MB of XML! Most of my text editor / viewer just fail...
May 14 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Mon, 15 May 2006 00:43:57 +1000, Lloyd Dupont wrote:
I just download wikipedia's wikibooks dump file.
http://download.wikimedia.org/
I have a hard time figuring out what to do with 130MB XML file.
I tried hard to convert it to to a MySQL database with xml2sql but grr...
mysqlimport keeps failing with column id invalid...

How could I use the damn thing!
130MB of XML! Most of my text editor / viewer just fail...


There's documentation on their download page about the format they are
using and tools that can be used to import the dumps in a database. Have
you tried them?
May 14 '06 #2

P: n/a
As I sai I tryed mysqlimport on the SQL file create by xml2sql from the big
xml.
but I keep having SQL error (invalid value for column)

--
Regards,
Lloyd Dupont

NovaMind development team
NovaMind Software
Mind Mapping Software
<www.nova-mind.com>
"Mehdi" <vi****@REMOVEME.gmail.com> wrote in message
news:1q*******************************@40tude.net. ..
On Mon, 15 May 2006 00:43:57 +1000, Lloyd Dupont wrote:
I just download wikipedia's wikibooks dump file.
http://download.wikimedia.org/
I have a hard time figuring out what to do with 130MB XML file.
I tried hard to convert it to to a MySQL database with xml2sql but grr...
mysqlimport keeps failing with column id invalid...

How could I use the damn thing!
130MB of XML! Most of my text editor / viewer just fail...


There's documentation on their download page about the format they are
using and tools that can be used to import the dumps in a database. Have
you tried them?

May 15 '06 #3

P: n/a
In microsoft.public.dotnet.languages.vc Lloyd Dupont <net.galador@ld> wrote:
As I sai I tryed mysqlimport on the SQL file create by xml2sql from the big
xml.
but I keep having SQL error (invalid value for column)


But did you try the tools they give you? Specifically, mwdumper.
http://meta.wikimedia.org/wiki/Data_dumps

--
Marcus Kwok
Replace 'invalid' with 'net' to reply
May 16 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.