1connection master;
2--disable_warnings
3DROP DATABASE IF EXISTS mysqltest;
4--enable_warnings
5
6CREATE DATABASE mysqltest CHARSET UTF8;
7USE mysqltest;
8CREATE TABLE t (cl varchar(100)) CHARSET UTF8;
9
10if (!$LOAD_LOCAL)
11{
12  LOAD DATA INFILE '../../std_data/loaddata_utf8.dat' INTO TABLE t
13  FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
14}
15if ($LOAD_LOCAL)
16{
17  LOAD DATA LOCAL INFILE './std_data/loaddata_utf8.dat' INTO TABLE t
18  FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
19}
20
21save_master_pos;
22SELECT hex(cl) FROM t;
23
24connection slave;
25sync_with_master;
26USE mysqltest;
27SELECT hex(cl) FROM t;
28
29connection master;
30DROP DATABASE mysqltest;
31save_master_pos;
32connection slave;
33sync_with_master;
34