Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com Sep 17 '11 at 9:07

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

13  
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
1  
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 G. Vicario Aug 18 '11 at 12:03
1  

2 Answers 2

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

Your Answer

 
discard

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