Re: Undo query in mysql
for MyISAM-Tables use your backup or your replication server, for transactional tables like Inno-DB or BDB you can use ROLLBACK A little stupid digression on my behalf here...: How do you differentiate between transactional and the other type (called...?) of tables you can use with MySQL...? Eivind sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Undo query in mysql
Hi all, I accidently deleted some values in table using mysql . Is there any way to undo the query ? please advice. thank you . ally - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Undo query in mysql
On Sun, 16 Jun 2002, mohamadally wrote: Hi all, I accidently deleted some values in table using mysql . Is there any way to undo the query ? No, there is not, unless the table was transactional and you were not in autocommit mode. This is where backups come in handy. http://www.mysql.com/doc/A/N/ANSI_diff_Transactions.html Regards, Jason [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Undo query in mysql
Hi, Kind of a quick answer huh? If he had binary logging enabld and the last inserts or updates are still in the log, he can get his data back. mysqlbinlog and some greping and seding. I dropped a database and while it wasn't super easy to do, I did get it back. Eric At 09:17 AM 6/16/02 -0500, Jason Englehardt wrote: On Sun, 16 Jun 2002, mohamadally wrote: Hi all, I accidently deleted some values in table using mysql . Is there any way to undo the query ? No, there is not, unless the table was transactional and you were not in autocommit mode. This is where backups come in handy. http://www.mysql.com/doc/A/N/ANSI_diff_Transactions.html Regards, Jason [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php http://www.kwinternet.com/eric (250) 655 - 9513 (PST Time Zone) Inquiry is fatal to certainty. -- Will Durant - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Undo query in mysql
On Saturday, 15. June 2002 23:36, mohamadally wrote: Hi all, I accidently deleted some values in table using mysql . Is there any way to undo the query ? Yes, for MyISAM-Tables use your backup or your replication server, for transactional tables like Inno-DB or BDB you can use ROLLBACK Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php