[geeks] Mysql backup questions...

[Gregory Leblanc]

On Mon, 2005-04-11 at 23:16 -0500, Bill Bradford wrote:
> So, this is what I'm using to backup MySQL on a nightly basis (this file
> is then rsynced to an offsite machine).  Any tips on optimization or
> improvements?  I'm running 4.10.

The way we do backups is to stop the database (I think), do a
mysqlhotcopy of all of the databases to another directory, then copy
those in bulk offsite.  So far, it's worked well, and it leaves us with
a copy of "yesterday's" databases handy, for when folks screw things up.
Alas, I haven't figured out how to get those online for "partial"
database restores yet.
	Greg