database table record Delete How to fix it

Source: Internet
Author: User

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/89/1C/wKioL1gIWqjxdajlAARt955B3GI429.jpg-wh_500x0-wm_3 -wmp_4-s_1805920562.jpg "title=" database table records delete. jpg "alt=" wkiol1giwqjxdajlaart955b3gi429.jpg-wh_50 "/>

[Failure category]

(i) Fault type: database table record deletion

(ii) Typical features:

1. no data or only part of the data sheet

2. The client cannot query the full information

(iii) degree of damage Rating: ★★★★

[Solutions]

(i) Recovery process

1. Inspection Process:

(1) using the disk editor to analyze the data file MYD ;

(2) determine the possible causes of loss of table records.

2. implementation process:

(1) to backup the damaged database files;

(2) analyze the database files to determine the possible causes of the loss;

(3) for different reasons for loss, the use of self-developed software for data recovery;

(4) The data is inserted into the original database and the database is checked for integrity.

3. Acceptance Process:

(1) make mysqlcheck detection of database;

(2) querying the latest database records;

(3) The user-specified key data table for targeted verification.

(ii) Reliability analysis and time estimates for recovery:

after the table record of the database is deleted, if no other action is done, MYD content structure, the success rate of data recovery is not up to thetime, depending on the size of the database, about 1-2 days

[Tips]

(a) after the discovery of database table records deleted, please timely backup of the database, no more data insertion and other operations.

(ii) Possible causes of the failure:

1. The database is upgraded, theSQL statement condition is not strict

2. human Error in Operation

(iii) hidden trouble and damage degree star rating

Hidden Trouble 1: Database table records are missing after no action is made

Degree of damage rating: ★★★★

Hidden Trouble 2: Inserting a new record after a database table is missing

Degree of damage rating: ★★★★★

(iv) database operation tips:

1. when operating the database, try to make a backup of the database;

2. be cautious when working with data sheets.

This article is from the "12113891" blog, please be sure to keep this source http://12123891.blog.51cto.com/12113891/1863842

database table record Delete How to fix it

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.