Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

accidently the data from MySql databse table has been deleted, so kindly tell me any solution to recover it.

share|improve this question

migrated from Sep 17 '11 at 9:07

This question came from our site for professional and enthusiast programmers.

I'm positive that you can't do this without a backup. – tvanfosson Aug 18 '11 at 11:54
If only I could vote up your reply more tvanfosson.. – N.B. Aug 18 '11 at 11:58
Pls clarify the situation? Was the table data (rows) deleted or the table itself dropped, also what kind of table was it, etc. If you have it backed up, you could restore it (but since you're here I'm guessing that's a no.) Mangled databases are nasty :( good luck... – satyrwilder Aug 18 '11 at 12:00
While you find out your options (if any), you should shut down the MySQL server and possibly put the disk off-line. – Álvaro González Aug 18 '11 at 12:03

No. You deleted the data, so it is gone.

Recover from your backups.

share|improve this answer

it is not possible to recover deleted data.

share|improve this answer

As most answer suggests it's not possible to UN-DELETE but there is a hope which assumes you have binary logging enabled and retained for longer period. Longer enough to include all the DMLs for the database.

If your database was created recently, changes were made recently you can always use mysqlbinlog utility to get DML SQLs from binary log and recover back.

You might like to read the interesting use-case and steps to recover dropped database or table in MySQL.

So, unless you have backup or binary logging (with enough retention) it's not possible to recover the dropped database.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.