This error comes up when altering table structure BUT it times out after a while.
Error: 7 - Error on rename of '.\DBNAME\tablename.MYI' to '.\DBNAME\#sql2-61-19.MYI' (Errcode: 13) Some have said - "oh yeah, that's a permissions problem" but if it times out and finally the command executes after a while, then how can it be a permissions problem. It's more likely that the server will not allow change while connections are live... but I wait until the connections are not there (in MySQLAdmin) and still the error persists for a while longer. Finally it executes. Is there something else at play here? Alan ' Keywords: ' myODBC, mySQL, ' Error: ' Error: 7 - Error on rename of '.\DBNAME\tablename.MYI' to '.\DBNAME\#sql2-61-19.MYI' ' (Errcode: 13) ' Environment: ' WkStn - Windows 2000 WkStn, 512 meg, Pentium 1000 mhz, build 2195, SP3 ' myODBC 3.51 - WinX ' ' Server - Windows NT 4.0 Server SP6, 256 meg, Pentium II 450 mhz ' mySQL - 3.23.52 - NT --------------------------------------------------------------------- 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