I just download the xml and import it into mysql the same as CSV. As far as I know, you can't do a LOAD DATA into mysql from an XML file, so I just go thru it and do an insert for each record.
I was always put off XML, and still prefer CSV due to the KISS factor, but the simplexml functions in PHP5 make it a lot easier to navigate around an xml file.
|