HP OSMS Blueprint: HP Manageability Value-Add Software for Open Source Middleware Stacks

Restoring Data

Restore the data file and binary log files to both the master server and slave server. All database

data is recreated using the extracted data file and the binary log files.

1. Stop the replication between master server and slave servers. For more instructions, see the

MySQL 5.0 Reference Manual, located at:

http://dev.mysql.com/doc/refman/5.0/en/index.html

2. Restore the latest database data file and binary log files to both master server and slave

server using Data Protector.

Figure 9 Restore Files

3. Using the backup data file, reconstruct all database data on the master server and slave

server to the point in time when the binary log flush occurred by entering the following

command:

# mysql -uosmusr -posmpass osmsdb < /tmp/customer.sql

4. Replay the binary log files on the master server and slave server by entering the following

command:

# mysqlbinlog mysql-bin.000002|mysql -uosmusr -posmpass

5. On the slave server, restore the files master.info and relay-log.info so they are

consistent with the binary log files that have been restored on the master server.

6. Restart the replication.