MySQL Admin Restore

From Hostek.com Wiki
Jump to: navigation, search

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:

  1. 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.
  2. Once you have logged in click on Restore on the left hand side.
  3. Click Open Backup File on the bottom of the screen and select the sql file you are wanting to restore from.
  4. Select the Radial Button that says Another Schema and choose the database you are wanting to restore to.
  5. Check Ignore Errors
  6. Click Start Restore

Note

This can take several minutes to an hour to complete depending on the size of the database.