[geeks] Mysql backup questions...

[Patrick Giagnocavo]

On Mon, Apr 11, 2005 at 09:23:02PM -0700, Gregory Leblanc wrote:
> 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.

Seems to me I read of a situation where you could "tail -f" the SQL
statements as they went by; thus replaying the SQL captured to a file
on a different host or different MySQL database would thus get you a
working copy of the database.

--Patrick