Re: How to undo changes / deletes ?

On Jan 23, 11:51 am, kunt <k...@[EMAIL PROTECTED]
> wrote:
> Hi all,
> is there a way to undo changes in a database (e.g. those made because of
> a recent human error, an erroneous delete/update query)
>
> For example reversing all transactions made in the last N days?
>
> On any database? In particular I am most interested in postgres and
> mysql... secondarily Oracle.
>
> Thank you

You can do "rollback" in Oracle I know. I think in MySQL as well if
the table is InnoDB I believe. This will only allow you to do so if a
"commit" has not been issued after the statement. It would typically
apply if you did something like this from a command line....

> DELETE * FROM tableName;

oh ****...

> ROLLBACK

If you're looking for data that's days old, I think you'll need a
backup strategy in place or redundant tables...

D.