views:

14

answers:

0

hello,

i wanted to setup a new mysql database slave running a newer version of mysql => 5.1.41 than the master => 5.0.75, which -- as far as i know -- should normally be no problem. however, as it turns out setting up replication fails, because i used a SQL statement in 5.0.75 which apparently does not work in 5.1.41 anylonger:

the statement which causes the trouble looks like:

DELETE FROM tab1 t1
USING       tab1 t1, tab2 t2
WHERE       t2.field1 = ...
AND         t2.field2 = ...
AND         t1.field1 = t2.field2;

this statements runs perfectly on 5.0.75, on 5.1.41 i get the following error message in my slave status:

...
Last_SQL_Errno: 1064
Last_SQL_Error: Error 'You have an error in your SQL syntax; check the manual that      
                corresponds to your MySQL server version for the right syntax to 
                use near 't1
                USING       tab1 t1, tab2 t2
                ...
...

any ideas, what's going on and what to do?

thanks!

UPDATE

ok, i solved this problem by compiling 5.0.75 on the slave myself ... however, i would still be interested, what's going on and how to deal with such problems. thanks.