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

On Jan 23, 11:51 am, kunt <k... (AT) no (DOT) net> wrote:
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....

oh shit...

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

D.

On Jan 23, 11:51 am, kunt <k... (AT) no (DOT) net> wrote:
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....

oh shit...

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

D.