Re: replication, sort of (5.0.18)

2006-04-14 Thread Philippe Poelvoorde
2006/4/13, Duzenbury, Rich <[EMAIL PROTECTED]>: > Hi all, > > I have two servers that have production data on them, and then one > server where I would like to keep an active copy of the data. > > Currently, there is a job that runs in the middle of the night that > basically does a > mysqldump --h

replication, sort of (5.0.18)

2006-04-13 Thread Duzenbury, Rich
Hi all, I have two servers that have production data on them, and then one server where I would like to keep an active copy of the data. Currently, there is a job that runs in the middle of the night that basically does a mysqldump --host=production_server --all-databases | mysql --host=backup