How to recover the data in mysql

This article mainly talks about "how to recover the data in mysql". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to recover the data in mysql.

A piece of data was deleted by mistake yesterday.

The server environment is built with pagodas.

Get root password

Log in to mysql to view binlog

Show binlog events

View the contents of the specified binlog file

Show binlog events in 'mysql-bin.000005'

The binlog log of the pagoda panel is under the / www/server/data/ folder.

Parsing binlog Log

Mysql- u root-p-e "show binlog events in 'mysql-bin.000005'" > binlog1018.txt

Parse the binlog log and store the log information in the / root/binlog1018.txt file

At this point, I believe you have a deeper understanding of "how to recover the data in mysql". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!