[Wikitech-l] How to use "--output=mysql" option of mwdumper?

Hi All, How do I use the "--output=mysql" option of mwdumper? Here's what I've tried: * Started with a URL as per http://download.wikimedia.org/tools/README.txt * varying the URL (using 127.0.0.1 instead of localhost, with and without a username and password) * With and without a JDBC driver (both the old mm.mysql, and the newer mysql-connector) Output as follows: ========================================================= ludo:/home/nickj/wikipedia# /usr/java/jre1.5.0_05/bin/java -Xmx200M -server -jar mwdumper.jar --format=sql:1.4 20051020_pages_articles.xml.bz2 "--output=mysql://localhost/enwiki?user=wiki&password=wiki" Exception in thread "main" java.io.IOException: com.mysql.jdbc.Driver at org.mediawiki.dumper.Dumper.connectMySql(Unknown Source) at org.mediawiki.dumper.Dumper.openOutputFile(Unknown Source) at org.mediawiki.dumper.Dumper.main(Unknown Source) ludo:/home/nickj/wikipedia# /usr/java/jre1.5.0_05/bin/java -Xmx200M -server -jar mwdumper.jar --format=sql:1.4 20051020_pages_articles.xml.bz2 "--output=mysql:mysql://localhost/enwiki?user=wiki&password=wiki" Exception in thread "main" java.io.IOException: com.mysql.jdbc.Driver at org.mediawiki.dumper.Dumper.connectMySql(Unknown Source) at org.mediawiki.dumper.Dumper.openOutputFile(Unknown Source) at org.mediawiki.dumper.Dumper.main(Unknown Source) ludo:/home/nickj/wikipedia# /usr/java/jre1.5.0_05/bin/java -Xmx200M -classpath /usr/java/mm.mysql-2.0.2-bin.jar:. -server -jar mwdumper.jar --format=sql:1.4 20051020_pages_articles.xml.bz2 "--output=mysql://localhost/enwiki?user=wiki&password=wiki" Exception in thread "main" java.io.IOException: com.mysql.jdbc.Driver at org.mediawiki.dumper.Dumper.connectMySql(Unknown Source) at org.mediawiki.dumper.Dumper.openOutputFile(Unknown Source) at org.mediawiki.dumper.Dumper.main(Unknown Source) ludo:/home/nickj/wikipedia# /usr/java/jre1.5.0_05/bin/java -Xmx200M -classpath /usr/java/mm.mysql-2.0.2-bin.jar:. -server -jar mwdumper.jar --format=sql:1.4 20051020_pages_articles.xml.bz2 "--output=mysql://localhost/enwiki?user=wiki&password=wiki" Exception in thread "main" java.io.IOException: com.mysql.jdbc.Driver at org.mediawiki.dumper.Dumper.connectMySql(Unknown Source) at org.mediawiki.dumper.Dumper.openOutputFile(Unknown Source) at org.mediawiki.dumper.Dumper.main(Unknown Source) ludo:/home/nickj/wikipedia# /usr/java/jre1.5.0_05/bin/java -Xmx200M -classpath mysql-connector-java-3.1.11/mysql-connector-java-3.1.11-bin.jar:. -server -jar mwdumper.jar --format=sql:1.4 20051020_pages_articles.xml.bz2 --output=mysql://localhost/enwiki?user=wiki\&password=wiki Exception in thread "main" java.io.IOException: com.mysql.jdbc.Driver at org.mediawiki.dumper.Dumper.connectMySql(Unknown Source) at org.mediawiki.dumper.Dumper.openOutputFile(Unknown Source) at org.mediawiki.dumper.Dumper.main(Unknown Source) ludo:/home/nickj/wikipedia# /usr/java/jre1.5.0_05/bin/java -Xmx200M -classpath mysql-connector-java-3.1.11/mysql-connector-java-3.1.11-bin.jar:. -server -jar mwdumper.jar --format=sql:1.4 20051020_pages_articles.xml.bz2 --output=mysql://127.0.0.1/enwiki?user=wiki\&password=wiki Exception in thread "main" java.io.IOException: com.mysql.jdbc.Driver at org.mediawiki.dumper.Dumper.connectMySql(Unknown Source) at org.mediawiki.dumper.Dumper.openOutputFile(Unknown Source) at org.mediawiki.dumper.Dumper.main(Unknown Source) ludo:/home/nickj/wikipedia# /usr/java/jre1.5.0_05/bin/java -Xmx200M -classpath mysql-connector-java-3.1.11/mysql-connector-java-3.1.11-bin.jar:. -server -jar mwdumper.jar --format=sql:1.4 20051020_pages_articles.xml.bz2 --output=mysql://127.0.0.1/enwiki Exception in thread "main" java.io.IOException: com.mysql.jdbc.Driver at org.mediawiki.dumper.Dumper.connectMySql(Unknown Source) at org.mediawiki.dumper.Dumper.openOutputFile(Unknown Source) at org.mediawiki.dumper.Dumper.main(Unknown Source) ludo:/home/nickj/wikipedia# ========================================================= Before doing the above, I did the following in MySQL to grant rights: ========================================================= grant all on enwiki to wiki(a)localhost.localdomain identified by "wiki"; grant all on enwiki.* to wiki(a)localhost.localdomain identified by "wiki"; grant all on enwiki to wiki@localhost identified by "wiki"; grant all on enwiki.* to wiki@localhost identified by "wiki"; grant all on enwiki to wiki identified by "wiki"; grant all on enwiki.* to wiki identified by "wiki"; ========================================================= Versions of software being used: ========================================================= ludo:/home/nickj/wikipedia# /usr/java/jre1.5.0_05/bin/java -version java version "1.5.0_05" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_05-b05) Java HotSpot(TM) Client VM (build 1.5.0_05-b05, mixed mode, sharing) ludo:/home/nickj/wikipedia# mysql --version mysql Ver 11.16 Distrib 3.23.49, for pc-linux-gnu (i686) ludo:/home/nickj/wikipedia# ========================================================= And mwdumper.jar is the latest version. I'm bound to be doing something wrong, but I just don't know what it is. Can someone please tell me what I'm doing wrong? All the best, Nick.