MySQL Forums
Forum List  »  Connector/Node.js

Re: please help to restore from xml file
Posted by: Jonathan Stephens
Date: September 27, 2009 09:57PM

LOAD XML is available only starting in MySQL 5.4.4, which hasn't been released yet.

It was originally supported in MySQL 6.0, but 6.0 has been discontinued (at least for now), and it won't be backported to 5.1. So you'll have to wait until 5.4.4 is available, build your own MySQL from source, or try another approach. In this case, it sounds like the XML format is not essential, so maybe you can just use mysqldump and LOAD DATA to dump and restore the DB.

Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Written By
Posted
September 23, 2009 06:10AM
Re: please help to restore from xml file
September 27, 2009 09:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.