Research on Data Recovery Based on Parsing Log Files

This paper describes an improved data recovery method that enables complete data recovery by periodically transferring the. ibd files of a MySQL database via FTP. Compared with the traditional SQL script recovery, the new method greatly improves the recovery speed. On the basis of full recovery, this paper further introduces the mechanism of daily transfer of binary log files via FTP and a set of parsing tools that can convert binary log files into standard SQL statements. By configuring database scripts to parse the DDL and DML statements involved, the incremental transfer of data is realised. To ensure data security, this paper also introduces a checkpoint mechanism that effectively prevents data loss by physically storing the progress of daily transmission of binary logs.