README

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