Q
Problem solve Get help with specific problems with your technologies, process and projects.

Recover deleted records from a MySQL table

I have deleted all the records in a MySQL table. I want to recover all the records. When I open the table with an text-editor I can see all text fields. Can you help me?
Deleted rows cannot be automatically recovered. If you have a backup you can restore from it, and use the mysqlbinlog utility to replay the updates performed since the backup.

See the Disaster Prevention and Recovery section of the MySQL Reference Manual for more information.

Dig Deeper on Linux servers

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

SearchServerVirtualization

SearchCloudComputing

Close