I have been getting this same error. I am not able to Alter or Drop Tables. I am definately sure that I have the necessary permissions. This has happened on all of my recent installs of MySQL on windows XP and 2000 advanced server. I would appreciate any knowlege on this matter. Getting tired of shutting down the server and deleting the tables just to alter a feild.
Thanks, Stephen Rainey -----Original Message----- From: Robert Alexander [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 12:33 PM To: Fletcher Sandbeck Cc: [EMAIL PROTECTED] Subject: Re: Error Code 13 when using ALTER TABLE 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. /Rob 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] -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive --------------------------------------------------------------------- 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