# 5.0 -\> 5.5 Replication Problems

**URL:** <https://forums.percona.com/t/5-0-5-5-replication-problems/1698>\
**Category:** Other MySQL® Questions\
**Created:** [November 1, 2011, 4:37am UTC](https://forums.percona.com/t/5-0-5-5-replication-problems/1698 "2011-11-01T04:37:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![DenisM](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DenisM](https://forums.percona.com/u/DenisM)\
**Post date:** [November 1, 2011, 4:37am UTC](https://forums.percona.com/t/5-0-5-5-replication-problems/1698/1 "2011-11-01T04:37:51Z")

</div>

Hi!  
I’m preparing 5.0 to 5.5 migration, so the replication is the first step.

Master: 5.0.67  
Slave: 5.5.16

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.

---

<div class="post-metadata">

**Author:** ![DenisM](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DenisM](https://forums.percona.com/u/DenisM)\
**Post date:** [November 2, 2011, 3:43am UTC](https://forums.percona.com/t/5-0-5-5-replication-problems/1698/2 "2011-11-02T03:43:15Z")

</div>

DenisM wrote on Tue, 01 November 2011 13:07

[QUOTE]  
The matter is that  
It seems the warning results from trigger which inserts into a MyISAM table.

---

<div class="post-metadata">

**Author:** ![DenisM](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DenisM](https://forums.percona.com/u/DenisM)\
**Post date:** [November 18, 2011, 4:05am UTC](https://forums.percona.com/t/5-0-5-5-replication-problems/1698/3 "2011-11-18T04:05:04Z")

</div>

DenisM wrote on Tue, 01 November 2011 13:07

> [@](#):
>
> [Warning] Invalid (old?) table or database name ‘#sql-12a6\_34’

This follows OPTIMIZE TABLE.