Posted by Andy Jeffries on 12/25/50 11:46

On Mon, 01 May 2006 17:09:46 +0000, Gordon Burditt wrote:

>>> If you're just doing backups, you can also just tarzip the mysql data
>>> dir and do a quick and dirty backup that way.
>
> "dirty" is a good word for it. Unless you make sure that all changes have
> been flushed to disk, and that no other changes are made during making the
> backup, what you save may not be up to date (or even consistent). For
> example, shut down the server (cleanly) first.

Or use mysqlhotcopy and leave the server running...

http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html

Cheers,


Andy

--
Andy Jeffries MBCS CITP ZCE | gPHPEdit Lead Developer
http://www.gphpedit.org | PHP editor for Gnome 2
http://www.andyjeffries.co.uk | Personal site and photos

[Back to original message]