We never dump the data just shutdown the slave, copy the data
directory and restart the slave. This practice is trustworthy
probably only where the servers are running on the same platform, mysql
server version and operating system.
-Kieran
___
Subject: Re: Backing up live MySQL Databases
Le Thursday 16 June 2005 17:06, Jeff McKeon("Jeff McKeon"
<[EMAIL PROTECTED]>) disait:
Hello,
> Anyone using any third party products like Arkeia that enable you
> to do a live backup of MySQL database?
I've tried Arkeia
ting the server down and copying
the files.
Cheers,
-Dana
-Original Message-
From: Glennie Vignarajah [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 16, 2005 12:50 PM
To: mysql@lists.mysql.com
Subject: Re: Backing up live MySQL Databases
Le Thursday 16 June 2005 17:06, Jeff McKeon(&q
Yes, that's the way we currently do it but we were looking for more
options.
Jeff
> -Original Message-
> From: Kieran Kelleher [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 16, 2005 11:26 AM
> To: Jeff McKeon
> Cc: mysql@lists.mysql.com
> Subject: Re: Backing
Le Thursday 16 June 2005 17:06, Jeff McKeon("Jeff McKeon"
<[EMAIL PROTECTED]>) disait:
Hello,
> Anyone using any third party products like Arkeia that enable you
> to do a live backup of MySQL database?
I've tried Arkeia few months ago. The online backup and restore of
MySql databases worked
I have a master-slave replication setup. A scheduled backup script on
the slave runs automatically at regular intervals.
The script slave does this:
shutdown the mysql server on the slave
backup the mysql data directory to backup media
restart the mysql server on the slave.
Using a setup like t
