Shulou(Shulou.com)06/01 Report--

[fault type]

Database table record deletion

[typical characteristics]

There is no data or only part of the data in the ◎ data table

The ◎ client cannot query the complete information.

◆ detection process

a. Use the disk editor to analyze the data file MYD

b. Possible reasons for the loss of manual decision table records.

◆ recovery proc

a. Back up corrupted database files

b. Analyze the database file and determine the possible cause of the loss

c. According to the different reasons of loss, the self-developed software is used for data recovery.

d. Insert the data into the original database and check the integrity of the database.

◆ acceptance process

a. Do mysqlcheck test on the database

b. Query the latest records in the database

c. Make a targeted check on the key data tables specified by the user.

After ◎ discovers that the database is damaged, please back up the database in time and do not do anything to the data without backup.

How to repair operation.

Possible causes of ◎ failure:

◆ upgrades the database, but the condition of SQL statement is not strict.

◆ human operation error

Tips for ◎ database operation:

When ◆ operates on the database, try to back up the database first.

Be careful when ◆ manipulates the datasheet.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.