Experience using Navicat for MySQL tool to back up and restore MySQL database

Our regular backup and restore website database will use direct phpMyAdmin export and import, or the more recommended mysqldump command mode. A few days ago, I saw some netizens discussing using the Navicat for MySQL tool to back up and restore the database. I saw that the amount of information in this tool is quite large, and it should be used quite a lot.

The advantage of the Navicat for MySQL tool is visualization. We can perform backup, restore, query management, etc. directly in the software interface, and even set up scheduled backup tasks. Because Snail didn’t know this software before, let alone experience in using it, I plan to record my understanding of basic backup and restore databases and interface in this article, which will give me some insights.

First, Navicat for MySQL installation and connection

Here Snail does not provide Navicat for MySQL software download, because if you need to use and play, you can directly search and download. There are still many software tool stations. Although there are cracked versions online, the official version provides 14 days Trial period, I am using the trial version here because I want to see how to use this tool.

When connecting to the database, we will find an error message. The day before yesterday, I posted a "Resolve the problem of two connection errors in Navicat for MySQL management Linux VPS database" problem record to solve the connection problem.

Here, Snail (laozuo.org) is mainly used to test the software, so I directly use the ROOT user to manage all databases. We can also manage a single database user separately. Create connection parameter settings. Then save and you can connect.

Here we can see various tables under the current database.

Second, Navicat for MySQL backup database

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

Look directly at the interface operation, create a new backup, and then follow the wizard.

After the backup is completed, it will be in our local corresponding directory file, and we can directly use it to restore the database in the future.

Third, Navicat for MySQL restores the database

Here is the database we backed up, and then click "Restore Backup" accordingly, and it will also operate automatically according to the interface.

This will allow you to restore the database.

Fourth, Navicat for MySQL exports and imports database

Here we can also perform export and import visual interface operations similar to phpMyadmin.

To summarize, the operation of Navicat for MySQL tool is just a simple understanding. It has not been used in actual projects yet. The function is quite good, and it is a visual operation. Users who hate commands can still choose and use. In terms of functions, you can also set up synchronization, timing and other operations, and the Navicat series of software also includes operations for other databases. Most of the ones we commonly use here are MYSQL. If there are other databases, we need to download the corresponding versions.

Recommended site searches: Ministry of Industry and Information Technology registration query, registered domain name query, Wanwang domain name space, Guangzhou host rental, free server, Hong Kong server, US host purchase, server rental US high defense, foreign free omnipotent space, space rental, < /p>