| 1 |
RESET MASTER; |
| 2 |
include/stop_dump_threads.inc |
| 3 |
# Step-1: Execute some dummy statements. |
| 4 |
CREATE TABLE t1(i int); |
| 5 |
INSERT INTO t1 values (1); |
| 6 |
# Step-2: Disable binary log temporarily and drop the table 't1'. |
| 7 |
set @@SESSION.SQL_LOG_BIN = 0; |
| 8 |
DROP TABLE t1; |
| 9 |
set @@SESSION.SQL_LOG_BIN = 1; |
| 10 |
# Step-3: Execute MYSQL_BINLOG with --stop-never and source it to mysql client. |
| 11 |
# Step-4: Wait till dump thread transfer is completed. |
| 12 |
# Step-5: Check that the data is there. |
| 13 |
# Step-6: Cleanup |
| 14 |
# kill the dump thread serving the mysqlbinlog --stop-never process |
| 15 |
include/stop_dump_threads.inc |
| 16 |
DROP TABLE t1; |