MySQL Forums :: InnoDB :: Deleted data automatically recovered


Advanced Search

Deleted data automatically recovered
Posted by: Nabijon Juraev ()
Date: December 11, 2016 11:08PM

i have a table for store devices data. And now i need to delete all/truncate this table. I tried to remove one by one, but deleted data inserts in the and with new ID. i tried "Delete *" , "Truncate table" , "Truncate table devices; Commit", but it doesnt help. I droped table, create it anew but all data again recovered automatically...
This problem only in one table of db. In other tables i can delete without any problem

Options: ReplyQuote


Subject Views Written By Posted
Deleted data automatically recovered 409 Nabijon Juraev 12/11/2016 11:08PM
Re: Deleted data automatically recovered 195 Rick James 12/12/2016 02:09PM
Re: Deleted data automatically recovered 190 Peter Brawley 12/12/2016 02:50PM
Re: Deleted data automatically recovered 192 Nabijon Juraev 12/12/2016 10:33PM


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.