[TriLUG] Backing up mail and MySql

[David McDowell]

Funny when I read that link to mysql backup page... everyone says my
method of backups is not a good one.  I simply stop mysql, copy the
files from /var/lib/mysql to my backup location, start mysql and walk
away.  You will notice on that link it is clearly written as an
acceptable method of backup.  Those who told me know who you are!  ;)

"You can also simply copy all table files (`*.frm', `*.MYD', and
`*.MYI' files) as long as the server isn't updating anything."

Obviously if mysql is stopped, the server won't be updating anything. 
I realize this method means my databases are down for a very short
time.  I would most likely look into other options if stopping my
database was an issue.  :)

my $0.01,
David McD

On Fri, 24 Dec 2004 08:48:00 -0500, Matt Frye <mattfrye at gmail.com> wrote:
> > > 2) MySql - I've got a few web apps which are using MySql databases.
> > > Everythings in MyIsam format. I figure that I'll periocally back these
> > > up to a directory using something like the mysqlhotcopy script, and
> > > then let rsbackup take incremental backups from there.
> > >
> > > Any comments or advice?
> >
> > Follow the directions: http://dev.mysql.com/doc/mysql/en/Backup.html
> 
> There's also a fairly elegant method of doing selective backups on
> MySql using PHP, which is presented in the November issue of Sysadmin
> magazine.  I used to do full dumps all the time, but this new method
> allows me to restore parts of the database, i.e. specific tables,
> while the db is still up.  It's also useful for "high traffic"
> databases.
> 
> MPF
> --
> TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
> TriLUG Organizational FAQ  : http://trilug.org/faq/
> TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
> TriLUG PGP Keyring         : http://trilug.org/~chrish/trilug.asc
>