Page MenuHomePhabricator

The XML transformation SQL import database is wrong
Closed, DeclinedPublicBUG REPORT

Description

There are multiple errors in the zhwiki transformation,The error is quite large.
I used mwdumper to convert the XML into an SQL file, which was a mistake when the SQL file imported the MySQL database
(XML file:https://dumps.wikimedia.org/zhwiki/20170601/zhwiki-20170601-pages-articles.xml.bz2)

error.png (900×1 px, 46 KB)

Event Timeline

Hi @runninghyk, thanks for taking the time to report this!
Which exact version of mwdumper was used? Which exact command was executed?

mwdumper 1.25

java -server -jar mwdumper.jar --format:sql:1.25 zhwiki-20170601-pages-articles.xml > zhwiki-20170601-pages-articles.sql
mysql -u root -p zhwiki < zhwiki-20170601-pages-articles.sql

@runninghyk I'm not sure if this comment violates our privacy policy, but could you please run "status" on your MySQL installation, and copy-paste the outputs? I guess this issue is probably affecting only some of MySQL versions

Aklapper changed the subtype of this task from "Task" to "Bug Report".Feb 6 2022, 5:56 PM
hashar subscribed.

mwdumper is no more able to process dump generated since MediaWiki 1.31 (released in June 2018). The tool started in 2005 and is no more maintained, it is thus being archived, see T351228 for reference.