[ILUG] MySQL backup

[Hunt, Bryan]

goddamnit I gota stop doing that !! Sorry for sending to list 

--B

-----Original Message-----
From: John P. Looney [mailto:john at antefacto.com]
Sent: 14 June 2002 09:32
To: ilug at 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 linux.ie
http://www.linux.ie/mailman/listinfo/ilug for (un)subscription information.
List maintainer: listmaster at linux.ie