MySQL Admin Restore
From Hostek.com Wiki
Revision as of 05:46, 26 August 2012 by Chadc (Talk | contribs) (Created page with "==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 fro...")
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 complete up to an hour for large databases.