convert xml to sql

[okano12]

I need to convert an XML file (about 200 Mb in size) to SQL files and insert them into a MySQL table (one table - it looks like there are about 10 million rows, only a few columns).

• Unfortunately, I don't have access to shell / command line tools
• It looks like I would need to use PHPMyAdmin import tool where the import size is limited to 50mb per upload
• Or, PHP is enabled via web browsers only, so write a PHP script to execute from the browser.

So, steps are (please let me know if there are better ways to go around):

• unpack the file into the server
• write a PHP script to convert and insert

or

• do it locally and use phpadmin to upload them separately

What would be a good way to get this done? any ideas / feedbacks / details are appreciated.