I’m preparing 5.0 to 5.5 migration, so the replication is the first step.
I get different unclear warnings at the slave as follow:
[Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them. Statement: UPDATE im_config SET conf_value = ‘602’ WHERE config_name = ‘ReplDelay’
The matter is that is an InnoDB table.
[Warning] Invalid (old?) table or database name ‘#sql-12a6_34’
Probably this is a temporary table. Where does it come to light from? I haven’t such warning in 5.0 to 5.0 replication.