Hi!

Franklin> How-To-Repeat: Franklin> Using MySQL 4.0.1 on Windows 2000, I open 2 command shells and do
"mysql Franklin> test" in each.

Franklin> Then in shell 1 I do:

Franklin> create table Z (i int);

Franklin> Then in shell 2 I do:

Franklin> select * from Z;

Franklin> Then in shell 1 I do:

Franklin> rename table Z to Z2;

Franklin> which results in:

Franklin> ERROR 7: Error on rename of '.\test\Z.MYI' to '.\test\Z2.MYI'
(Errcode: Franklin> 13)

I have tested the above commands on NT 4.0.1381 with MySQL 4.0.1 and 2 shells without any problems.

When you do a rename, MySQL is first going to close all the involved tables and then do the rename.

I don't know why, but somehow this doesn't seem to happen on your system :(

Could you try to start mysqld as follows:

mysqld --standalone --debug

and then try the above commands.

If this still failes, then please ftp the file:

c:\mysqld.trace

to ftp://support.mysql.com/pub/mysql/secret

and send an email to this list and we will try to figure out what could be wrong.

Regards, Monty