开发者

How to recover the datas in MYSQL?

开发者 https://www.devze.com 2023-01-02 07:43 出处：网络

Can recover the dat开发者_如何学Goa in MySql after the updation?I update the field and by mistake i lost the correct data..No. This question has been asked multiple times already, the answer remains t

相关专题：

Can recover the dat开发者_如何学Goa in MySql after the updation?I update the field and by mistake i lost the correct data..

No. This question has been asked multiple times already, the answer remains the same:

If you're in a transaction, you can ROLLBACK.
If you got backups or dumps, you can try to load and/or merge, and find the previous value.

Else: the value is gone.

Sorry mate, can't be done, there is no versioning in mySQL tables.

Backups, backups, and backups are, sadly, the only solution.

In case somebody comes up with an ingenious method I don't know about, at any rate 1. Stop the mySQL service and 2. if possible, stop doing anything on the machine the server runs on. But I doubt there is a solution.