* Egor Egorov > FL = Fred Lovine > FL> CREATE TABLE X1 (x smallint); > FL> insert into X1 values(5); > FL> RENAME TABLE X1 TO X2; > > FL> is producing the following error: > > FL> 7 - Error on rename '.\<db>\X1.MY1' to '.\<db>\X2.MYI' (Errcode: 13) > > FL> The problem seems to be caused by using uppercase table > FL> names. The problem does not happen when the table names > FL> are all lowercase. > > $ perror 13 > Error code 13: Permission denied > When you rename table, you also rename files that are appropriate to this > table. You don't have file permission to rename files in mysql data dir.
Do you mean this is the desired behaviour? Also, this does not explain why it only happens when the name is uppercase. -- Roger query --------------------------------------------------------------------- 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
