Just to think about this. This is Mysql specific.

Using temporary tables can break Mysql replication as stated here:

http://dev.mysql.com/doc/refman/5.5/en/replication-features-temptables.html

I've just recovered a slave (mixed binary logging) because a missing backup_ids_temp table after a server restart.

Maybe a temporary table may be an "ordinary" table that is dropped after used.

What do you think about this?

Thanks in advance.