Hello, I am trying to develop a back-up procedure for our MySQL database. The database is housed on our production Web server. My thought is to simply make a slave on our file server that is backed up. I use InnoDB type tables and my application uses transactions. I am wondering how table/row locking works on the slave. Do I need to be concerned about disconnecting the salve from the master when back-ups are performed? Or does all the locking happen only on the master. Thanks a lot for any help! Regards, Aaron
--------------------------------------------------------------------- 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