FLUSH TABLES WITH READ LOCK; FLUSH LOGS; SET GLOBAL binlog_format = 'MIXED'; /*possible values: STATEMENT, ROW, MIXED*/ FLUSH LOGS; UNLOCK TABLES; RESET MASTER; /*This starts the Master over again with new bin log format*/