On Tue, Jan 30, 2001 at 05:07:40PM -0800, Scott Baker wrote:
> That's the way that I do. I setup my server to shutdown the MySQL
> process at 3am, zip up my var directory, and then restart the
> process. Can you copy the data with the server running?
Certainly can.
I do nightly on-line backups with a script that I wrote a while
back. You can safely do it if you flush tables and then obtain a read
lock on the tables.
The `mysqlhotcopy' script does something similar I think. It's
distributed with recent versions of MySQL.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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