MySQL Forums
Forum List  »  MyISAM

Deleted table file behavior!
Posted by: Eliezer Figueroa
Date: May 01, 2012 11:17PM

I just created a database and a table. I created 1 record in the table and query it. All worked just fine! Them I manually deleted the table .frm file and tried to do a select * on the table. To my surprise I still get to see the record. With the file deleted I created a new record and I got no errors! them I restarted the mysql service and restored the .frm

I query the table again and both record are there! the one created when the file was there and the one created while the .frm file was deleted. How is this posible?

I also noticed that I can copy a .frm file from one database to another and it will appear listed with a show tables but i get an error when I try to query it!

Options: ReplyQuote

Written By
Deleted table file behavior!
May 01, 2012 11:17PM
May 02, 2012 07:35PM
May 03, 2012 07:06PM

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.