Posted by Andy Hassall on 09/07/05 22:41

On 7 Sep 2005 12:30:09 -0700, himilecyclist@yahoo.com wrote:

>After running my PHP/MySQL application, I have found that the
>associated .MYD and .MYI files remain locked. Even after the browser
>is closed, if I try to rename these files, I get the message:
>
>Can't rename filename. It is being used by another person or
>program...
>
>These files remain locked until I reboot. I'm running on a Windows XP
>machine.
>
>After running this snippet and closing the browser, files
>edenmaster.myd and edenmaster.myi are locked to renaming until a
>reboot.
>
>I thought the mysql_close() would free the files, but it does not.

Why are you expecting the files to be unlocked?

The MySQL server daemon will have them open, and there's no reason for it to
close the files whilst it's running.

Why are you renaming the files via the filesystem? To rename a table you use
the RENAME SQL command.

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Back to original message]