xml2sql is a converter tool for xml dump which can download at http://download.wikimedia.org/ to sqldump can be import with mysql, mysqlimport, psql command directly.

This tool is written in ANSI C, though it requires some extensions such as getopt(). To compile it, you need expat and zlib. This tool has been developed on Linux, also it chacked works on MacOS X. We want information how about on FreeBSD.

Compile and Install

see INSTALL

Easy to use

$ wget http://download.wikimedia.org/enwiki/pages-meta-current.xml.bz2 $ bunzip2 -c pages-meta-current.xml.bz2 | xml2sql $ mysqlimport -u root dbname pwd/{page,revision,text}.txt

Reference

usage: xml2sql [options]... [XMLFILE]

Input MediaWiki XML dumpfile from XMLFILE (or standard input), output sqldump for MediaWiki1.5 or newer.

OPTIONS -i, --import mysqlimport format. (default) Output filenames are page.txt, revision.txt, and text.txt. You can use mysqlimport program to import this format.

-m, --mysql
     MySQL's INSERT format.
     Output filenames are page.sql, revision.sql, and text.sql.
     You can use mysql program to import this format.

-p [version], --postgresql[=version]
     PostgreSQL's COPY format.
     Output filenames are page.sql, revision.sql, and text.sql.
     If the version is omitted, 8.0 and earlier is assumed.
     You can use psql program to import this format.

-c [{old,full}], --compress[={old,full}]
     Compless text table with deflate.
     When output format is postgresql, this option is ignored
     because PostgreSQL will compress table data itself.

-r, --renumber
     Renumber page id and revision id.

-N ns,ns..., --namespace=ns,ns,...
     Output only specifig namespaces. Namespaces can be specified
     by both namespace number and namespace name.

-t, --no-text
     Exclude text table.

-o OUTDIR, --output-dir=OUTDIR
     Specifies output directory. (default: current directory)

-t TMPDIR, --tmpdir=TMPDIR
     Specifies temporary directory. (default: OUTDIR)
     Temporary file is used only if --compress=old.

-v, --verbose
     Show progress.

-h, --help
     Display help and exit.

--version
     Display version information and exit