Import XML to MySQL

[ponderdj]

I've browsed related threads and found nothing of help. Could someone please suggest a way to import a large, fairly complex XML file to MySQL? By large I mean about 19000 lines, and by complex I mean nesting about 15-20 levels deep. I'd prefer this solution not cost me money, if possible.

Thanks in advance!

 

[GuardianOfTheFlame]

you can load an XML file into a table using LOAD XML statement:

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

---

The surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us - Calvin (and Hobbes) ;-)