accidently the data from MySql databse table has been deleted, so kindly tell me any solution to recover it.
migrated from stackoverflow.com Sep 17 '11 at 9:07
This question came from our site for professional and enthusiast programmers.
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.