New subject: [Foundation-l] [Wikitech-l] mwdumper does not work

27 Feb 2007

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

Re: [Foundation-l] [Wikitech-l] mwdumper does not work