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...?
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)
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.
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
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