RE: Big Mistake Need Help, can I undo an action I did?
-Original Message- From: Fred van Engen [mailto:[EMAIL PROTECTED] Sorry, you'll need a backup. If your backup is not recent enough and you have a binary log (e.g. for replication), you can use that log to restore the database state. If you have a backup and the update log since the last backup, you can restore to any point in time from that back up to present, as well. Comes in handy when a member of the programming staff comes up and says, Can you undo the 'DROP TABLE' I just did by mistake? ;) This only works if you've been running with the update log enabled, of course. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Big Mistake Need Help, can I undo an action I did?
Hi, On Fri, Jun 13, 2003 at 02:08:33PM -0700, jack ma wrote: I had updated a field for all the entries in a table by mistake, I need to undo that step. I dont have the database back up to an stisfactory level. Is there a way in MySQL I can step one action back? or undo one command that I just did?? Sorry, you'll need a backup. If your backup is not recent enough and you have a binary log (e.g. for replication), you can use that log to restore the database state. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Big Mistake Need Help, can I undo an action I did?
Hi guys, I had updated a field for all the entries in a table by mistake, I need to undo that step. I dont have the database back up to an stisfactory level. Is there a way in MySQL I can step one action back? or undo one command that I just did?? Thanks a lot guys!? __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]