|
|
Posted by Andy Jeffries on 10/20/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
Navigation:
[Reply to this message]
|