MySQL Forums
Forum List  »  Newbie

Re: LOAD XML LOCAL INFILE having problems with XML with multiple column types.
Posted by: Barry Galbraith
Date: December 14, 2016 05:17AM

I had a xml file I was trying to load, but a bug in XML parser meant that it wouldn't load.
It conformed to XML spec, just MySQL couldn't parse it.
I was trying to load the file with php script.
I ended up parsing the xml file with php, and having php write it back out as xml (but in php's interpretation of XML), and then the php script could load that XML file successfully in MYSQL.

A long way around, but it did work, and continues to work today.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: LOAD XML LOCAL INFILE having problems with XML with multiple column types.
December 14, 2016 05:17AM


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.