Backup?
Yes, run a backup before restoration even if your database is corrupted. You never know what you can salvage from a seemingly useless database.
The restoration process
As you would expect, restoration is the reverse of the backup process. You should know that by running a restoration, you are going back to the time of the backup. As a result you will lose data accumulated since the time of that backup.
Launch MySQL Administrator.
Log in as root.
Click Restore.
Click Open Backup File and browse for File to restore
Select the backup file
Highlight it and click Open
Click Start Restore
Be patient, it might take a while
Restoring to another computer
Restoring from backup file, essentially running a SQL dump script, is perhaps the easiest way of porting a database from one computer to another.
|
|