Skip navigation links

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! 1648 Eliezer Figueroa 05/01/2012 11:17PM
Re: Deleted table file behavior! 666 Rick James 05/02/2012 07:35PM
Re: Deleted table file behavior! 710 Eliezer Figueroa 05/02/2012 10:25PM
Re: Deleted table file behavior! 820 Rick James 05/03/2012 07:06PM
Re: Deleted table file behavior! 703 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.