S
S
simplecode2011-08-22 10:11:20
MySQL
simplecode, 2011-08-22 10:11:20

MySQL. Revert last change

Hello!
I accidentally executed a crooked request to change data in an InnoDB table without using transactions ...
The server immediately “committed” it.
How can (if possible) "roll back" the last change made and get back the lost data?
Thank you!

Answer the question

In order to leave comments, you need to log in

2 answer(s)
I
Ilya Plotnikov, 2011-08-22
@ilyaplot

No way. Unless he made backups himself.

P
Puma Thailand, 2011-08-22
@opium

Probably it is possible to return something with the help of binary logs.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question