How many times have you used the phpMyAdmin Control Panel to export a Database, just to find out that the exact same Database file you exported can’t be imported without errors? If you’ve ran into that exact same problem numerous times, believe me, your not alone. After troubleshooting the reasons behind this issue, I finally found a tested, and working solution.

Example Scenario:
• Your servers eCommerce solution just lost it’s Database to data corruption.
• Customers are e-mailing, and calling in complaints.
• As the System Administrator, you backed up the Database in a safe place.
• Time is of the essence, so you log into phpMyAdmin ready to import your backup.
• And what should have Imported correctly, gives you the following errors:
• Error SQL query: — phpMyAdmin SQL Dump… MySQL said:
• #1007 - Can’t create database ‘yourdatabase’; database exists
• #1044 - Access denied for user ‘yourdatabase1′@’%’ to database ‘yourdatabase2′
• or any other number of Import errors!

Download pdf How to re-create a lost or corrupt MySQL Database using PHPMyAdmin