Navicat MySQL backup and restore your MySQL data - Create, Edit, Delete and Restore Backup

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 for MySQL allows you to backup/restore all tables and records, views, stored procedures and events for your MySQL database. Backup can be invoked from the command line, which makes it possible to schedule backups between databases.

Just sample click to open an object pane for Backup. A right-click displays the popup menu or using the object pane toolbar below, allowing you to create new, restore, extract and delete the backup.

Create Backup

To create a new backup

Select anywhere on the object pane.
Click the New Backup from the object pane toolbar.
or
Right-click and select New Backup from the popup menu.
Edit backup properties on the appropriate tabs.
Click Start.

Hint: To create new backup you can also right-click the Backups node of the navigation pane and select the New Backup from the popup menu.

Edit Backup

To change the name of the backup

Select the backup for editing in the navigation pane/object pane.
Right-click and select the Rename from the popup menu.

Delete Backup

To delete a backup

Select the backup for deleting in the navigation pane/object pane.
Right-click and select the Delete Backup from the popup menu.
or
Click the Delete Backup from the object pane toolbar.
Confirm deleting in the dialog window.

Restore Backup

To restore a backup to an existing database

Open the database and select the existing backup.
Click the Restore Backup from the object pane toolbar.
or
Right-click and select Restore Backup from the popup menu.
Edit restore options on the appropriate tabs.
Click Start.

Hint: To restore the backup you can also right-click the Backup node of the navigation pane and select the Restore Backup from the popup menu.

To restore a backup to a new database

Create a new database and click to open an object pane for Backup.
Click the Restore Backup from the object pane toolbar.
or
Right-click anywhere on the object pane and select Restore Backup from the popup menu.
Browse the backup file.
Edit restore options on the appropriate tabs.
Click Start.

Extract SQL

To extract backup to sql file

Select the backup for extracting in the navigation pane/object pane.
Right-click and select the Extract SQL from the popup menu.
or
Click the Extract SQL from the object pane toolbar.
Edit extract SQL options on the appropriate tabs.
Click Start.