Hello Ian Simpson, Thank you for reply. We defined table names, fields in lower cases except the KEYS . I hope the Key will not taken into the account[all in upper case].
Regarding the version we will keep same version as you said. Thank you --- On Thu, 18/3/10, Ian Simpson <i...@it.myjobgroup.co.uk> wrote: From: Ian Simpson <i...@it.myjobgroup.co.uk> Subject: Re: Replication - LINUX to WIN To: "Vikram A" <vikkiatb...@yahoo.in> Cc: "MY SQL Mailing list" <mysql@lists.mysql.com> Date: Thursday, 18 March, 2010, 9:33 AM Hi Vikram, There are a couple of potential problems with Linux to Windows replication, but they are easily avoidable. 1) Table names: There are case-sensitivity differences between Linux and Windows: Linux is case-sensitive as regards table names, whereas Windows is not. Given that you are replicating from a Linux master to a Windows slave, you shouldn't hit too many problems with this, but if you ever reverse the order for some reason there could be problems. 2) MySQL versions: try to make sure that you always use the same version of MySQL on client and slave (this is generally good replication advice in all cases). There have been some bugs in replication that cause problems when the master and slave are on different versions. On Thu, 2010-03-18 at 14:03 +0530, Vikram A wrote: > Hi, > I have done replication with Win to Win servers with mysql version > 5.0.41-community-nt. > > Now, > We have Enterprise Linux(Red Hat 4.1.2-14) and windows server2003. > Is it possible do the replication LINUX(Master) to WINDOWS SERVER2003(Slave) ? > > It will be great help to me. > > Thank you. > > VIKRAM A > > > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. >http://in.yahoo.com/ -- Ian Simpson System Administrator MyJobGroup The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
