summaryrefslogtreecommitdiff
path: root/mysql-test/suite/rpl/t/rpl_loaddata_simple.test
blob: 439c2b48ca5aacb3f433389f5e0781ff8ea27491 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
--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;