Re: backup/synchronize tables/db web->local server

2005-02-09 Thread Karam Chand
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 nittygrittie

Re: backup/synchronize tables/db web->local server

2005-02-09 Thread love
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

Re: backup/synchronize tables/db web->local server

2005-02-09 Thread Karam Chand
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/

Re: backup/synchronize tables/db web->local server

2005-02-09 Thread Coz Web
The mySQL command should read : mysql -u username -p[password] db_name < dumpfile Note that you can give the password on the command line but it is best to get into the habit of just providing -p and typing in the password when prompted. BTW, when doing the mysqldump for tables that already exis

Re: backup/synchronize tables/db web->local server

2005-02-09 Thread Coz Web
On Wed, 9 Feb 2005 15:48:12 +0200, Paul Godard <[EMAIL PROTECTED]> wrote: > >On Wed, 9 Feb 2005 13:10:16 +0200, 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 se

Re: backup/synchronize tables/db web->local server

2005-02-09 Thread Coz Web
On Wed, 9 Feb 2005 13:10:16 +0200, 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, ev

backup/synchronize tables/db web->local server

2005-02-09 Thread Paul Godard
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 co