Posted by himilecyclist on 09/07/05 22:56

Andy Hassall wrote:

> Why are you expecting the files to be unlocked?
>

I assumed when the application closed the database, the files would be
released.

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

Even after closing MySQL and the Apache server, the files are still
locked.

> Why are you renaming the files via the filesystem? To rename a table you use
> the RENAME SQL command.
>
I bumped into this by accident. I'm not concerned about renaming them,
just the fact that the connection still seems to be open.

Thanks!

> --
> 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]