There is one issue. MySQL changed the way it parsed SQL join statements in 5.03. Specifically JOINS in the older syntax using implicit joins {tables seperated by ","} i.e.
FROM table_a, table_b are parsed differently than they are in versions prior to 5.03. If you have any statements that do any implicit joins the statements that ran sucessfully on your 4.1 system may error out on your 5.0.? system. Full details on the change and it's impact on query design can be found here: http://dev.mysql.com/doc/refman/5.0/en/join.html -----Original Message----- From: Prasanna Raj [mailto:[EMAIL PROTECTED] Sent: Friday, March 03, 2006 6:28 AM To: Octavian Rasnita Cc: mysql@lists.mysql.com Subject: Re: replication Yes ..u can use older version as master and 5.0 version as slave http://dev.mysql.com/doc/refman/5.1/en/replication-compatibility.html http://linux.com.hk/penguin/developer/mysql/manual_Replication.html#Repl ication_Compatibility Ciao Praj On Fri, 3 Mar 2006 12:32:24 +0200 "Octavian Rasnita" <[EMAIL PROTECTED]> wrote: > Hi, > > I have 2 servers. On one of them I have MySQL 4.1 (the main server) and on > the second I have MySQL 5.0. > I want to use the second server to replicate the first server. Is it > possible or the servers should have the same version? > > Or I will need to install one more MySQL 4.1 on the second server and use it > for replicating the first server? > > Thank you. > > Teddy > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]