-- $Id: mysql_crash.sql 5880 2005-08-10 16:49:08Z wpc0756\Emmanuel $ -- You need a temporary table (even empty, even useless) CREATE TEMPORARY TABLE mysql_crash.my_temporary_table(id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY) ; -- You also need a user variable SET @id := 1 ; -- You need a SQL query that updates the database so it would be logged in binary log -- This query must be using the above variable DELETE FROM mysql_crash.my_table WHERE id LIKE @id ;