Chat now with support
Chat with Support

NetVault Plug-in for MySQL 4.4 - User Guide

Introducing Dell™ 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-inin a Failover Cluster environment Troubleshooting About Dell

Restoring data

Restoring data to a Virtual Client is conducted in the same manner as a restore performed to a traditional NetVault Backup Client. All options available for a restore with Plug‑in for MySQL are also available for Failover Clustering environments, and data selection is performed in the same way as well. The only difference is that restorable backups of a Virtual Client are displayed on the Create Restore Job - Choose Saveset page under the name of the Virtual Client, not the specific NetVault Backup Client or node that was active during each backup. When a restore job is initiated, NetVault Backup will communicate with all member Clients to determine which machine is currently in control of the failover cluster, and then target this machine for the restore.
Additionally, you can restore a NetVault Backup Virtual Client to a non-clustered (standalone) NetVault Backup Client.
All the instructions offered in reference to performing a restore can be used in the recovery of a Virtual Client. For more information on restoring a NetVault Backup Virtual Client, see the various sections in Restoring Data. To restore a NetVault Backup Virtual Client to a standalone NetVault Backup Client, use the instructions provided in Recovering to an Alternate MySQL Server.

Troubleshooting

This section describes some common errors and their solutions. In those cases where an error occurs and is not described in this table, obtain the MySQL error number from the NetVault Backup logs, and then refer to the relevant MySQL documentation for the resolution.
 
Table 2. Troubleshooting
Error message
Explanation
NetVault Backup 10.x service (netvault-pgsql) will not start on Windows
Check the Windows Event Viewer to see if it displays the following message: PDT FATAL: lock file “postmaster.pid” already exists
NetVault Backup 10.x uses a PostgreSQL database. If the PostgreSQL database does not start, NetVault Backup cannot start. To correct this issue, delete the “postmaster.pid” file from the location referenced in the log and restart the NetVault Backup Server. For more information, refer to https://support.quest.com/netvault-backup/kb/122475.
•
Failed to add backup record
•
Failed to write index of backup to the database
These messages indicate that the selected data was actually backed up, but the job’s index information was not properly added by NetVault Backup to its database. Without this index information, the data cannot be properly restored.
Method 1:
Access the Manage Devices page of the NetVault Backup WebUI, and perform a scan of the media targeted by the job. NetVault Backup stores index information for backup jobs in two locations: in the NetVault Database and on the media targeted by the backup. Performing this scan adds the index information to the NetVault Database. To verify this, open the Create Restore Job - Choose Saveset page and locate the specific job. If you can browse it and set up a restore job, the scan process has corrected the problem.
Method 2:
If the previous method failed, you must run the backup job again.
Backup fails with a replication error.
If a backup fails with a message similar to “Failed to start Replication slave server,” it might indicate that you selected the Enable MySQL Replication check box but did not configure replication. To correct this issue, either clear the Enable MySQL Replication check box on the Configure dialog or set up replication, and then execute the backup job again. For more information on updating the configuration, see Configuring the plug-in; for more information on replication, see Working with native MySQL replication.

About Dell

Dell listens to customers and delivers worldwide innovative technology, business solutions and services they trust and value. For more information, visit www.quest.com.
Contacting Dell
Technical support:
Online support
Product questions and sales:
(800) 306-9329
Email:
info@quest.com
Technical support resources
Technical support is available to customers who have purchased Dell software with a valid maintenance contract and to customers who have trial versions. To access the Support Portal, go to https://support.quest.com/.
The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. In addition, the portal provides direct access to product support engineers through an online Service Request system.
The site enables you to:
•
Create, update, and manage Service Requests (cases)
•
View Knowledge Base articles
•
Obtain product notifications
•
Download software. For trial software, go to Trial Downloads.
•
View how-to videos
•
Engage in community discussions
•
Chat with a support engineer
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating