Alan, Thursday, October 31, 2002, 12:00:03 AM, you wrote: AM> This error comes up when altering table structure AM> BUT it times out after a while.
AM> Error: 7 - Error on rename of '.\DBNAME\tablename.MYI' to AM> '.\DBNAME\#sql2-61-19.MYI' (Errcode: 13) AM> Some have said - "oh yeah, that's a permissions problem" AM> but if it times out and finally the command executes after a while, then how AM> can it be a permissions problem. It's more likely that the server will not AM> allow change while connections are live... but I wait until the connections AM> are not there (in MySQLAdmin) and still the error persists for a while AM> longer. Finally it executes. AM> Is there something else at play here? Alan, there was a bug in Win distribution related to the lower_case_table_names=1. So, what is the exact name of the table? what is the output of SHOW VARIABLES LIKE "lower%"? What is the version of MySQL server? If you execute FLUSH TABLES first and then ALTER TABLE do you get this error? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
