[ale] MySQL undo?
Greg Sabino Mullane
greg at turnstep.com
Sun Jan 27 21:57:00 EST 2002
-----BEGIN PGP SIGNED MESSAGE-----
> Hi,I did a really dumb thing. I went
> update Tablename set Name = 'Joe Bloe'
> Is there any easy way to recover that information?
> Is there an undo command?
No undo command, I'm afraid. Your best bet is to restore
from your latest backup. (you make nightly backups of your
database, right?) If you were using a real database, then
it would be as simple as issuing a rollback command before
you completed the transaction. Unfortunately, mySQL does
not natively support transactions. :( Sorry I can't be of
much more help.
Greg Sabino Mullane greg at turnstep.com
PGP Key: 0x14964AC8 200201272151
-----BEGIN PGP SIGNATURE-----
-----END PGP SIGNATURE-----
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be
sent to listmaster at ale dot org.
More information about the Ale