source include/master-slave.inc; DROP TABLE IF EXISTS t4; CREATE TABLE t4 ( x int(11) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!50001 DROP VIEW IF EXISTS v12*/; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50001 VIEW v12 AS select t4.x AS x from t4 where t4.x < 3 */ /*!50002 WITH CHECK OPTION */; save_master_pos; connection slave; sync_with_master;