On Sun, Aug 19, 2001 at 10:50:58PM +0200, Michael Großegesse wrote:
> Hi
>
> I'd like to know if it is possible to scp the database files to a
> backup server while mysql is still running on both machines?
As long as you are careful to flush and lock tables when you do it,
yes.
> Alternatively, is there any replication mechanism to keep the backup
> server up to date without shuting down mysql?
What about using MySQL's built-in replication?
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-max: up 2 days, processed 37,059,555 queries (144/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