Hi
I'd like some help importing Wikipedia articles into a Mediawiki installation running on OS X. I tried to use importDump.php, but couldn't even get it to run. After trying mwdumper.jar (which *appeared* to do "something"), there are still no articles in my WIki. Any help appreciated. Bear in mind I am a simple-minded OS X user. My previous efforts are detailed below.
Thanks Xed
These are the steps I took:
/usr/local/mysql-standard-5.0.16-osx10.4-powerpc/bin/mysql
-u root -p wikidb
SOURCE /Users/xed/Sites/mediawiki/maintenance/tables.sql
....which got: Query OK, 0 rows affected, 1 warning (0.17 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.04 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.06 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.03 sec)
Query OK, 0 rows affected, 1 warning (0.02 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
Then I did:
/System/Library/Frameworks/JavaVM.framework/Versions/1.5/Commands/java
-jar -Xmx512m -Xms256m /Users/xed/Desktop/mwdumper.jar --format=sql:1.5 /Users/xed/Desktop/20051127_pages_articles.xml.bz2 |
/usr/local/mysql-standard-5.0.16-osx10.4-powerpc/bin/mysql
-u wikiuser -p wikidb
...and it stepped thru (without errors) from: 1,000 pages (91.033/sec), 1,000 revs (91.033/sec)
...to..
2,136,559 pages (189.635/sec), 2,136,559 revs (189.635/sec)
After this, I rebooted and checked my Wiki. The
articles where nowhere to be found. Obviously it did something, but I don't know what.
___________________________________________________________ WIN ONE OF THREE YAHOO! VESPAS - Enter now! - http://uk.cars.yahoo.com/features/competitions/vespa.html