RE: Backing up via slave

2008-01-23 Thread Martijn van den Burg
[EMAIL PROTECTED] > Sent: Wednesday, January 02, 2008 14:06 PM > To: Martijn van den Burg > Cc: Martin Goldman; mysql@lists.mysql.com > Subject: Re: Backing up via slave > > Hi Martijn, > Master will not have any information of SLAVE how r u doing > this in you second s

Re: Backing up via slave

2008-01-02 Thread Ananda Kumar
Hi Martijn, Master will not have any information of SLAVE how r u doing this in you second step. "- check the master servers to find out the names/ports of their slaves" regards anandkl On 1/2/08, Martijn van den Burg <[EMAIL PROTECTED]> wrote: > > Hi Martin, > > > Hi folks, > > > > I have two My

RE: Backing up via slave

2008-01-02 Thread Martijn van den Burg
Hi Martin, > Hi folks, > > I have two MySQL servers running in a master-slave > configuration, and I want to set up a process for backing up > our application's data in which backups are sent to a server > at another location. Ideally, I'd like to do a full backup > once a week, and then incr

Re: Backing up via slave

2007-12-24 Thread Martin Goldman
Thanks Baron. That actually looks like a pretty useful tool for monitoring replication -- I'll have to give that a shot. I did use ZRM once a few years ago, and I even thought about trying to use it this time around, but I couldn't find anything in the docs that explicitly described my particular

Re: Backing up via slave

2007-12-24 Thread Baron Schwartz
Hi, On Dec 24, 2007 1:35 AM, Martin Goldman <[EMAIL PROTECTED]> wrote: > Hi folks, > > I have two MySQL servers running in a master-slave configuration, and I want > to set up a process for backing up our application's data in which backups > are sent to a server at another location. Ideally, I'd

Backing up via slave

2007-12-24 Thread Martin Goldman
Hi folks, I have two MySQL servers running in a master-slave configuration, and I want to set up a process for backing up our application's data in which backups are sent to a server at another location. Ideally, I'd like to do a full backup once a week, and then incremental backups every 6 hours.