On 1/2/02 at 3:32 PM, Robert Alexander wrote: > I'd suggest checking to see if you (or the user MySQL is running as) > have the necessary permissions to alter or rename a file in that > directory.
Some additional details. I can usually perform at least one ADD COLUMN successfully before I start getting this error. I also seem to be able to create databases and tables without a problem. This leads me to believe that th permissions are set properly. Once I get the error, I can't perform any more ALTER TABLE commands, but I am still able to search the database without any problems. CHECK TABLE reports that the table is OK until I perform a REPAIR TABLE command, after that CHECK TABLE reports that the last REPAIR TABLE failed. Restarting the MySQL service seems to correct whatever is wrong with the table and I am then able to do ADD COLUMN again (usually one successful call, then errors on subsequent calls). [fletcher] Original Message At 12:16 -0800 2002/01/02, Fletcher Sandbeck wrote: >This is with MySQL 3.23.42-nt on Windows 2000. > >I am issuing the following SQL statement and getting back an error message. > >ALTER TABLE Database.Table ADD COLUMN Field VARCHAR(255) > >error: 7, Error on rename of '.\Database\Table.MYI' to >'.\Database\#sql2-538-1.MYI' (Errcode: 13) > >A CHECK TABLE of the table says that it is OK, but a REPAIR TABLE reports an >error '13 when fixing table' and 'Operation Failed' as the final status. > >Any ideas of what is going wrong? > >[fletcher] -- Fletcher Sandbeck [EMAIL PROTECTED] Lasso Product Specialist [EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.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