Chat now with support
Chat with Support

NetVault Plug-in for MySQL 11.4 - User Guide

Introducing NetVault Backup Plug-in for MySQL Installing and removing the plug-in Configuring the plug-in Backing up data Restoring data 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 Shutdown MySQL Server and Copy Back… 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 for Linux and UNIX environments

If you are using MySQL Enterprise Backup in a Linux or UNIX environment, verify that the file-ownership and permissions information for the restored data matches what it was before the data was backed up. Because the mysqlbackup script does not record this information during the backup process, the information might be different after the restore is completed. For more information, see https://docs.oracle.com/cd/E17952_01/mysql-enterprise-backup-3.11-en/bugs.backup.html.

 

Using advanced restore procedures for MySQL Standard/Community

This topic describes other restore operations that you can perform with the plug-in for the MySQL Standard/Community option.

•
Renaming a database during a restore
•
Restoring to a different MySQL Instance on the same server
•
Recovering to an alternate MySQL Server

Renaming a database during a restore

NetVault Backup lets you select a backed-up MySQL database and rename it for a restore so that it does not overwrite the existing version of that database. This process can be useful when creating a copy of an existing database. To accomplish this process, perform the steps outlined in the following topics.

 
* 
IMPORTANT: Only complete databases can be renamed for a restore. Attempts to rename an individual table are met with an error message.

Before conducting a restore rename, review this list of known limitations and intended uses for this operation:

•
Valid restore sequences are limited to Full or Individual Database/Table Copy Only backups.
•
Not allowed during Incremental and Differential Restores.
•
Can be used with a restore to a different MySQL Instance or MySQL Server.
1
In the Navigation pane, click Create Restore Job, select Plug‑in for MySQL from the Plugin Type list, select the applicable saveset, and click Next.
For more information, see Selecting data for a restore.
2
On the Create Selection Set page, select the database that you want to rename.
3
From the Actions list, select Rename.
4
In the Rename/Relocate dialog box, enter the new name in the Rename to box, and click Ok.
The database item is accompanied by renaming information in parentheses.
5
Continue with the restore as explained in Restoring data in MySQL.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating