Link

MySQL Restore

Restore is an integral part of a MySQL protection strategy. Veeam provides multiple options of MySQL restores depending on the backup method, let’s go through the option for each backup method.

Database Online Dump During Backup Operations

For this backup option, Veeam provides following restore options depending on the type of failure:

Failure Restore Option
Server Failed Instant Server Restore
Database or Application Level Failure Guest File Level Restore
Database Item Level Restore Veeam Universal Application Item Restore

Online Dump to Staging server

In this backup job, Veeam provides following restore options

Failure Restore Option
Database Failure Instant File Level Restore

Tip: In addition to ‘online dump to staging server’ method, take a crash-consistent backup of MySQL server. In case of server failure, restore the MySQL server from crash-consistent backup and use database dump from the staging server to restore the database.

HotBackup Database Freeze

For this backup option, Veeam provides following restore options depending on the type of failure:

Failure Restore Option
Server Failed Instant Server Restore
Database or Application Level Failure Guest File Level Restore
Database Item Level Restore Veeam Universal Application Item Restore

ColdBackup Database Shutdown

For this backup option, Veeam provides following restore options depending on the type of failure:

Failure Restore Option
Server Failed Instant Server Restore
Database or Application Level Failure Guest File Level Restore
Database Item Level Restore Veeam Universal Application Item Restore

References