Thread: How to recover deleted data........

How to recover deleted data........

From
"neo3 matrix"
Date:
Hello friends!
I have a table property_details having columns (mid,pid,pv,vt)
Accidentally , i fired a query
delete from property_details where mid=27617 and pid=20 or pid=21 or pid=22 , which resulted in deletion of 418 rows which had pids 21 and 22 , which i don't want.......
So , plz can anyone help me out to recover all those rows having pid=21 and pid=22 ...............
how to recover it?
reply soon...............
thanks in advance.............

Re: How to recover deleted data........

From
Tino Schwarze
Date:
On Fri, Jul 25, 2008 at 04:49:48PM +0530, neo3 matrix wrote:

> I have a table property_details having columns (mid,pid,pv,vt)
> Accidentally , i fired a query
> delete from property_details where mid=27617 and pid=20 or pid=21 or pid=22
> , which resulted in deletion of 418 rows which had pids 21 and 22 , which i
> don't want.......
> So , plz can anyone help me out to recover all those rows having pid=21 and
> pid=22 ...............

If you did that without a transaction, things might become very
complicated to restore and might require lots of fiddling.

The easiest way is to restore from backup.

Tino.

--
"What we nourish flourishes." - "Was wir nähren erblüht."

www.craniosacralzentrum.de
www.forteego.de