Talk about the solutions to the deletion of database table records
[fault category]
(1) Fault type: database table record deletion
(2) typical characteristics:
1. There is no data or only part of the data in the data table
two。 The client cannot query the complete information
(3) Star evaluation of damage degree: ★★★★
[solution]
(I) recovery process
1. Detection process:
(1) use disk editor to analyze the data file MYD
(2) to determine the possible reasons for the loss of table records.
two。 Implementation process:
(1) backup the corrupted database files
(2) analyze the database files and determine the possible reasons for the loss.
(3) according to different reasons of loss, use self-developed software for data recovery.
(4) insert the data into the original database and check the integrity of the database.
3. Acceptance process:
(1) do mysqlcheck test on the database
(2) query the latest records in the database
(3) check the key data table specified by the user.
(2) Reliability analysis and time estimation of recovery:
After the table records of the database are deleted, if no other operations are done, the success rate of data recovery will be affected because of the content structure of MYD. The time varies from 1 to 2 days depending on the size of the database.
[tips]
(1) after finding that the database table records are deleted, please back up the database in time and do not insert data and other operations.
(2) the possible causes of the failure:
1. The condition of SQL statement is not strict when upgrading the database.
two。 Human operation error
(3) Star evaluation of hidden trouble and damage degree
Hidden danger 1: no action is done after the database table record is lost
Star evaluation of damage degree: ★★★★
Hidden danger 2: insert a new record after the database table is lost
Star evaluation of damage degree: ★
(4) Tips for database operation:
1. When operating on the database, try to back up the database first.
two。 Please be careful when manipulating the datasheet.
