Restore all incremental backups (binary logs) since the last full backup. Make sure you restor the incremental backups in the proper order.

1. Open a terminal session on the STA server, and log in as the Oracle user.

   Caution:

   Do not use multiple connections to the MySQL server.

   Following is an example of how not to process the binary logs, as this method may create multiple connections to the server.

   $ mysqlbinlog binlog.000001 |mysql –u root –p #<=== DANGER!!
   $ mysqlbinlog binlog.000002 |mysql –u root –p #<=== DANGER!!

2. Run the binary logs in chronological order, from oldest to newest. If you have more than one binary log to execute, you must process them all using a single connection to the MySQL server.

   Use one of the following methods:

   • The safest method is to use a single connection to the server and a single MySQL process to execute the contents of all the binary logs. For example:

     $ mysqlbinlog 20130723_133755.sta-binlog.000021 \
     > 20130723_133755.sta-binlog.000022 \
     > 20130723_133755.sta-binlog.000023 \
     > 20130723_133755.sta-binlog.000024 |mysql –u root –p
     Password:
     

   • Another safe method is to concatenate all applicable binary logs to a single file and then process that file. For example:

     $ mysqlbinlog 20130723_133755.sta-binlog.000021 > /tmp/recoversta.sql
     $ mysqlbinlog 20130723_133755.sta-binlog.000022 >> /tmp/recoversta.sql
     $ mysqlbinlog 20130723_133755.sta-binlog.000023 >> /tmp/recoversta.sql
     $ mysqlbinlog 20130723_133755.sta-binlog.000024 >> /tmp/recoversta.sql
     $ mysql –u root –p –e 'source /tmp/recoversta.sql'
     Password: