~drizzle-trunk/drizzle/development

1 by brian
clean slate
1
stop slave;
2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
3
reset master;
4
reset slave;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6
start slave;
7
8
**** On Master ****
9
CREATE TABLE t1 (b CHAR(10));
10
11
**** On Slave ****
12
STOP SLAVE;
13
14
**** On Master ****
15
LOAD DATA INFILE FILENAME
16
SELECT COUNT(*) FROM t1;
17
COUNT(*)
18
3
19
SHOW BINLOG EVENTS;
20
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
21
master-bin.000001	#	Format_desc	1	#	Server ver: #
22
master-bin.000001	#	Query	1	#	use `test`; CREATE TABLE t1 (b CHAR(10))
23
master-bin.000001	#	Begin_load_query	1	#	;file_id=#;block_len=#
24
master-bin.000001	#	Execute_load_query	1	#	use `test`; LOAD DATA INFILE FILENAME ;file_id=#
25
26
**** On Slave ****
27
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
28
START SLAVE;
29
SELECT COUNT(*) FROM t1;
30
COUNT(*)
31
0
32
33
**** On Master ****
34
DROP TABLE t1;