I did a UPDATE Query in my MYSQL Table today, which went wrong, because of a missuse of the Replace command. Anyway: I have a Table in my Database now, where in 6.000 Lines there is a Column wich has "0" in every line, that should be some text. I did not write this query in a transactional mode. However I found out, that the real texts are still in the .ibd file of the Database. But if I use this link to restore the data (https://docs.oracle.com/cd/E17952_01/mysql-enterprise-backup-3.8-en/partial.restoring.single.html) It will still restore a "0" Value instead of the text.

In the ibd File I find lines like: 0eyer, L. M.

Which should be: Meyer, L. M.

But I would live with that, as this is my only copy available. Is there any way to restore my Data? I also have the ib_logfile0 and ib_logfile1. I use XAMPP on Windows

0 Answers