Remember a case of MySQL database delete recovery

Emmmmm

One of my friends said 11 o'clock this evening that his database was deleted. was deleted yesterday. I'm on the day. MMP the database does not do backup??????????

What Fuck

Then log on to the server and see.

See there's another April 22. Then create a new database and import it.

Import

After importing, change the source code to see if you can access

Emmmm

can access AH. Then we'll find the data for the next April 22. binlog File

Emmmm found the incomplete pilot to come out again

Emmm look at the size

Emmmm a little crazy,

Friend said it was May 15 good to have a small program is very important, I went to see 16.sql MMP 1G File open thief slow.

There's a snack stopper, like two days of missing data.

Then there's no way. But the import of 1G is not too many things. Cut it down a bit.

HHHH also have 700M

Go in and find the deletion statement.

7560966 rows are deleted. Look at the last line.

Then delete from 7560966 to 7994269 rows

Ah haha or vim dafa easy to use

And 482M is so much simpler!!!

Mysql-uroot-p ' Cx4nksmixrdmtisp ' Yinbin_11 <19.sql

But there will be errors. I thought about it. Because there will be other databases and other tables in it, then just remove that error.

Mysql-uroot-p ' Cx4nksmixrdmtisp '-f yinbin_11 <19.sql

And sit and wait and finish the execution.

And then he came back. There is no price for data. Remember to back up the database, brother!!!!!!!!!.

Remember a case of MySQL database delete recovery