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.

This was last published in June 2005

Dig Deeper on Linux servers

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

SearchServerVirtualization

SearchCloudComputing

Close