A secure and reliable MySQL server is closely related to performing regular backups as failures will probably occur sometimes - caused by attacks, hardware failure, human error, power outages, etc.

Navicat's Backup feature allows you to backup all tables, records, foreign keys, triggers, stored procedures, views and events of a MySQL database. You can also restore your backup by using Restore Backup function. If you wish to transfer your data between two servers, you can use Data Transfer function to achieve it.

Creating a new Backup

1. In the Main Window , click Backup tab
   
2. Select the connection and database that you want to backup the tables.
   
3. To create a new backup, click New Backup button in the Database Window
4. Edit backup properties on the appropriate tabs, i.e. Lock table and specify file name
   
5. Click the Start button in the Backup window.

Restore a Backup
Warning: For restoring a backup, you must have Create, Drop and Insert Privileges. All the existing data and tables will be replaced by the backup.

Restore function will firstly drop all your existing tables of the database. Afterwards, it would create the tables according to your backup. Next, it would insert the data to your database according to your backup.

1. Select the connection and database that you want to restore.
   
2. Click Backup tab in the main window.
   
3. Select a backup that you want to restore and click Restore Backup button.
   
4. Click the Start button in the Restore window.

Delete a Backup

1. Select the connection and database that contain the backup you want to delete.
   
2. Click Backup tab in the main window.
   
3. Select the backup you want to delete.
   
4. Click Delete Backup button.

Extract SQL from a Backup

1. Select the connection and database that contain the backup you want to extract.
   
2. Click the Backup tab in the main window.
   
3. Select the backup you want to extract.
   
4. Control-click and select Extract SQL from the popup menu.