James Ervin wrote:
>
> Can you restore from a backup of the mysql data directory or do you need to
> dump the database in order to be able to restore? I have seen some traffic
> on the list that suggests that a dump is the way to go. I backup the data
> directory each night, but I would hate to find out that that is not the way
> to go if/when things go bad.
>
> James Ervin
Restore from a copy of the directory is the fastest way to recover
(short
of replication). Just make sure that when you copy the files you
do some intellegent copying.
shutdown the server before copying
OR
use mysqlhotcopy
OR
write your own scheme to lock the flush and lock the tabkes you need
before
copying.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
