source include/master-slave.inc; connection master; CREATE TABLE `t1` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; insert into t1 values (1,0x486C61766EC3AD206DC49B73746F205072616861), (2,0x5374C59965646FC48D65736BC3BD206B72616A), (3,0x4A69686FC48D65736BC3BD206B72616A), (4,0x506C7A65C588736BC3BD206B72616A), (5,0x4B61726C6F766172736BC3BD206B72616A); --exec $MYSQL_DUMP --extended-insert=FALSE test t1 > var/bug26836.sql SET NAMES utf8; select * from t1; select id,hex(name) from t1; select * into outfile 'test.bug26836' from t1; load data infile 'test.bug26836' replace into table t1; select id,hex(name) from t1; sleep 5; connection slave; select id,hex(name) from t1; connection master; set character_set_database =utf8; load data infile 'test.bug26836' replace into table t1; select id,hex(name) from t1; sleep 5; connection slave; select id,hex(name) from t1;