Backup MySQL database with Navicat

Use Navicat Backup mysql database

One 、 Automatic backup

1. Click the plan button , New batch job ;

2. Select the database to be backed up , Click save , Input file name ;

3. Select backup file , Click Set scheduled task .

4. choice “ plan ”, Hit the new button , Click the Apply button after the creation is successful ;

5. stay “ Edit connection —— senior ”, Set the directory of backup files in ;

Two 、 Manual backup

1. Database to be backed up in , Click backup ; Pictured ：

2. Backup . routine , Enter backup notes ;

3. Object selection , Select the database backup object ;

4. senior , Choose “ Compress ”.（ Lock all the watches ： If the data is still being written , Careful choice ; Use a single transaction ; Decide whether to select... According to the type of database engine ; Use the specified file name ： You can specify the file name yourself .）

5. Choose start , Backup .