Re: [PHP-DB] Data Synchronization... From: Jason Wong (phplist <email protected>)
Date: 07/16/02

On Wednesday 17 July 2002 01:52, NIPP, SCOTT V (SBCSI) wrote:
> This is actually more of a MySQL question, but here goes...
>
> I have two servers, one production and one development. I would
> like to use the development server as a backup for the production server.
> Is there a way to synchronize the MySQL databases between these two
> servers? I imagine that I could just copy over the MySQL data directory on
> a nightly basis, but is there a more elegant way of doing this? Thanks.

mysql manual > replication

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *

/* I'm having fun HITCHHIKING to CINCINNATI or FAR ROCKAWAY!! */

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php