include/master-slave.inc [connection master] CREATE TABLE t1 (a INT); FLUSH BINARY LOGS; INSERT INTO t1 VALUES (1); # Shutdown master include/rpl_stop_server.inc [server_number=1] # Move the master binlog files and the index file to a new place # Restart master with log-bin option set to the new path # Master has restarted successfully # Create the master-bin.index file with the old format # Shutdown master include/rpl_stop_server.inc [server_number=1] # Move back the master binlog files # Remove the unneeded master-bin.index file # Restart master with log-bin option set to default # Master has restarted successfully # stop slave include/stop_slave.inc include/rpl_stop_server.inc [server_number=2] # relocate binlogs # relocate relay logs # Restart slave with options log-bin, relay-log set to the new paths # Slave server has restarted successfully include/start_slave.inc include/stop_slave.inc FLUSH LOGS; INSERT INTO t1 VALUES (2); INSERT INTO t1 VALUES (2); INSERT INTO t1 VALUES (2); INSERT INTO t1 VALUES (2); FLUSH LOGS; FLUSH LOGS; include/start_slave.inc include/diff_tables.inc [master:t1,slave:t1] DROP TABLE t1; include/stop_slave.inc include/rpl_stop_server.inc [server_number=2] # remove tmpdir # restarted with previous slave settings include/start_slave.inc include/rpl_end.inc