--source include/master-slave.inc connection slave; stop slave; change master TO MASTER_AUTO_POSITION = 1; start slave; sleep 10; connection master; CREATE TABLE `item` (`id` int(11) NOT NULL AUTO_INCREMENT,`item` varchar(10), PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; insert into item(item) values ('test1') ; flush logs; insert into item(item) values ('test2') ; flush logs; insert into item(item) values ('test3') ; flush logs; insert into item(item) values ('test4') ; show master status; PURGE BINARY LOGS TO 'master-bin.000002'; insert into item(item) values ('test5') ; show master status; --sync_slave_with_master --vertical_results show slave status; stop slave; start slave; sleep 10; show slave status;