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

Advanced Search

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

Subject Views Written By Posted
Deleted table file behavior! 2678 Eliezer Figueroa 05/01/2012 11:17PM
Re: Deleted table file behavior! 1017 Rick James 05/02/2012 07:35PM
Re: Deleted table file behavior! 1046 Eliezer Figueroa 05/02/2012 10:25PM
Re: Deleted table file behavior! 1217 Rick James 05/03/2012 07:06PM
Re: Deleted table file behavior! 1035 Eliezer Figueroa 05/03/2012 10:00PM

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.