Veritas NetBackup™ for
MySQL Administrator's
Guide
Windows and Linux
Release 8.1
Veritas NetBackup™ for MySQL Agent Administrator's
Guide
Documentation version: 8.1
Legal Notice
Copyright © 2017 Veritas Technologies LLC. All rights reserved.
Veritas and the Veritas Logo are trademarks or registered trademarks of Veritas Technologies
LLC or its affiliates in the U.S. and other countries. Other names may be trademarks of their
respective owners.
This product may contain third party software for which Veritas is required to provide attribution
to the third party (“Third Party Programs”). Some of the Third Party Programs are available
under open source or free software licenses. The License Agreement accompanying the
Software does not alter any rights or obligations you may have under those open source or
free software licenses. Please see the Third Party Legal Notice Appendix to this Documentation
or TPIP ReadMe File accompanying this product for more information on the Third Party
Programs.
The product described in this document is distributed under licenses restricting its use, copying,
distribution, and decompilation/reverse engineering. No part of this document may be
reproduced in any form by any means without prior written authorization of Veritas Technologies
LLC and its licensors, if any.
THE DOCUMENTATION IS PROVIDED "AS IS" AND ALL EXPRESS OR IMPLIED
CONDITIONS, REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED
WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR
NON-INFRINGEMENT, ARE DISCLAIMED, EXCEPT TO THE EXTENT THAT SUCH
DISCLAIMERS ARE HELD TO BE LEGALLY INVALID. VERITAS TECHNOLOGIES LLC
SHALL NOT BE LIABLE FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES IN
CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS
DOCUMENTATION. THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS
SUBJECT TO CHANGE WITHOUT NOTICE.
The Licensed Software and Documentation are deemed to be commercial computer software
as defined in FAR 12.212 and subject to restricted rights as defined in FAR Section 52.227-19
"Commercial Computer Software - Restricted Rights" and DFARS 227.7202, et seq.
"Commercial Computer Software and Commercial Computer Software Documentation," as
applicable, and any successor regulations, whether delivered by Veritas as on premises or
hosted services. Any use, modification, reproduction release, performance, display or disclosure
of the Licensed Software and Documentation by the U.S. Government shall be solely in
accordance with the terms of this Agreement.
Veritas Technologies LLC
500 E Middlefield Road
Mountain View, CA 94043
http://www.veritas.com
Technical Support
Technical Support maintains support centers globally. Technical Support’s primary
role is to respond to specific queries about product features and functionality. The
Technical Support group also creates content for our online Knowledge Base. The
Technical Support group works collaboratively with the other functional areas within
the company to answer your questions in a timely fashion.
Our support offerings include the following:
■ A range of support options that give you the flexibility to select the right amount
of service for any size organization
■ Telephone and/or Web-based support that provides rapid response and
up-to-the-minute information
■ Upgrade assurance that delivers software upgrades
■ Global support purchased on a regional business hours or 24 hours a day, 7
days a week basis
■ Premium service offerings that include Account Management Services
For information about our support offerings, you can visit our website at the following
URL:
www.veritas.com/support
All support services will be delivered in accordance with your support agreement
and the then-current enterprise technical support policy.
Contacting Technical Support
Customers with a current support agreement may access Technical Support
information at the following URL:
www.veritas.com/support
Before contacting Technical Support, make sure you have satisfied the system
requirements that are listed in your product documentation. Also, you should be at
the computer on which the problem occurred, in case it is necessary to replicate
the problem.
When you contact Technical Support, please have the following information
available:
■ Product release level
■ Hardware information
■ Available memory, disk space, and NIC information
■ Operating system
■ Version and patch level
■ Network topology
■ Router, gateway, and IP address information
■ Problem description:
■ Error messages and log files
■ Troubleshooting that was performed before contacting Technical Support
■ Recent software configuration changes and network changes
Licensing and registration
If your product requires registration or a license key, access our technical support
Web page at the following URL:
www.veritas.com/support
Customer service
Customer service information is available at the following URL:
www.veritas.com/support
Customer Service is available to assist with non-technical questions, such as the
following types of issues:
■ Questions regarding product licensing or serialization
■ Product registration updates, such as address or name changes
■ General product information (features, language availability, local dealers)
■ Latest information about product updates and upgrades
Information about upgrade assurance and support contracts
■
■ Advice about technical support options
■ Nontechnical presales questions
■
Issues that are related to CD-ROMs, DVDs, or manuals
Support agreement resources
If you want to contact us regarding an existing support agreement, please contact
the support agreement administration team for your region as follows:
Worldwide (except Japan)
CustomerCare@veritas.com
Japan
CustomerCare_Japan@veritas.com
Contents
Technical Support
Chapter 1
Chapter 2
Chapter 3
............................................................................................ 4
Introduction to NetBackup for MySQL Agent .............. 8
About NetBackup for MySQL Agent ................................................... 8
Installing NetBackup for MySQL Agent ...................... 10
Planning the installation of NetBackup for MySQL Agent ...................... 10
Configuring NetBackup for MySQL Agent ................. 16
The nbmysql configuration file ......................................................... 16
Chapter 4
Performing NetBackup for MySQL backups and
Chapter 5
restores .......................................................................... 20
About NetBackup for MySQL backup operations ................................ 20
About NetBackup for MySQL restore operations ................................ 23
Disaster recovery ......................................................................... 26
NetBackup for MySQL Commands .............................. 27
About NetBackup for MySQL commands ........................................... 27
Troubleshooting for NetBackup for MySQL ............... 30
Troubleshooting errors for the NetBackup for MySQL Agent .................. 30
Index .................................................................................................................... 35
Chapter 6
Chapter
1
Introduction to NetBackup
for MySQL Agent
This chapter includes the following topics:
■ About NetBackup for MySQL Agent
About NetBackup for MySQL Agent
NetBackup for MySQL Agent extends the capabilities of NetBackup to include
backups, restores, query, and delete operations of MySQL databases. The MySQL
agent interacts with the NetBackup XBSA interface to protect data in the NetBackup
environment. The agent is located on the NetBackup client and supports the MySQL
5.5.5 and later versions.
Features of NetBackup for MySQL Agent
The following table displays the features that the agent supports:
Table 1-1
Features
Backup
Restore
Features of NetBackup for MySQL Agent
Description
NetBackup supports full instance backups of the MySQL database.
NetBackup supports full instance restores of MySQL backups.
Redirected restore
NetBackup supports to restore MySQL backups to alternate
NetBackup clients.