Skip navigation links

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


Advanced Search

Re: Deleted table file behavior!
Posted by: Eliezer Figueroa ()
Date: May 02, 2012 10:19PM

thanks for your answer! I also create a MyISAM table, deleted the .MYD for it them I added a record with no error. I restarted MYSQL. Tried to query the table and them I got an error. I restored the .MYD and inmediatly it change in size! I did query the table again and voila the data is there! So I have to belive that during the time the table was deleted the record was stored in some kind of table log and it sync automatically when the file is back. However I havent been able to find where this table log is.

NOTE: I am just trying to understand how MYSQL works!



Edited 1 time(s). Last edit at 05/02/2012 10:20PM 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.