Well I know about it and I am working on MySQL Replication, the point is that you dont have control over replicatation when your MySQL server is installed by your ISP on shared server,
In that case it is simply not possible :) Moreover, the simple setup I have, I prefer this then the nittygritties of replication. Agreed, if you have a heavy duty setup then the only answer is MySQL replication. Karam --- love <[EMAIL PROTECTED]> wrote: > It is very easier with mysql replication concipt, > this automatic > replication from Master server to Slave server and > real time. I wonder > how you do not know about this. > > http://dev.mysql.com/doc/mysql/en/replication.html > > Love kumar .. > > [EMAIL PROTECTED] wrote: > > > SQLyog Enterprise's Database Sync Tool is the > answer > > for your queries. > > > > www.webyog.com > > > > Rgds, > > Karam > > --- Paul Godard <[EMAIL PROTECTED]> wrote: > > > > > Hi > > > > > > I use mysql/php on several client web sites > (each > > > client has its own > > > db). For development purpose, I have a local > web > > > server with > > > php/mysql. When a web site is still in > development, > > > this is the > > > master db, even if a copy has been uploaded on > the > > > live web server at > > > my isp. When a site is completed, the web db > > > becomes the master (as > > > clients and visitors are updating data on the > web > > > db). > > > > > > My problem is that I would like to keep the > local db > > > synchronized > > > with the web db (at least for the tables that > are > > > regularly updated > > > on the web). Manually I would do a dump (data > > > export only) of these > > > web tables onto a local file, then empty the > local > > > equivalent tables > > > and then running the sql statements of the dump > file > > > (insert). > > > > > > I don't do a systematic download of the whole > web db > > > as it is > > > sometimes too big and besides not all the tables > are > > > updated by the > > > client/visitors. > > > > > > My idea is to dynamically build a mysql script > via > > > php that can do > > > the job for each client web sites for each of > the > > > tables contained in > > > an array and be executed from a simple click on > a > > > button on the local > > > server of course. > > > > > > As I am not a mysql/php guru, I would appreciate > > > suggestions to do > > > this as simple as possible. > > > > > > Please copy the reply to my email address. > Thanks > > > in advance. > > > -- > > > > > > Kind regards, Paul. > > > > > > Gondwana > > > [EMAIL PROTECTED] > > > http://www.gondwanastudio.com > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > > > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Meet the all-new My Yahoo! - Try it today! > > http://my.yahoo.com > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > The information transmitted is intended only for > the person or entity > > to whom it is addressed and may contain > confidential and / or > > privileged Material. Any review, re-transmission, > dissemination or > > other use of or taking of any action in reliance > upon, this > > information by persons or entities other than the > intended recipient > > is prohibited. If you received this in error, > please contact the > > sender and delete the material from your computer. > Thank you for your > > understanding & co-operation. > > > > > > __________________________________ Do you Yahoo!? All your favorites on one personal page – Try My Yahoo! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
