HP-UX OSRA for Web Services 2.5 Blueprint and Configuration Guide

NOTE: To identify the type of storage engine used for a particular table, use the following
command:
mysql> show table status from osradb like 'customer';
4. Restart the slave replication thread after the database has been dumped, by entering the
following command:
mysql> START SLAVE SQL_THREAD;
Integrating Data Protector
1. Add the secondary storage, which is used to hold the backup data, as a device in Data
Protector.
2. Add a Blank Filesystem Backup on the Data Protector cell server, and select the data to be
backed up, as shown in Figure 4-6. Back up the following data files to the secondary storage
device:
• The data file (/tmp/customer.sql) dumped in the previous section.
• The binary log files located in the /usr/local/mysql/data/mysql directory on the
slave server.
• The relay-log.info and master.info files located in the /usr/local/mysql/
data/mysql directory on the slave server.
Figure 4-6 Backing up the Slave Server
3. Start the backup manually or at a scheduled time.
4. Restart replication between the master server and slave servers, after the backup is complete.
To incrementally backup a MySQL server, the dumped data file needs to be backed up in its
entirety only once, the first time a backup is run. All subsequent back ups should be performed
Backing Up MySQL Using HP Data Protector 43