MySQL Instance Restore Operations

You can restore the database server, or a subset of the databases.

Note

When you create an instance, the software automatically creates a database that is called innodb. This database does not include a format file, so the tables are not listed. Make sure that you do not restore the database.

Restore Objectives

Your objective for restoring data determines the process that you must follow and the restore destination.

Objective for the restore operation	Reason	Process	Destination
Restore data that was backed up in the past number of days	The data is in long-term storage based on compliance requirements.	Determine the time range. Browse and restore data the data based on the number of days that you specify.	Typically, this data is restored to an in-place destination.
Restore data from a range of time	The data was accidentally deleted.	Determine the time range. Browse and restore the data based on a time range that you specify.	Typically, this data is restored to an out-of-place destination.
Restore to a point in time	The database is corrupted or otherwise invalid.	Determine the date and time.	Typically, this data is restored to an in-place destination.

Restore Destinations

You can restore the data to any of the following destinations:

The same instance
A different instance
An on-premise server

Database Versions

You can restore to a database server that runs the same version or higher than the database version on the source client.