In database management, backup and restoration are things that must be done seriously. If you neglect or do it roughly, the consequences of database failure will be disastrous, so Navicat also has backup and restoration. Compared with the creation function, its backup function is very simple. So how does Navicat back up the MySQL database? Let’s learn the specific operation skills together.
Recommended tutorial:navicat usage tutorial
Step 1Start Navicat software . After the installation is completed on the computer, a shortcut icon will appear on the desktop. Double-click the icon on the desktop to open the software. The main interface of the software is as shown in the figure below.
Step 2After connecting to the MySQL database, select the [Backup] function button in the main view window, as shown in the figure below.
Step 3Click [New Backup] in the navigation bar below to pop up the prompt window, as shown in the figure below.
Step 4Click the [Start] button in the pop-up new backup prompt window to execute the backup command, as shown in the figure below.
Step 5After executing the backup command, you can see the backup related information in the navigation bar. Right-click on the backup time and select the [General] command to view the storage location, file size and creation time of the backup file.
The above is the detailed content of How to backup navicat. For more information, please follow other related articles on the PHP Chinese website!