You are here: Re: Freeing .MYD and .MYI Files « PHP Programming Language « IT news, forums, messages
Re: Freeing .MYD and .MYI Files

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация