Difference between revisions of "MySQL Admin Restore"
From Hostek.com Wiki
m (Chadc moved page MySQL Admin to MySQL Admin Restore) |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 11: | Line 11: | ||
# Check Ignore Errors | # Check Ignore Errors | ||
# Click Start Restore | # Click Start Restore | ||
| − | + | ====Note==== | |
| + | This can take several minutes to an hour to complete depending on the size of the database. | ||
[[Category:Databases-MySQL]] | [[Category:Databases-MySQL]] | ||
[[Category:Tutorials]] | [[Category:Tutorials]] | ||
Latest revision as of 05:58, 26 August 2012
Restoring a MySQL Database with MySQL Administrator
It is possible to use MySQL Administrator to restore an sql file to your database. You can get MySQL Administrator from this Link.
To restore the sql file follow the steps below:
- Login to your database using the IP address that shows in your control panel (unless you are on linux then use localhost). Use the username and password that you set the database up with as well.
- Once you have logged in click on Restore on the left hand side.
- Click Open Backup File on the bottom of the screen and select the sql file you are wanting to restore from.
- Select the Radial Button that says Another Schema and choose the database you are wanting to restore to.
- Check Ignore Errors
- Click Start Restore
Note
This can take several minutes to an hour to complete depending on the size of the database.