~drizzle-trunk/drizzle/development

stop slave;

drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;

reset master;

reset slave;

drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;

start slave;

create table t1 (n int);

reset master;

stop slave;

change master to master_port=SLAVE_PORT;

show slave status;

Slave_IO_State	

Master_Host	127.0.0.1

Master_User	root

Master_Port	SLAVE_PORT

Connect_Retry	1

Master_Log_File	

Read_Master_Log_Pos	4

Relay_Log_File	slave-relay-bin.000001

Relay_Log_Pos	4

Relay_Master_Log_File	

Slave_IO_Running	No

Slave_SQL_Running	No

Replicate_Do_DB	

Replicate_Ignore_DB	

Replicate_Do_Table	

Replicate_Ignore_Table	

Replicate_Wild_Do_Table	

Replicate_Wild_Ignore_Table	#

Last_Errno	0

Last_Error	

Skip_Counter	0

Exec_Master_Log_Pos	0

Relay_Log_Space	107

Until_Condition	None

Until_Log_File	

Until_Log_Pos	0

Master_SSL_Allowed	No

Master_SSL_CA_File	

Master_SSL_CA_Path	

Master_SSL_Cert	

Master_SSL_Cipher	

Master_SSL_Key	

Seconds_Behind_Master	NULL

Master_SSL_Verify_Server_Cert	No

Last_IO_Errno	#

Last_IO_Error	#

Last_SQL_Errno	0

Last_SQL_Error	

start slave;

insert into t1 values (1);

select * from t1;

n

1

1

stop slave;

drop table t1;