summaryrefslogtreecommitdiff
path: root/mysql-test/suite/rpl/t/rpl_loaddata_simple.test
blob: a09d3feec420e7e344da375d7c9a90fa33e68c32 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
--source include/master-slave.inc

CREATE TABLE t1 (word CHAR(20) NOT NULL);
LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t1;
SELECT * FROM t1 ORDER BY word;
sync_slave_with_master;

# Check
SELECT * FROM t1 ORDER BY word;

# Cleanup
connection master;
drop table t1;
sync_slave_with_master;
--source include/rpl_end.inc