MySQL database file cracking Solution

The following articles mainly introduce the actual operation solution for restoring MySQL database files through binary logs when they are broken, this article describes how MySQL database files break down. The following describes the main content of this article.

I. Scenarios

1. You have used innerdb and enabled binary log

2. You back up your database to another machine every day.

3. the MySQL database file is broken.

4. Your binary log is well preserved

Ii. Objectives

1. Try to restore to the real environment before the file breaks

Iii. Process

1. recover data from the last day of your daily backup

2. query all the tables in the latest data. The last record change time is as follows: 01:23:59

3. Run the following command: MySQLbinlog -- database = "database Name" -- start-datetime = "2010-02-22 01:24:59" MySQL-bin. [0-9] * | MySQL-u root-p

A. database: the database you want to restore. We recommend that you use one database.

B. start-datetime: the time point from which you want to recover the data. This should be pushed back based on the last update time found in 2. Usually, the point can be found only after several attempts.

The above content refers to the description of restoring MySQL database files with binary logs after they are broken. I hope it will help you in this aspect.