> 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
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 "ROLLB
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 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.my
