Use mysql workbench graphical backup to restore a mysql database

This article briefly introduces a simple and easy-to-use graphical interface to back up and recover a mysql database. It is helpful for friends who do not like to use command lines.

Workbench is a visual mysql tool developed by mysql AB. It is a good tool for users who are accustomed to using windows graphical interfaces. Of course, there is also a very familiar browser-based graphical interface

Mysql database operating software-phpmyadmin, which is a very good software, the only requirement is that you need to configure the php environment on the local machine, therefore, it is very suitable for php + mysql development environments. mysql workbench described in this article also requires

Some basic environments, the latest mysql workbench5.2 requires you to install. NET Framework 4 Client Profile and Microsoft Visual C ++ 2010 Redistributable Package in advance. I prefer mysql workbench, which can be performed

Database SQL editing, error prompts, visual database design, and powerful background management and performance analysis tools. In particular, the SQL statement error prompt is very useful for beginners.

　　

 

After installing the environment, you can directly download mysql workbench from the mysql official website. After installation, open it and you will see the following interface. The first item is for visual SQL editing and query, the second item can be used for visual mysql database design, and the third item is Green Circle.

Is the mysql management session to be discussed in this article. As shown in.

Double-click the management session to go To the graphical interface management background as shown in:

　　

 

The left side is the Management Panel label, server status monitoring, server switch, server status, related counters, and system variable management, system logs, configuration file management, and user and security management. The following is the database backup and recovery tag, in the lower left corner, as shown above

Figure.

Click data export

　　

 

Select the database you want to back up. You can also see the labels of the advanced options and backup progress bar. You can configure the options as needed and view the backup accuracy. After selecting the database or the corresponding data table of the database, click open in the lower right corner.

Backup start button. Shows the backup progress bar:

　　

 

We can see that the data is backed up to C: \ Users \ Administrator \ Documents \ dumps \ Dump20121118 in a unified manner, ending with a date. If the data is backed up multiple times a day, the corresponding sequence number is added after the folder date, that is, each backup form a separate article

Folder. The naming rules of scripts in the folder start with the database name and end with the data packet. Therefore, you can easily recover a data table of a database. Shows the file name:

　　

 

During data recovery, we can choose to restore the scripts of the entire folder Dump20121118 or a file in the folder. As shown in,

　　

 

This is a simple and practical data backup and recovery method.

This article comes from the era of extreme speed network: http://www.eadoo.com