MySQL Forums
Forum List  »  Data Recovery

How to recover deleted rows from MyISAM table
Posted by: Gopinath G
Date: December 28, 2017 10:59AM

I have a table with around 50 K records. I wanted to create unique index for a column that had some duplicate values. I have issued the ALTER IGNORE TABLE `my_table` ADD UNIQUE .... command with IGNORE keyword included in it. Due to this all the duplicate records were deleted. This is an important table and I wanted to restore these deleted records.

I am using MySQL community edition 5.6.38.

In the server, log_bin is off.

It is quite urgent and any solution is very much appreciated.

Options: ReplyQuote

Written By
How to recover deleted rows from MyISAM table
December 28, 2017 10:59AM

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.