Chatta subito con l'assistenza
Chat con il supporto

NetVault Plug-in for MySQL 13.2 - User Guide

Introducing NetVault Plug-in for MySQL Installing and removing the plug-in Configuring the plug-in Backing up data Restoring data
Restoring data: an overview Restoring data Using advanced restore procedures for MySQL Standard/Community
Working with native MySQL replication Using the plug-in in a Failover Cluster environment Troubleshooting

TTS only restore scenarios

1
Selected the Copy Back Prepared 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.
Example of Include Tables field: database_name\.
Example of Rename Table field: original_name to new_name

Additional step on Linux and UNIX environments for TTS restore

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 -u root -p

mysql> alter table database_name.new_table import tablespace;

Examples of restore scenarios for Mariadb-backup

To recover from a failure or data corruption, various settings must be made when setting up the job regarding data selected for restore and options available on the Options tab.

Full Backup only restore scenarios of MariaDB

1
Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione