How to use MySQL Administrator to manage/back up/restore My SQL database

Original article: http://vip.zcxp.net/help/MySQLAdmin.asp

How to use MySQL Administrator to manage/back up/restore My SQL database

What software is MySQL Administrator?

MySQL AdministratorIs a software designed to manage My SQL 4.X and 5.X My SQL databases. You can use this software to back up My SQL database and restore My SQL database.

NOTE: If your database is ms SQL 2000 database, please refer here to manage using ms SQL 2000 Enterprise Manager

Download MySQL Administrator Software

• Http: // 61.139.76.172/dl/mysql-administrator-1.1.9-win.msi (this site telecommunications site download)

• Http://dev.mysql.com/downloads/administrator/1.1.html (official site)
  Select Windows downloads Windows (x86)

If you do not have My SQL 5.x database, you can first apply for a http://www.zcxp.net/ SQL .asp from here for free

After the application is successful, you will obtain the following parameters:

• Database IP Address: 61.139.76.107
• Database Name: web3781 ???
• User name: web ???
• Password :?????

• If you cannot log on, temporarily disable the Local Computer firewall, such as Kingsoft network logo, rising star, and KV2006.

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, webbench 000025 is used. The database table already exists in the database is displayed on the right. If it is a new database, it is empty on the right.

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.