Chat now with support
Chat with Support

NetVault Plug-in for MySQL 12.0 - 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

Enabling the Binary Log on the MySQL Server (Standard/Community option only)

Before you configure support for PIT backups and restores with the MySQL Standard/Community option, you must enable the MySQL Binary Log.

Enabling the log on a Linux- or UNIX-based MySQL Server

IMPORTANT: If wanted, the “log-bin” entry added to the my.cnf file can be set up using the following syntax to specify a different file to house the Binary Log:

log-bin=<NameOfDestinationFile>

When you specify the name of the destination file for the Binary Log, use only the name of the file itself; do not include full path information or the filename extension. For more information about enabling the Binary Log, see the MySQL Reference Guide before continuing with installation of the plug-in.

Enabling the log on a Windows-based MySQL Server

1
Start the MySQL Administrator application; for more information, see the relevant MySQL documentation.
2
In the MySQL Administrator window, click Startup Variables in the left pane.
4
Select the Binary Logfile Name check box, and either enter a unique name for the file, or leave the field blank to use the default value of log-bin.
IMPORTANT: When you specify the name of the destination file for the Binary Log, use only the name of the file itself; do not include full path information or the filename extension. For more information about enabling the Binary Log, see the MySQL Reference Guide before continuing with installation of the plug-in.
5
Exit the MySQL Administrator application.

Reviewing the recommended configuration

While you can set up a single machine as both the NetVault Backup Server and the MySQL Server, that is, all software installation and configuration requirements are performed on a single machine, Quest recommends that these two entities exist on separate machines.

Software installed and configuration

Software installed and configuration

Binary Log enabled (MySQL Standard/Community option only)
mysqldump/mysqlbinlog utilities — compatible with the version of MySQL installed
mysqlbackup utility — MySQL Enterprise Backup option only
MySQL Server added as a NetVault Backup Client — for details on adding a Client machine to the NetVault Backup Server, see the Quest NetVault Backup Administrator’s Guide.
IMPORTANT: Sample images and procedures throughout this guide assume that you are using this two-machine environment and that configuration requirements have been met.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating