can you provide a testcase would justify 2 different DB schemas?If you're willing to stay with identical configurations take a look at http://dev.mysql.com/doc/refman/5.0/en/replication.htmlHTHMartin ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > Date: Mon, 1 Sep 2008 17:58:10 +0530> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> CC: mysql@lists.mysql.com> Subject: Re: sync> > Mad Unix wrote:> > I was wandering if anyone know a good way to sync 2mysql databases _one_way> > The mysql is alocated on a web php application> Do they (DB) need to be identical ? Have you checked replication ?> > Regards,> Ranjeet Walunj> > > > -- > MySQL General Mailing List> For list archives: http://lists.mysql.com/mysql> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]> _________________________________________________________________ Get thousands of games on your PC, your mobile phone, and the web with Windows®. http://clk.atdmt.com/MRT/go/108588800/direct/01/