diff options
Diffstat (limited to 'mysql-test/t/rpl000009.test')
-rw-r--r-- | mysql-test/t/rpl000009.test | 18 |
1 files changed, 10 insertions, 8 deletions
diff --git a/mysql-test/t/rpl000009.test b/mysql-test/t/rpl000009.test index 208e6f0b037..d45fe0870ff 100644 --- a/mysql-test/t/rpl000009.test +++ b/mysql-test/t/rpl000009.test @@ -1,5 +1,6 @@ -#this one assumes we are ignoring updates on tables in database foo, but doing -#the ones in database bar +# This one assumes we are ignoring updates on tables in database foo, but doing +# the ones in database bar + source include/master-slave.inc; connection master; drop database if exists foo; @@ -32,9 +33,10 @@ sync_with_master; drop database if exists bar; drop database if exists foo; -#now let's test load data from master +# Now let's test load data from master + +# First create some databases and tables on the master -#first create some databases and tables on the master connection master; set sql_log_bin = 0; create database foo; @@ -55,11 +57,11 @@ save_master_pos; connection slave; sync_with_master; -#this should show that the slave is empty at this point +# This should show that the slave is empty at this point show databases; load data from master; -#now let's check if we have the right tables and the right data in them +# Now let's check if we have the right tables and the right data in them show databases; use foo; show tables; @@ -68,7 +70,7 @@ show tables; select * from bar.t1; select * from bar.t2; -#now let's see if replication works +# Now let's see if replication works connection master; insert into bar.t1 values (4, 'four bar'); save_master_pos; @@ -76,7 +78,7 @@ connection slave; sync_with_master; select * from bar.t1; -#now time for cleanup +# Now time for cleanup connection master; drop database bar; drop database foo; |