Sorry, I fat fingered the email address and posted to the wrong list.
Here's the results of my testing.
Hi Rob,
I completed running mwdumper with the following command last night. It
took several hours to complete. I aborted the previous
importDump.php in order to run this test for you. The wiki they were
run against was
en.wikigadugi.org. The database name is
endb.
[root@gadugi archive]#
[root@gadugi archive]#
[root@gadugi archive]#
[root@gadugi archive]#
[root@gadugi archive]# java -jar mwdumper.jar --format=sql:1.5
/wikidump/dump/enwiki-GFDL-20070206-pages-articles.xml | mysql -u root
-p endb
Enter password:
[root@gadugi archive]#
[root@gadugi archive]#
[root@gadugi archive]#
[root@gadugi archive]#
The mwdumper ran to completion through almost 4 million articles then
exited. I then applied the command you had specified. Same result,
mwdumper does not work as was previously reported on other blogs. I am
running Fedora Core 5 on wikigadugi. Configuration has already
been provided in previous posts. Here is the output from applying the
UPDATE command via mysql.
[root@gadugi /]#
[root@gadugi /]# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 30734 to server version: 5.0.18
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use endb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> UPDATE page SET page_touched = 20070226080700
-> ;
Query OK, 61932 rows affected (2.72 sec)
Rows matched: 61932 Changed: 61932 Warnings: 0
mysql>
mysql>
mysql>
The server is at
http://en.wikigadugi.org and as you can see if you
visit the site, mwdumper fails to update any of the articles to the
database (other than filling the mysql Innodb file with a lot of wasted
space).
:-)
Jeff