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.
Subject
Views
Written By
Posted
How to recover deleted rows from MyISAM table
1852
December 28, 2017 10:59AM
939
February 02, 2018 01:43PM
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.