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.

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.

kunt wrote:
delete from xyz;
rollback;
and there cannot be an autocommit (if so you are hosed) -- if not, the
rollback.

If it is recent - as in an hour ago -- it is called RESTORE FROM BACKUP

There is no "recycle bin" in Mysql.


Oracle has a "flashback area" not sure how extensive it can be, but no
other DB has that level of recovery.

Oracle also has logminer which allows you to restore from backup up to
the point of "doing something stupid" and then extract all other
transactions except the one that caused your problem.

kunt wrote:
delete from xyz;
rollback;
and there cannot be an autocommit (if so you are hosed) -- if not, the
rollback.

If it is recent - as in an hour ago -- it is called RESTORE FROM BACKUP

There is no "recycle bin" in Mysql.


Oracle has a "flashback area" not sure how extensive it can be, but no
other DB has that level of recovery.

Oracle also has logminer which allows you to restore from backup up to
the point of "doing something stupid" and then extract all other
transactions except the one that caused your problem.

kunt wrote:
delete from xyz;
rollback;
and there cannot be an autocommit (if so you are hosed) -- if not, the
rollback.

If it is recent - as in an hour ago -- it is called RESTORE FROM BACKUP

There is no "recycle bin" in Mysql.


Oracle has a "flashback area" not sure how extensive it can be, but no
other DB has that level of recovery.

Oracle also has logminer which allows you to restore from backup up to
the point of "doing something stupid" and then extract all other
transactions except the one that caused your problem.

On Jan 23, 9:45 pm, Michael Austin <maus... (AT) firstdbasource (DOT) com> wrote:
[...]
Really? What's wrong with Recovery Expert for DB2?

/Lennart

On Jan 23, 9:45 pm, Michael Austin <maus... (AT) firstdbasource (DOT) com> wrote:
[...]
Really? What's wrong with Recovery Expert for DB2?

/Lennart

On Jan 23, 9:45 pm, Michael Austin <maus... (AT) firstdbasource (DOT) com> wrote:
[...]
Really? What's wrong with Recovery Expert for DB2?

/Lennart