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