On Wed, Aug 29, 2001 at 12:50:06PM -0600, Matthew Walker wrote:
>
> What's the best way of doing a hot backup on a database? Our server
> is set up in such a way that it's not a simple matter to shut down
> apache/mysql and do the backup then. So, is it safe to just copy the
> mysql directories, or is there some recommended procedure for this?
Another method (that nobody has mentioned) is to use mysqlsnapshot
(formerly myrepl):
http://jeremy.zawodny.com/mysql/mysqlsnapshot/
Thought it is designed to making a replication snapshot, you can use
it to make an on-line backup (if you don't mind locking your tables
for the time needed to make the backup).
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41: up 0 days, processed 1,826,583 queries (78/sec. avg)
---------------------------------------------------------------------
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
