9.2 MySql Recovery

Launch a recovery wizard and give the recovery job a name:

img

Select local recovery or different machine recovery , select the target instance to be restored, and expand the content to be restored:

img

Note that if the original backup job is an instance-level backup , the recovery content can only be expanded to the instance; if the original backup job is a library-level backup , it can be expanded to a specific database here.

Note that for MySQL cross-machine recovery, the target cross-machine must also be instance configured first.

Instance-level original machine recovery has the risk of data loss!!

Please do not have a database with the same name on the target instance!!! Or choose a new database name for recovery during recovery. Note that when changing the new database name, MySQL has some requirements for the database name.

In MySQL, there are certain rules and restrictions for user-defined database names. The following are the main requirements:

1. Length limit

The maximum length of a database name is 64 characters.

1. Allowed characters

Database names can contain letters (a-z, A-Z), numbers (0-9), underscores (_), and are case sensitive.

1. Prohibited characters

Database names cannot contain the following special characters: slashes (/), backslashes (), colons (:), asterisks (*), question marks (?), double quotes ("), less than (<), greater than (>), vertical bars (|), commas (,), semicolons (;), single quotes ('), spaces (), exclamation marks (!)、@ symbols, etc.

1. First character requirement

Database names can start with letters or numbers, but it is recommended to use letters to avoid potential compatibility issues.

1. Case sensitive

Whether MySQL is case-sensitive for database names depends on the configuration of the underlying file system. On most Linux systems, database names are case-sensitive, while on Windows systems they are usually not.

1. Use backquotes (')

If you must use characters that do not conform to naming conventions (such as spaces or other special characters), you can use backquotes ( ) to enclose the database name. For example, create a database name with spaces: CREATE DATABASE My Database ';.

Note: Although it is possible to use backquotes to wrap special characters, this will make database management and queries more complex and is not recommended.

Summary: In MySQL, it is recommended to use simple names composed of letters, numbers, and underscores to ensure compatibility and ease of use. Avoid using special characters and reserved words.

Restore the end instance and keep it consistent with the larger version of the target instance. For example, "5.7" to "5.7" is acceptable, "5.7" to "8.4" is not, but "8.4.1" to "8.4.2" is acceptable.

If the instances are inconsistent, the recovery log will have an error similar to the following and cause the recovery job to fail directly:

The version is incompatible and cannot be restored (57 != 84).

Click [Next] to continue:

img

Although less commonly used, recovery jobs do support pre- and post-script .

Click [Submit] to save the recovery job.

img

Click [View Recovery Job List] to go to [Job] - [Recovery Job] - [Running] to view the jobs being restored.

img