Either shut your mysql server down before making the backup or exclude your mysql directory from the backup and use mysqldump to dump the contents. (Which is what I do every night.) Then backup the dump.
Even if nobody is using the server, mysql still holds the files open. There are ways to backup open files but none of them are pretty. =C= * * Cal Evans * Techno-Mage * http://www.calevans.com * ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 8:08 AM Subject: make backup When I try to make a backup executing the sql: backup tb_name1, tb_name2 to 'c:\temp' and I have a error like "Failed copying .frm file: errno =3D 2" What I have to do in this case. Regards Alexander ________________________________________ A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
