From: Hunt, Bryan (B.Hunt at domain emuse-tech.com)
Date: Fri 14 Jun 2002 - 09:45:15 IST
goddamnit I gota stop doing that !! Sorry for sending to list
--B
-----Original Message-----
From: John P. Looney [mailto:john at domain antefacto.com]
Sent: 14 June 2002 09:32
To: ilug at domain linux.ie
Cc: Niall O Broin
Subject: Re: [ILUG] MySQL backup
On Fri, Jun 14, 2002 at 12:27:46AM +0100, Niall O Broin mentioned:
> I know there are quite a number of people here using MySQL to greater or
> lesser extents. How are you dealing with backing up the databases ?
>
> i) Shut down database, copy / snapshot database files, start database
again.
> ii) mysqldump
> iii) mysqlhotcopy
> iv) Backing up the live files and hoping God is on your side
> v) Backups are for wimmin
vi) Have a second mysql instance, setup as a slave, which get pushed
changes as they happen, possibly on another machine. You can then take the
slave down whenever you want, and do proper backups that way. You can also
offer the slave as an option to your production software - connect to it,
if the master isn't responding.
Use replication Luke. Advanced technology designed to facilitate uptime &
backups.
Kate
-- _______________________________________ John Looney Chief Scientist a n t e f a c t o t: +353 1 8586004 www.antefacto.com f: +353 1 8586014 -- Irish Linux Users' Group: ilug at domain linux.ie http://www.linux.ie/mailman/listinfo/ilug for (un)subscription information. List maintainer: listmaster at domain linux.ie
This archive was generated by hypermail 2.1.6 : Thu 06 Feb 2003 - 13:17:15 GMT