[Recover] How to use MySQL administrator to manage/back up/restore my SQL database

From: http://gisqimeng.blog.163.com/blog/static/71242398200861455248465/

1. Open the software and enterDatabase IP Address,User NameAndPassword

2. After successful login, the following screen will appear

3. view existing databases

• Select "catalogs" to list the Databases

• Click the "Database Name" you have activated in the Database List at the lower left foot. In this example, It is webdesk000025. The database table that already exists in the database is displayed on the right,If it is a new database, the right side is empty.

4. Back up the database to the hard disk of the local computer.

• Back up the "webdesk000025" database to the hard disk of the local computer, and select "backup" to back up the database.

• Click "new project" to create a new backup project.

5. Select the database to be backed up. In this example, set the database to website000025 and click>

6. The database table structure is displayed on the right.

7. Backup options

• Click "advanced options ".
• Select normal backup when backing up
• Select "complete backup" and select full backup
• Select SQL files for Backup Type backup
• Click execute backup now to back up the database immediately.

8. Click execute backup now to back up the database immediately.

• Click "desktop" to save the database file to the desktop for ease of searching

9. After the backup is successful, the following figure is displayed:

10. You can find the SQL script file of the database you just backed up on the "desktop" and open it with the "Notepad" that comes with windows, as shown in.

11. The backup is complete.

========================================================== =====

Restore the backed up MySQL database to the Database Server

========================================================== =====

1. Select "Restore" to restore the database, and click "Open backup file"

2. Find the database script file that was previously backed up, and select and open the file

3,

4. Click "Start restore" and start restoration. After the restoration is successful, the following screen is displayed.

• The restore operation wasfinished successfully. restored successfully.
• If there are other prompts, an error may occur during restoration. In this case, you need to check the cause of the error.