I hope this works – it’s almost my last hope! I have had to move an entire Magento store from one web host to another with the first being an IIS and the second being an Apache server. In spite of both running the same MySQL, the shop is now suffering from speed problems and in particular bulk-load (import/export profiles) are completely kaput. I will need to make a clean install of Mage to get the reference db alongside it but will try this – the alternative is to rebuild the site on the new server and bulk-load all the products for a second time – not a prospect that fills me with joy!

one top tip with regards to moving Magento DBs is to use the store admin DB backup tool rather than any other DB administration tool.

The store backup will correctly create a dump file that you can easily restore. To achieve the same with phpMyAdmin for example requires careful configuration. I never bother, I just use the admin DB backup because it works every time.

This repair tool just saved my ass. Clicked the wrong button in Magento connect. Meant to install a module and clicked upgrade. Made a proper mess of everything while trying to upgrade to 1.4 and although I had a filesystem backup, my db backup was way out of date.