rpl_loaddatalocal.result 865 Bytes
Newer Older
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1
stop slave;
2 3 4 5
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;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
6
start slave;
7
create table t1(a int);
8
select * into outfile 'MYSQLTEST_VARDIR/master-data/rpl_loaddatalocal.select_outfile' from t1;
9
truncate table t1;
10
load data local infile 'MYSQLTEST_VARDIR/master-data/rpl_loaddatalocal.select_outfile' into table t1;
11 12 13 14
select a,count(*) from t1 group by a;
a	count(*)
1	10000
drop table t1;
15 16
create table t1(a int);
insert into t1 values (1), (2), (2), (3);
17
select * into outfile 'MYSQLTEST_VARDIR/master-data/rpl_loaddatalocal.select_outfile' from t1;
18 19
drop table t1;
create table t1(a int primary key);
20
load data local infile 'MYSQLTEST_VARDIR/master-data/rpl_loaddatalocal.select_outfile' into table t1;
21
SELECT * FROM t1 ORDER BY a;
22 23 24 25
a
1
2
3
26
SELECT * FROM t1 ORDER BY a;
27 28 29 30 31
a
1
2
3
drop table t1;