MySQL Administrator Backup and Restore database operations

The following articles mainly introduce MySQL Administrator's backup and restoration of databases. With the gradual development of PHP Technology, the usage of MySQL databases has also increased. However, the actual operations on MySQL databases are generally based on command lines, but they are not easy to operate using GUI visual graphical tools such as the Enterprise Manager of Microsoft MSSQL database.

In general, we can use PHP script tools such as PHPMYADMIN to operate MySQL databases, but PHPMYADMIN is not a GUI tool.

To make it easier to operate MySQL databases, we will introduce a visual graphical tool for managing MySQL: MySQL Administrator. This is an effective tool that is just as convenient for local MySQL operations as the Enterprise Manager for ms SQL management.

It is important that MySQL Administrator does not frequently encounter Chinese garbled characters when using SQLyog as a GUI tool for MySQL management, chinese garbled characters may occur if the Chinese website database is used improperly.

Therefore, we use the MySQL Administrator tool to effectively avoid Chinese garbled characters. It is easy to use MySQL Administrator 5.0 r16. Download the original official website on Windows (x86). The latest version is 5.0-r17, about 17 MB.

Using this software to back up the MySQL database, restore the MySQL database, and manage MySQL will become very simple, just as convenient as using the Enterprise Manager of MSSQL.

1. log in and enter the database IP address, user name, and password.

2. After successful login, the following information is displayed:

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. The database table that already exists in the database is displayed on the right. If it is a new database, the right side is blank.

4. Back up the database to the hard disk of the Local Computer

Back up the database to the local computer hard disk, select "Backup" to back up the database function, and then click "New Project" to create a New Backup Project. Select the database to be backed up, and click>. The database table structure is displayed on the right.

Backup options:
Click "Advanced Options" Advanced Options, select "Normal backup" for backup, select "Complete Backup" for full backup, or select "InnoDB Online backup ", this is a simple online Backup method. Select SQL Files for Backup Type Backup, and click "Execute Backup Now" to immediately start backing up the database.

5. Select "Restore" to Restore the database.

Click "Open Backup File", find the previously backed up database script File, select and Open the File, and click "Start Restore" to Restore the File. The restoration is successful.

Note the following points during restoration: 1. "Target Schema" is the default database item. If you do not have the root permission for the MySQL server, for example, if you are a subaccount allocated by the VM, You must select the database name in "another schema" instead of the "original schema" option. Otherwise, the restoration fails. 2, the default "file charset" option is utf8. Do not change it; otherwise, Chinese garbled characters may also occur.

MySQL Administrator can not only back up and restore the MySQL database, but also conveniently maintain and manage MySQL, such as modifying and adding fields. In addition, there is also an article on how to use MySQL Administrator to manage/back up/restore My SQL database. You can also take a look.