MySQL Forums
Forum List  »  Newbie

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,

Options: ReplyQuote

Written By
Re: Deleted table file behavior!
May 02, 2012 05:57PM

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.