Chat now with support
Chat with Support

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
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 copy the prepared Full Backup to the MySQL Server repository and rename one table, submit a job in which you have:
•
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\.
•
Entered a rename request in the Rename Table field.
Example of Rename Table field: original_name to new_name

Additional step on Linux and UNIX environments for TTS restore

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
•
Full and Incremental Backup restore scenarios of MariaDB
•
Additional step for Linux and UNIX environments in MariaDB
•
Start services in Windows environments

Full Backup only restore scenarios of MariaDB

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.
3
Restart the MariaDB Server by entering the applicable command at a command prompt. Before restarting the MariaDB Server, note that if you are running MariaDB in a Linux or Unix system, data files might be written to disk as root user. After restoring a backup you may have to change the ownership of the restored files. Ensure to read the section Additional step for Linux and UNIX environments.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating