Navicat tool Backup Restore MySQL database detailed illustration

Navicat is a very good MySQL database management tool, we commonly use the Web form of the phpMyAdmin and font of the three kinds of, are very good MySQL management tools. Because the Navicat tool compatibility is better, the operation is relatively simple, so just take the Navicat tool as an example.

First step: Download install Navicat (not explained here), open the Navicat tool, select "File", "New Connection", "MySQL" on the menu, such as:

The second step: Get your database information (the general virtual host has a gift database, after purchase to obtain the gift database can be viewed in the database related information), and then according to fill in, the connection name, hostname (database server IP address), user name (database login user name), password. Such as:

Step three: Locate the database connection name that you just filled in the list on the left side of the Navicat tool, and click "Right", "open Connection" (or double-click). Such as:

Fourth step: Click on "Right" and "Open Database" (or directly double-click the database) on the database that needs to be operated as follows:

Fifth step: Back up the database file, click "Right button", "Dump SQL file" on the connected database. Such as:

Sixth step: Select the path to save the backup file and the name you want to save. Such as:

Seventh step: Wait for the show dump progress is 100% Click Close (Recommended: Do a regular database backup). Such as:

Next is the navicat Restore Database , the general gift of the database only one, restore the time to restore directly, do not need to create a new database. Here I create a new database for the restore operation, as in steps two or three or four above, where you start the operation directly from the restore.

The first step: click "Right" and "run" on the database you want to restore. Such as:

The second step: Select the SQL file that needs to be restored, encode the encoding according to your own backup file, then click "Start". Such as:

Step three: When "Done" appears, the database is all imported successfully, then click Close. Such as:

Fourth step: On the database table, "Right-click", "Refresh" you can see the database files have been imported.

Navicat tool Backup Restore MySQL database detailed illustration