1 |
To generate a prepared Full Backup to be restored, submit a job in which you have selected the Restore, Extract Raw Full Backup… option on the Options tab. |
• |
• |
Entered a regular expression pattern in the Include Tables field to indicate which tables to include in the restore. |
• |
Entered a rename request in the Rename Table field. |
During a TTS Copy Back restore when MySQL table files are restored back to the MySQL data directory, the table files privileges are preserved. However, the table files might be written to disk as root user. After performing a TTS Copy Back restore you may have to change the ownership of the restored tables files with the user and group of the MySQL Server user, usually mysql. In addition, in the NetVault binary logs, MySQL Server might log an entry stating that alter table … import tablespace query did not complete.
Ensure, after performing the TTS Copy Back restore, to change ownership of the restored tables files, and to issue an alter table … import tablespace for each of the restored tables.
For example, if restoring to a table named new_table to database database_name, and the MySQL data directory is located in the default location, /var/lib/mysql, the following commands and query can be applied:
sudo chown mysql:mysql /var/lib/mysql/database_name/new_table*
mysql> alter table database_name.new_table import tablespace;
1 |
To generate a prepared Full Backup to be restored, submit a job in which you have selected the Restore, Extract Raw Full Backup… option on the Options tab. |
2 |
To shut down the MariaDB service and copy the prepared Full Backup to the MariaDB Server repository, submit a job in which you have selected the Shutdown MariaDB Server and Copy Back… option on the Options tab. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center