Case:
A well -known card game operator, mysql 5.5 Linux system for server, five sets of servers, each data size of nearly 200GB of data. Because the technician’s error executes the script, all the tables of the five sets of servers are delete data.The initialization of the data recovers the company’s data repair.
Solution:
After inspection by the engineer of the data recovery company, each data area of the five groups of cloud servers is 200GB. After the newly divided five sets of servers, the original five sets of data areas are virtual to the new server. PS: Cloud storage is really convenient. Then from the five sets of data from the five groups of dataThe area extracts the lost Innodb file fragments to analyze the length of the fragments attribution field.Then restore the five most important user tables of the five groups of initialized five groups. The remaining five databases of the five sets of servers have not been restored for anti -deletion records that are not initialized, which takes a total of 24 hours.After the customer’s acceptance of the five groups of database data was restored to the next day, the data repair results were very satisfied.