Re: Error Code 13 when using ALTER TABLE
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
RE: Error Code 13 when using ALTER TABLE
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
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
Re: Error code 13
Hi, This sounds like a permissions problem. Make sure your database directory is set to 770 and that the files inside (tables) are set to 660. example: # chmod 770 demo # chmod 660 demo/* Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico <___/ - Original Message - From: "Rashid Zolqarnain" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 5:17 PM Subject: Error code 13 > Hello, > I copy a database "demo" from one server to another. The file > types are the same as other databases that exist in the destination > server. I stopped and restarted mysql server. When I try to use that > database using the command > "use demo" > it gives me the following error > "Error code 13 can't read ./demo" > What could be be problem? > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) - 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