summaryrefslogtreecommitdiff
path: root/mysql-test/suite/rpl/t/rpl_loaddata_simple.test
blob: 9e908cac677506cb99a68f6933e7eabbbe8b032e (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_ln/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;