Egor, Yours/this arrived in my InBox whilst I was addressing the original msg - please see my other reply/ies. Error still occurs when running as Administrator on WinNT and root under MySQL - definitely no access/permission issues. Lower case works (please see earlier reply).
If I/my NT PC can be of assistance, please don't hesitate to request further clarification/experimentation. Regards, =dn WinNT 4.0 SP6a, PHP vn 4.0.6, Apache vn 1.3.20WinNT, MySQL vn 3.23.40-nt ----- Original Message ----- From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 15 February 2002 11:00 Subject: Suspected Bug > Fred, > > Friday, February 15, 2002, 8:53:17 AM, you wrote: > > FL> MySQL is awesome, but I think I found a bug. > > FL> The following script: > > 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 names. The problem > FL> does not happen when the table names 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. > > FL> MySQL version: 3.23.47-nt > FL> Running on Windows 2000 Pro > > FL> Feel free to contact me if there are any questions. > > > > > > -- > For technical support contracts, goto https://order.mysql.com/ > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.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 > > --------------------------------------------------------------------- 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
