Home  >  Q&A  >  body text

Urgent, urgent, please help: mysql delete accidentally deleted

Yesterday I posted a request to remove duplicates and get the latest value. I tested the code provided by netizens in the test environment in the morning. As a result, I accidentally connected to the official environment, and the result was tragic. Now the data has been deleted by mistake. I urgently need a solution. The method,

 说下数据库情况
表是 innod 引擎的,开启了binlog
阿神阿神2711 days ago604

reply all(4)I'll reply

  • 我想大声告诉你

    我想大声告诉你2017-05-18 10:46:01

    误删之后,赶紧联系同事,同事最终搞定了,问他怎么恢复的, 他给了我这个链接http://www.jb51.net/article/99553.htm  

    reply
    0
  • 某草草

    某草草2017-05-18 10:46:01

    In this case, you can only go to the backup and restore according to the log

    reply
    0
  • 黄舟

    黄舟2017-05-18 10:46:01

    It’s not easy to have a binlog. First restore today’s binlog, find the delete statement, and check the position before the statement; restore it with yesterday’s backup, and then restore it to this position by appending today’s binlog, and you will have the situation before deletion. database.
    Under gg, there are many specific methods on the Internet

    reply
    0
  • 高洛峰

    高洛峰2017-05-18 10:46:01

    I have also encountered your situation, but I modified the same field of all the records in the table to be the same. Your deletion was more troublesome than mine, so I could only modify the database according to the log.

    reply
    0
  • Cancelreply