Hi Error 13 is from the OS - nothing to do with locks or whatever.
However, when you add a new field (or change the table structure in (nearly) any way), mysqld will create a temporary table in the database directory - are you sure that the permissions on the directory are correct? Remember, it is the user running mysqld that needs the permissions, not the user running the command. HTH Quentin -----Original Message----- From: P.Agenbag [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 January 2002 6:14 a.m. To: mysql Subject: Error 13 Hi I have a table that I want to add a new field to while running on the server, however, when I try to add a new field, it comes up with the error13 message, saying it doesn't have permission, yet the files and folder are all chmod 777. Can it be due to the fact that there is a permanent connection to this table from another server and that mysql is preventing any major changes? Should I just try to make a copy of the table and make the changes to it and then overwrite the old one? Is there a "cleaner way of managing your tables and to make changes without having to resort to this "manual way"? Thanks --------------------------------------------------------------------- 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. --------------------------------------------------------------------- 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
