Restoring Third-Party MySQL Databases
You can restore MySQL databases you created at another hosting company. To do so, you need the SQL file you created at the other hosting company.
The best way to restore a third-party MySQL database in any application is through phpMyAdmin. You must restore the SQL file to a new database. You might need prior experience with phpMyAdmin and should understand the values, syntax, and design of SQL files.
If you have a large database, you must use the SQL function through phpMyAdmin to import it. You need to break up the database queries into sizes that phpMyAdmin accepts (smaller than 2MB).
If you are trying to restore a MySQL database you created through us, see Backing up and Restoring MySQL or MSSQL Databases.
To Restore Third-Party MySQL Databases
- Log in to phpMyAdmin for the database you want to use. For more information, see Accessing PHPMyAdmin on Your Shared Hosting Account.
- Click the Database Name on the left.
- Click Check All, and then select Drop.
- Click Import, and then click Browse.
- Select the
SQLfile you want to restore, click Open, and then click Go.
It might take several minutes to restore the database. After the database restores, make sure your connection strings are up to date. For more information, see Locating Your Database Connection Strings. Your site should now resolve properly.
NOTE: If you receive an error message stating "Script timeout passed, if you want to finish import, please resubmit same file and import will resume" you can immediately select the same file to import and continue the restore where it left off.
