Case:
The operating system is linux, the file system is XFS, and the model is 1T Hillary hard disk with ST31000528AS. DBA mistakenly thinks that the real -time library is mistaken for the backup library during the backup MySQL database.Delete all data
Solution:
The engineer backup the 500GB data partition.Analyze the XFS file system META data information to determine the current state of the file system.The distribution position of the META data is analyzed for the underlying analysis of these data to determine the data block where the root directory is located and the related INode number.Analyze the Data Fork property in the INODE, and check it with the file data block found to determine the correspondence between the INode and the file.Modify the INODE according to the corresponding relationship found in the previous step.Modify the super block of the XFS file system.Use your own software to extract physical files.Fix the IBData1 file of MySQL Innodb.