Can somebody please recommend the easiest way to get XML information into a MySQL Database?

I know there is SimpleXML, etc. but I am confused as to what is the best method for storing info from XML file into a Database.

Should I create a PHP script using something like SimpleXML and run this to populate the database and set something like a Cron job to update on daily/weekly basis by running same or similiar PHP script? Is this the best method or is there another way (or an alternate way) that somebody could please recommend?

If you had to populate a MySQL database from an XML file, how would you go about doing it? Thanks!

[edited by: CWebguy at 3:58 pm (utc) on Sep. 20, 2007]