goddamnit I gota stop doing that !! Sorry for sending to list
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
> 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 &
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.iehttp://www.linux.ie/mailman/listinfo/ilug for (un)subscription information.
List maintainer: listmaster at linux.ie
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!