Re: Deleted table file behavior!
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!
Subject
Views
Written By
Posted
3721
May 01, 2012 11:17PM
1527
May 02, 2012 07:35PM
Re: Deleted table file behavior!
1627
May 02, 2012 10:25PM
1841
May 03, 2012 07:06PM
1598
May 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.