Skip navigation links

MySQL Forums :: Newbie :: Deleted table file behavior!


Advanced Search

Re: Deleted table file behavior!
Posted by: Barry Galbraith ()
Date: May 02, 2012 05:57PM

I'll take a punt.
I'm guessing your tables are InnoDB. The .frm is for the contruction/layout for the table, but the indexes and data are stored in ibdata file. The table layout is being read into RAM so even if you delete the .frm file, MySQL still knows how the table is built, and can still store the data until the table contruction is pushed from RAM, or the server is restarted.

The bottom line is don't delete MySQL files. Let the server manage them.

Good luck,
Barry.

Options: ReplyQuote


Subject Written By Posted
Deleted table file behavior! Eliezer Figueroa 05/01/2012 11:12PM
Re: Deleted table file behavior! Barry Galbraith 05/02/2012 05:57PM
Re: Deleted table file behavior! Eliezer Figueroa 05/02/2012 10:19PM
Re: Deleted table file behavior! Barry Galbraith 05/02/2012 10:52PM
Re: Deleted table file behavior! Phillip Ward 05/03/2012 06:28AM
Re: Deleted table file behavior! Eliezer Figueroa 05/03/2012 12:44PM
Re: Deleted table file behavior! Rick James 05/05/2012 01:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.