Navicat for mysql database backup and restore
First, set the backup save path
Tools -> Options open
Others -> Path for saving log files
Start backup
There are two types of backup: ONE is saved in SQL and the other is saved as backup
SQL stored
Right click on the database you want to back up and -> dump the SQL file
Select the location and file name
Beginning dump
The import
You are advised to delete all tables or rebuild the database
With the export, right-click the database to run the SQL file
The second backup method is to use navicat backup directly
Click on the start
reduction
