mySQL 5.0.11 sources for tomato
[tomato.git] / release / src / router / mysql / mysql-test / suite / engines / funcs / r / rpl_server_id2.result
blobd50814022d89790b3d9df82a8b883ac56d1a8982
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 create table t1 (n int);
8 reset master;
9 stop slave;
10 change master to master_port=SLAVE_PORT;
11 show slave status;
12 Slave_IO_State  Master_Host     Master_User     Master_Port     Connect_Retry   Master_Log_File Read_Master_Log_Pos     Relay_Log_File  Relay_Log_Pos   Relay_Master_Log_File   Slave_IO_Running        Slave_SQL_Running       Replicate_Do_DB Replicate_Ignore_DB     Replicate_Do_Table      Replicate_Ignore_Table  Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table     Last_Errno      Last_Error      Skip_Counter    Exec_Master_Log_Pos     Relay_Log_Space Until_Condition Until_Log_File  Until_Log_Pos   Master_SSL_Allowed      Master_SSL_CA_File      Master_SSL_CA_Path      Master_SSL_Cert Master_SSL_Cipher       Master_SSL_Key  Seconds_Behind_Master   Master_SSL_Verify_Server_Cert   Last_IO_Errno   Last_IO_Error   Last_SQL_Errno  Last_SQL_Error
13         127.0.0.1       root    SLAVE_PORT      1               4       slave-relay-bin.000001  4               No      No                                              #       0               0       0       106     None            0       No                                              NULL    No      0               0       
14 start slave;
15 insert into t1 values (1);
16 select * from t1;
20 stop slave;
21 drop table t1;