----- Original Message ----- From: "Kishore Jalleda" as per http://dev.mysql.com/doc/mysql/en/replication-compatibility.html there should be no problems On 8/17/05, Jeff <[EMAIL PROTECTED]> wrote: > Does anyone know if there are any problems replicating from a master > database on version 4.0.16 to a slave running version 4.1.13?
Well, there are a few differences between 4.0.x and 4.1.x that might cause some problems: http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html Lists most if not all of them. At a quarter of the page the block "Server changes" lists differences in the way tables are built internally, differences in comparing things, etc. Half way on that page the block "SQL changes" list incompatibilities in query syntax, etc. For example: - DELETE from multiple tables (" In MySQL 4.0, you should refer to the table names to be deleted with the true table name. In MySQL 4.1, you must use the alias (if one was given) when referring to a table name: ") http://dev.mysql.com/doc/mysql/en/delete.html There is no easy solution as the master (4.0) requires a different syntax than the slave (4.1). Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
