Bug #26696 Can't restore backups done with mysqldump --xml
Submitted: 27 Feb 2007 21:24 Modified: 19 Sep 2007 6:40
Reporter: Michael Widenius Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Backup Severity:S2 (Serious)
Version:4.0 and up OS:Any (ALL)
Assigned to: Alexander Barkov CPU Architecture:Any

[27 Feb 2007 21:24] Michael Widenius 
Description:
In MySQL 3.23.50 the --xml option was introduced to mysqldump.
In MySQL 4.0.0 --xml option was introduced to the mysql command line client.

The problem is that if you now do a backup with mysqldump --xml, you can't restore it with mysqlimport or LOAD DATA infile.

There is also nothing mentioned in the manual about this incompatibility.

How to repeat:
mysqldump --xml --all-databases > /tmp/backup.xml

Try to restore the backup

Suggested fix:
Add support for xml in LOAD DATA INFILE and in mysqlimport
[28 Feb 2007 9:31] Sveta Smirnova 
Thank you for the report.

Verified as described.
[19 Sep 2007 6:40] Alexander Barkov 
LOAD XML INFILE was added into 5.2.

http://dev.mysql.com/doc/refman/5.2/en/load-xml.html