Navicat MySQL provides you a useful tool for restoring your backup while hardware failure occurs.

To open a restore windows (see Restore Backup for details).

• General Settings for Restore
• Object Selection for Restore
• Setting Advanced Restore Properties
• Message Log
• Restore by Execute Batch File

Note: You must have Create, Drop and Insert Privileges to run the restore.

Hint: Restore function will firstly drop the selected objects of the database, then recreate the new objects according to your backup. Finally, inserting the data.

See also:
Backup