Our regular backup and restore website database will use direct phpMyAdmin export and import, or the mysqldump command mode is recommended. I didn't see some netizens talking about using it a few days ago Navicat for MySQL The tool is used to back up and restore the database. I see that the tool has a large amount of information and should be used more often.
The advantage of Navicat for MySQL tool is visualization. We can directly perform backup, restore, query management, etc. in the software interface, and even set scheduled backup tasks. Because Lao Zuo didn't know this software before, let alone experience in using it. I'm going to record my understanding of basic backup and restore databases and interfaces in this article, which is a new insight for me.
First, Navicat for MySQL installation and connection
Lao Zuo doesn't provide the Navicat for MySQL software download here, because if you need to use and play, you can directly search and download. There are still many software tool stations. Although there are cracking versions on the Internet, the official version provides a 14 day trial period. I use the trial version here, because I want to see the use of this tool.
When connecting to the database, we will find an error prompt, which I had the day before yesterday“ Solve the problem of two connection errors in Navicat for MySQL management Linux VPS database "Problem logging can solve connection problems.
Here, Laozuo (laozuo. org) mainly tests the use of software, so I directly use ROOT users to manage all databases, and we can also manage a single database user separately. Create connection parameter settings. Then you can connect after saving.
Here we can see various tables under the current database.
Second, Navicat for MySQL backup database
The Navicat for MySQL interface is in Chinese, which is simple to operate. We can directly back it up to the local hard disk, but the format is the software's own format PSC.
View the interface directly, create a new backup, and then operate according to the wizard.
After the backup is completed, it is in our local corresponding directory file, which can be directly used to restore the database in the future.
Third, restore the database by Navicat for MySQL
Here is the database we backed up, and then click "Restore Backup" accordingly, which is also automatic according to the interface operation.
This allows you to restore the database.
IV. Navicat for MySQL Export and Import Database
Here we can also export and import the visual interface like phpMyadmin.
To sum up, the operation of the Navicat for MySQL tool is just a simple understanding. It has not been used in the actual project yet. Its function is relatively good, and it is a visual operation. Users who hate commands can still choose and use it. In terms of functions, you can also set synchronization, timing and other operations, and Navicat series software also includes operations on other databases. Here we mostly use MYSQL. If we need to download the corresponding version of other databases.
Scan the code to follow the official account
Get more news about webmaster circle!
Entrepreneurship, operation and new knowledge