[ale] MySQL undo?

[Greg Sabino Mullane]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> 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-----
Comment: http://www.turnstep.com/pgp.html

iQA/AwUBPFS95rybkGcUlkrIEQLeewCfW4+boIT0+x1RWJkLicYdJlf7LV4AoMAs
GuTP9U+vh0c6n8YieXUjgFrp
=bxCq
-----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.