| 1 |
# Preparing script without compression |
| 2 |
# Testing with compressed protocol now |
| 3 |
RESET MASTER; |
| 4 |
include/stop_dump_threads.inc |
| 5 |
# Step-1: Execute some dummy statements. |
| 6 |
CREATE TABLE t1(i int); |
| 7 |
INSERT INTO t1 values (1); |
| 8 |
# Step-2: Execute MYSQL_BINLOG with --stop-never and --raw option. |
| 9 |
# Step-3: Wait till dump thread transfer is completed. |
| 10 |
# Step-4: copy binary log file that is downloaded till now before |
| 11 |
# stopping dump thread that is serving mysqlbinlog |
| 12 |
# --stop-never process. |
| 13 |
# Step-5: kill the dump thread serving the mysqlbinlog --stop-never process |
| 14 |
include/stop_dump_threads.inc |
| 15 |
# Step-6: Cleanup the data, so that it is ready for reapply. |
| 16 |
DROP TABLE t1; |
| 17 |
RESET MASTER; |
| 18 |
# Step-7: Apply the data that we got from --stop-never process. |
| 19 |
# Step-8: Check that the data is there. |
| 20 |
include/assert.inc [Check the table t1 exists and contains one tuple with value 1.] |
| 21 |
# Step-9: Cleanup |
| 22 |
DROP TABLE t1; |
| 23 |
RESET MASTER; |
| 24 |
include/stop_dump_threads.inc |
| 25 |
# Step-1: Execute some dummy statements. |
| 26 |
CREATE TABLE t1(i int); |
| 27 |
INSERT INTO t1 values (1); |
| 28 |
# Step-2: Execute MYSQL_BINLOG with --stop-never and --raw option. |
| 29 |
# Step-3: Wait till dump thread transfer is completed. |
| 30 |
# Step-4: copy binary log file that is downloaded till now before |
| 31 |
# stopping dump thread that is serving mysqlbinlog |
| 32 |
# --stop-never process. |
| 33 |
# Step-5: kill the dump thread serving the mysqlbinlog --stop-never process |
| 34 |
include/stop_dump_threads.inc |
| 35 |
# Step-6: Cleanup the data, so that it is ready for reapply. |
| 36 |
DROP TABLE t1; |
| 37 |
RESET MASTER; |
| 38 |
# Step-7: Apply the data that we got from --stop-never process. |
| 39 |
# Step-8: Check that the data is there. |
| 40 |
include/assert.inc [Check the table t1 exists and contains one tuple with value 1.] |
| 41 |
# Step-9: Cleanup |
| 42 |
DROP TABLE t1; |
| 43 |
RESET MASTER; |
| 44 |
CREATE TABLE t1(i int); |
| 45 |
INSERT INTO t1 values (1); |
| 46 |
DROP TABLE t1; |
| 47 |
# test mysqlbinlog '-C' option with --raw |
| 48 |
# test mysqlbinlog '--compress' option without --raw |
| 49 |
RESET MASTER; |