MySQL Forums
Forum List  »  InnoDB

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

Written By
Deleted data automatically recovered
December 11, 2016 11:08PM

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.