MySQL Forums
Forum List  »  Newbie

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

Written By
Deleted table file behavior!
May 01, 2012 11:12PM

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.