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 the ‘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 ddatabase 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 |