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 first published in June 2005

Dig deeper on Open source databases

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.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: