~vkolesnikov/pbxt/pbxt-07-diskfull

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/t/rpl000017.test

  • Committer: paul-mccullagh
  • Date: 2006-10-23 09:14:04 UTC
  • Revision ID: paul-mccullagh-918861e03d351978a9541168a96e58cc826734ee
Initial import

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
source include/master-slave.inc;
 
2
connection slave;
 
3
stop slave;
 
4
connection master;
 
5
grant replication slave on *.* to replicate@localhost identified by 'aaaaaaaaaaaaaaab';
 
6
grant replication slave on *.* to replicate@127.0.0.1 identified by 'aaaaaaaaaaaaaaab';
 
7
connection slave;
 
8
start slave;
 
9
connection master;
 
10
--disable_warnings
 
11
drop table if exists t1;
 
12
--enable_warnings
 
13
create table t1(n int);
 
14
insert into t1 values(24);
 
15
sync_slave_with_master;
 
16
select * from t1;
 
17
connection master;
 
18
drop table t1;
 
19
delete from mysql.user where user="replicate";
 
20
sync_slave_with_master;
 
21
 
 
22
# End of 4.1 tests