rpl_drop_db.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- 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;
- drop database if exists mysqltest1;
- create database mysqltest1;
- create table mysqltest1.t1 (n int);
- insert into mysqltest1.t1 values (1);
- select * from mysqltest1.t1 into outfile 'mysqltest1/f1.txt';
- create table mysqltest1.t2 (n int);
- create table mysqltest1.t3 (n int);
- drop database mysqltest1;
- ERROR HY000: Error dropping database (can't rmdir './mysqltest1/', errno: 17)
- use mysqltest1;
- show tables;
- Tables_in_mysqltest1
- drop database mysqltest1;
- ERROR HY000: Error dropping database (can't rmdir './mysqltest1/', errno: 17)
- use mysqltest1;
- show tables;
- Tables_in_mysqltest1
- use test;
- create table t1 (n int);
- insert into t1 values (1234);
- use mysqltest1;
- show tables;
- Tables_in_mysqltest1
- use test;
- select * from t1;
- n
- 1234
- drop table t1;
- stop slave;