Back up and restore a MySQL database using Navicat for MySQL

Our conventional backup and restoration of website databases will adopt direct export and import by phpMyAdmin, or the mysqldump command mode is recommended. A few days ago, some netizens discussed using the Navicat for MySQL tool to back up and restore the database. The amount of information on this tool is quite large, and it should be relatively used.

 

The advantage of Navicat for MySQL is visualization. We can directly back up, restore, query and manage data on the software interface, and even set scheduled backup tasks. I don't know this software before, so I don't know how to use it. I want to record it in this article for my understanding of basic backup and restoration database and interface, it's a long experience for yourself.

 

1. Install and connect Navicat for MySQL

 

The Navicat for MySQL software is not available for downloading here, because if you need to use and play it, you can directly search for it and download it. There are still many software tool stations, although there are cracked versions on the Internet, however, the official version provides a 14-day trial period. I use the trial version here, because I want to check the usage of this tool.

 

When connecting to the database, we will find an error message. Here, I found a "solve the problem of Navicat for MySQL managing the connection between two Linux VPS databases" in the previous day to solve the connection problem.

 

 

Here, laozuo.org is mainly used for testing software, so I directly use ROOT users to manage all databases. We can also manage single database users separately. Create connection parameter settings. Then save and connect.

 

 

Here we can see various tables in the current database.

 

2. Navicat for MySQL back up the database

 

The Navicat for MySQL interface is Chinese. In fact, the operation is simple. We can back up the interface directly to the local hard disk, but the format is the software's own format PSC.

 

 

Directly view the interface operation, create a backup, and then follow the wizard operation.

 

 

After the backup is complete, it will be stored in the corresponding local directory file. Later, we can directly restore the database.

 

Third, Navicat for MySQL restore the database

 

 

Here is the database we backed up, and then click "Restore Backup", which is also automatically operated according to the interface.

 

 

In this way, you can restore the database.

 

Fourth, Navicat for MySQL export and import databases

 

 

Here we can also export and import visual interface operations like phpMyadmin.

 

To sum up, the Navicat for MySQL tool is just a simple understanding of the operation left, the actual project has not been used yet, the function is still relatively good, and is a visual operation, users who hate commands can still choose and use commands. For functions, you can also set synchronization, timing, and other operations, and Navicat software also includes operations on other databases. Here we usually use MYSQL, if other databases need to be downloaded.