I'm writing because I saw an earlier post with a similar title dealing with importing xml content into mysql and I couldn't respond to it. I've created a really nice tool for automating this process called
SportsFeed. It can be configured to fetch xml data regularly and has scheduling and monitoring support. The content can be saved to disk or database, allowing individual xml element / attribute content to be mapped to database command parameters. It supports many databases including mysql, sql server, oracle, sqlite, postgre, sybase and any others which distribute a .NET connection provider. It can be run on linux and windows and supports any type of xml. You don't have to write any code to use it, just edit xml configuration files and start/stop the service. It can be extended by anyone who creates a plug-in assembly, allowing specific types of xml documents to be delivered to 'custom handler' methods. Please join the users group at google if you're interested:
http://groups.google.com/group/sportsfeed-users