XML to MySQL

[thelilgreenman]

Ok, here is my problem, ive got a database that is an xml file. its a rather large xml file, 45mb or so, anyways, i am trying to convert it into MySQL. i dont know how to do it.

if i could either get it directly to MySQL, or to a delimited text file or even an access or excel database i would be greatful.

So i guess my question is, is there anyway to convert an XML file to a MySQL DB, a Delimited text file, or a MS excel or Access file?

[enterume]

Hi,

Recently, I have try to convert a XML file and store the information into MySQL, via PHP.

What I do is, I expliot each lineof the XML file. Thru to the parcel. (e.g <name></name>), i can know what data this line belong to(the format of XML must be always the same) .

When i see this tag , i know it belongs to certain field in the MySQL db, then I insert into mysql.

Hope it help.

Thanks
Louis