Skip navigation links

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


Advanced Search

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

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!



Edited 1 time(s). Last edit at 05/01/2012 11:14PM by Eliezer Figueroa.

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.