O'Reilly logo

MySQL Management and Administration with Navicat by Gokhan Ozar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Backup and restore

In case of a disaster, be it an electricity outage leading to a disk failure causing corruption of the database, or simply a user error of deletion of the wrong objects or data rows ending in data loss, it is crucial to back up your database. Navicat lets you back up all Tables (and their records), Views, Functions, and Events of your database for restoring later.

There's a big Backup button with a tape cassette icon on the toolbar of Navicat's main window, which will take you to a special view for managing backups, where a smaller toolbar appears under the main toolbar. This smaller toolbar has smaller buttons for creating a new backup, restoring a backup, or deleting it, plus a button for extracting SQL from the backups.

To ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required