Description: When using an update log as a backup to be able to re-create a database, DML commands using user variables are logged as sent to the server, but the values of the user-variables are not. I ran into some trouble because i was using the update-log as primary backup for the databases on our company web-server and needed to recreate a database from a one week old backup and the update-log. I do not know if the problem is the same with the binary log or with replication. Please keep me informed on this topic. I set the priority to critical because there is a posibility of data loss even when backups are used.

How-To-Repeat: start mysqld with --log-update

then execute the following: USE test; CREATE TABLE test(a int); SET @var=5; INSERT INTO test(a) VALUES (@var);

the update-log contains: USE test; CREATE TABLE test(a int); INSERT INTO test(a) VALUES (@var);

which is not very useful.

Fix:

Exectutable: any Environment: any System: any Compiler: any Architecture: any