Using Mysql Recovery Utility To Repair Damaged Myisam 5.0.4 Table
- Date: 2010-09-23 - Word Count: 429
Share This!
The MyISAM table in the MySQL database is the default type of database engine. This table stores the data in three types of files: .frm file to store the table format, .myd file to store the data, and the .myi file to store the index file. If any of these three files get damaged due to any sundry reason such as many users modifying the table simultaneously, virus infections, abrupt system shutdown, etc. MySQL provides several utilities to recover MySQL tables. However, if these tools do not work for the MySQL table you are using, then you should use a third-party MySQL repair software to repair MySQL database.
Let us take a practical situation in which you are facing the following error message while working on the MySQL 5.0.4 database table:
"MySQL error code 126: Index file is crashed"
Cause:
The most possible cause of this problem is that the MyISAM table has damaged, which is why you are unable to access and/or work on the table.
Resolution:
To resolve this problem, you should perform the following methods to recover MySQL table and use it once again:
• Using 'myisamchk' utility: You should use the 'myisamchk' command to check and repair the damaged MySQL table by using the following MySQL repair syntax:
myisamchk -r
This command is used to remove the incorrect and deleted rows in the data file. Also, it reconstructs the index file.
• Using Check table/Repair table: You should use the 'Check Table' tool to check the MyISAM table for errors using the following syntax:
CHECK TABLE tbl_name [, tbl_name] ... [option] ...
option = {FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED}
After detecting errors in the table, you should use the 'Repair Table' tool to repair MySQL table. For this, you can use the following syntax:
REPAIR [NO_WRITE_TO_BINLOG | LOCAL] TABLE
tbl_name [, tbl_name] ...
[QUICK] [EXTENDED] [USE_FRM]
Try to reproduce the steps that caused the error message to be displayed. If the error does not appear, then the MyISAM table is repaired. However, if the error appears again then the MySQL table is severely damaged. The use of a third-party MySQL repair software is the best bet in such cases. The use of highly intense and safe scanning algorithms along with rich user interface results in safe and easy MySQL recovery.
In such cases, the best software that I would suggest you is Stellar Phoenix Database Recovery for MySQL, which repairs MySQL database in MySQL 3.x, 4.x, 5.x, and 6.x versions. With the ability to repair MySQL files such as .ibdata, .ibd, .myd, .myi, .frm, etc from both InnoDB and MyISAM database engines, this MySQL recovery utility is compatible with Windows 7, Vista, Server 2003, XP, and 2000.
Let us take a practical situation in which you are facing the following error message while working on the MySQL 5.0.4 database table:
"MySQL error code 126: Index file is crashed"
Cause:
The most possible cause of this problem is that the MyISAM table has damaged, which is why you are unable to access and/or work on the table.
Resolution:
To resolve this problem, you should perform the following methods to recover MySQL table and use it once again:
• Using 'myisamchk' utility: You should use the 'myisamchk' command to check and repair the damaged MySQL table by using the following MySQL repair syntax:
myisamchk -r
This command is used to remove the incorrect and deleted rows in the data file. Also, it reconstructs the index file.
• Using Check table/Repair table: You should use the 'Check Table' tool to check the MyISAM table for errors using the following syntax:
CHECK TABLE tbl_name [, tbl_name] ... [option] ...
option = {FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED}
After detecting errors in the table, you should use the 'Repair Table' tool to repair MySQL table. For this, you can use the following syntax:
REPAIR [NO_WRITE_TO_BINLOG | LOCAL] TABLE
tbl_name [, tbl_name] ...
[QUICK] [EXTENDED] [USE_FRM]
Try to reproduce the steps that caused the error message to be displayed. If the error does not appear, then the MyISAM table is repaired. However, if the error appears again then the MySQL table is severely damaged. The use of a third-party MySQL repair software is the best bet in such cases. The use of highly intense and safe scanning algorithms along with rich user interface results in safe and easy MySQL recovery.
In such cases, the best software that I would suggest you is Stellar Phoenix Database Recovery for MySQL, which repairs MySQL database in MySQL 3.x, 4.x, 5.x, and 6.x versions. With the ability to repair MySQL files such as .ibdata, .ibd, .myd, .myi, .frm, etc from both InnoDB and MyISAM database engines, this MySQL recovery utility is compatible with Windows 7, Vista, Server 2003, XP, and 2000.
Related Tags: mysql repair, repair mysql, recover mysql, repair mysql database, mysql recovery
Your Article Search Directory : Find in Articles
Recent articles in this category:
- How To Properly Back Up The Data In Your Computer
When you have data on your computer, you most likely have it all saved so that you can keep it long - Mac Hard Drive Data Recovery After Dd Command Fails To Copy Your Data
Though the advance computer systems, such as Mac, UNIX etc are robust in their design and storage st - Olympus µ Tough-6020: Sd Card Corruption And Digital Camera Recovery
The Olympus µ TOUGH-6020 is a rugged and stylish camera which is bound to awe photo enthusiasts. It - Importance Of Spytool For Parents
Computer and Internet have become a basic part of education system in schools, colleges, and institu - Bkf Recovery In Server 2003 After Deletion Of Archive Bit Information
It is imperative for a Microsoft Windows user to backup his/her file. Backup files turn out to be ha - How To Prevent Windows Data Loss
Did you just face crashing of your Microsoft Windows 7 operating system? And are all your files trap - Defragmentation In Windows May Lead To Data Loss
I have always relied on a Windows operating system. And like me, there are many other people who com - What Types Of Digital Media Allow For Data Recovery?
There are a number of reasons that an individual or company may need to turn to a data recovery comp - Saving Your Computer From Ransomware Viruses
As the world becomes more and more connected, computer viruses are as rampant and as destructive as - Recovered Deleted Photos From Mac Book Using This Amazing Tool!
I am a professional photographer and my work involves dealing with thousands of photographs. Since M
Most viewed articles in this category:
- Instant Rollback to the Past With Rollback Rx
With impacting system performance and speed, Rollback Rx is the only system restore software and dis - Troubleshoot Via Remote Control With Rollback Rx
Rollback Rx lets you carry out your pc maintenance and fix computer problems both remotely and local - The 5 Most Common Reasons Why People Believe They Won't Need Data Recovery
Most people don't realize how important their data is until it is lost. Hard drive data recovery is - Reasons For Data Loss From Computer Hard Disks
IntroductionThe last 20 years has brought about a proliferation of computer use in society. Technol - Electronic Discovery 2.0
Electronic Discovery, or "e-discovery" refers to the discovery of data from electronic storage and o - How to Backup Mails and Address Book of Outlook Express
What happens when you login to your computer system and find that you cannot access your mails on Ou - Managing Backup And Recovery Services
Iceland Seafood International (ISI) has numerous offices located in ten countries and sells seafood - Choosing The Best File Recovery Solution
All file recovery solutions are not created equally. But, choosing one specific software or service - The Prescription For Your PC's Health - RollBack Rx
Where there is data, there is a threat to its security. More so for very large organizations that ne - Corrupt Word File Recovery
There are as many ways to recover the lost data as there are the reasons to lose it. If there are 10
