MySQL Database Recovery

Reliable Utility to Resolve MySQL Error Code 144 and Recover Precious Data Back

The applications that are involved in on-line transactions or are accessed by huge number of users on a daily basis require databases at the back-end to store important data. The database linked at the back-end of an on-line application either works as a base storage of the data related to the transactions or stores the authorization, authentication, and accountability information of accounts for proxy server verification. For its good internal structure and fast counter response, MySQL is widely used in various on-line applications. At times MySQL database gets corrupt and all the data in it becomes completely inaccessible. For such situations, Stellar Data Recovery has developed an advanced MySQL repair utility, which is powerful enough to repair the corrupt database and recover your data back.

The corrupt MySQL database can be referenced by various error messages on the screen. While trying to access any table from the corrupt MySQL database, you may encounter an error message as below:

“MySQL error code 144: Table is crashed and last repair failed”

There can be a number of possible reasons behind the corruption of a MySQL database, such as sudden or improper shut down of the system, corruption to the file system of the computer, virus infection, or contradiction with any newly installed hardware/software.

In order to repair the corrupt MySQL database and recover your precious data from it, you can run some suggested commands. Below steps will guide you in this regard:

Try running the command, 'myisamchk -r', which is meant to drop the invalid rows in the MySQL table and reconstruct its index file. The utility helps in verifying and repairing the damaged MySQL database tables.
After running ‘myisamchk’ utility, run the ‘Check Table’ command to verify the MyISAM table for errors, if there is any. The syntax for the command is as below:

CHECK TABLE tbl_name [, tbl_name] ... [option] …

option = {FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED}

If the problem is still there, you can repair the corrupt MySQL database table by running the command, 'Repair Table' as below:

REPAIR [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name [, tbl_name] ... [QUICK] [EXTENDED] [USE_FRM]

At times, if the MySQL table has got severely damaged, the above commands even fail to resolve the problem and your data in the database remains inaccessible. In such a situation, you can opt for the software - Stellar Phoenix Database Repair for MySQL. The software has been programmed with a powerful algorithm to recover your data from the corrupt MySQL database, irrespective of the reason behind the corruption. This database recovery software is completely reliable and you can perform recovery operation, without any fear of data loss.

Date Published: Apr 12, 2012 - 5:06 am

How to Check, analyze & repair MySQL database corruption by mysqlcheck

MySQL database corruption normally occurs due to hardware failure, out of space problem, login failure, power failure, and many more. A database administrator can check the level of corruption by mysqlcheck program. MySQLcheck is a table maintenance program offered by MySQL to check and repair MySQL table corruption. It performs several other operations apart from check & repair like; to analyze and optimize table. Table maintenance program (mysqlcheck) can be time consuming; especially for the large table because when you run this program on the database then it thoroughly check and analyze all the tables in the database and tries to repair all errors.

By default, MySQL database uses myisam storage engine and it supports all the operation of mysqlcheck. Other storage engine may not support all the operation of mysqlcheck program. In such cases, you may receive below error message:

shell> mysqlcheck employee records

employee.records

Note: The storage engine for the table doesn't support check

Above error can be fixed by manual mysql database repair method, which is out of scope of this article. I will try to cover this topic in next article.

How to perform table maintenance program? You can perform table maintenance operation by launching mysqlcheck on the database. There are three different ways to invoke mysqlcheck;

shell> mysqlcheck [options] db_name [tbl_name ...]

It will perform all the operation of mysqlcheck on a particular table

shell> mysqlcheck [options] --databases db_name ...

It will perform all the operation of mysqlcheck on a particular database

shell> mysqlcheck [options] --all-databases

It will perform all the operation of mysqlcheck on all databases in MySQL

Note: If you haven’t mentioned the table name then it will try to check all databases.

Alternative of mysqlcheck: myisamchk is an alternative of mysqlcheck for all those database administrators that are using MyISAM as a storage engine for their databases. Both have similar functionalities but works differently. The main difference is that you can't use mysqlcheck on the mysql database server when mysql server (mysqld) is not running but myisamchk can be use. The benefit of mysqlcheck over myisamchk is that you don’t want to stop mysqld to run mysqlcheck.

Date Published: Mar 22, 2012 - 2:09 am

MySQL server (mysqld) Fails, How to fix it?

MySQL server is the main program that performs most of the activity in MySQL database installation, also known as mysqld. It has a set of system & status variables and also manages access control for data directory that contains data & tables. MySQL data directory has many other options, you can check all the available options in data directory by running below command.

shell> mysqld --verbose –help

If MySQL server fails after some command update on the database that means your database has some corruption issue. Corruption in the database can happen due to various reasons like virus attack, hardware problem, power outage or others. Before going to solve the problem, you will have to found the cause or reason for database corruption.

See below steps for how to check & fix MySQL database corruption:

Shutdown the database with mysqladmin shutdown
Take the backup of the tables- it will help, if MySQL repair command fails to repair corrupt MySQL database table.
Check all tables by myisamchk -s database/*.MYI command.
If found any wrong table then repair wrong tables by myisamchk -r database/table.MYI.
Now take backup (second backup) of repaired tables.
If you have required more space then remove any old log file from MySQL data directory.
Start MySQL server with log-bin.
If found any corrupt table then stop mysqld.
Restore corrupt table from second backup.
Now restart MySQL server without log-bin.
Re-execute the commands with mysqlbinlog binary-log-file | MySQL.

After performing all the above steps, if your MySQL server dies again then you will have to found the reproducible bug that should be easy to fix. If you are a MySQL support customer then you can report this issue to MySQL support team. They will try to solve your problem as soon as possible.

Date Published: Feb 17, 2012 - 1:20 am

Check & Repair Corrupt MySQL Database using myisamchk

MYISAMCHK is a table maintenance utility developed by MySQL. This utility works with MyISAM table that uses .MDI for index and .MYD for data. Database administrator can also use REPAIR Table & CHECK Table statements to repair and check corrupt MySQL database. It offers several options to check, repair and optimize corrupt MySQL database. The options are given below:

myisamchk General Options
myisamchk Check Options
myisamchk Repair Options
myisamchk Memory Usages

Caution: Always make a backup of corrupt MySQL database before using any Repair Option on the database, under some scenarios Repair Options might cause of data loss.

Start myisamchk by this:

shell> myisamchk [options] tbl_name ...

Place your option, that you want to do at the Options and table name at tbl_name. Table name is the name of table that you want to check or repair. If you don't know what are the available options then invoke this:

myisamchk –help

This will give a list of all available options.

Note: If you have not specify the option then MySQL set Check options by default.

All the data or records related to the database are placed at the database directory. If you want to run myisamchk at the different location then you have to specify the location database directory because MySQL has no any idea about location of the database.

How to repair MySQL database at other Location? To do this operation, you have to copy the files that correspond to the database table and paste it to the other location. Now perform repair operation on there.

Recommended way for quickly check and repair MySQL database:

To check corrupt MySQL database run this command:

shell> myisamchk --silent --fast /path/to/datadir/*/*.MYI

shell> isamchk --silent /path/to/datadir/*/*.ISM

To reapir corrupt MySQL database, run this command:

shell> myisamchk --silent --force --fast --update-state

--key_buffer_size=64M --sort_buffer_size=64M

--read_buffer_size=1M --write_buffer_size=1M

/path/to/datadir/*/*.MYI

shell> isamchk --silent --force --key_buffer_size=64M

--sort_buffer_size=64M --read_buffer_size=1M --write_buffer_size=1M

/path/to/datadir/*/*.ISM

Important: It is recommended to you; first of all close all the programs before running myisamchk command.

Date Published: Jan 13, 2012 - 3:11 am

What are the Importance & Use of MySQL database Backup?

Performing backup of MySQL database is the most important activity of any database administrator but most of database administrators just neglect this activity. It is like a nightmare situation for the administrators, if database gets corrupt and there is no any backup available to recover MySQL database. At this scenario, they will realize that they have done a blunder mistake. Backup helps to handle any type of corruption strike by virus, hardware failure and other. Always try to take a proper backup because without proper backup, you will unable to restore complete database properly.

In this section, we will discuss about all the important aspect related to the backup of MySQL database:

When do you need MySQL backup?
What do you need to be backed up?
When should you perform backup?
Where to store backup?
How can perform backup?

When do you need backup? Backup will help you in several conditions like hard disk failure, system crash, virus attack, wrong user actions, power failure and many more. In case of accidental drop or delete table, backup helps for recovery.

What do you need to be backed up? For proper functioning of MySQL database, you will have to take the backup of database content, log files and configuration information.

When should you perform backup? Time is very important factor for maintaining proper backup. Always take a backup of your MySQL database on regular basis and try to avoid during peak hour. It also depends upon the value and amount of your database.

Where to store backup? You can store database backup on the same server, another server, removable media or any other locations.

Note: Always maintain your MySQL database backup on more than one location.

How can perform backup? You can perform backup by several methods like copying table method, backups with mysqldump or mysqlhotcopy , backup using replication slave and other.

Date Published: Jan 06, 2012 - 4:00 am

How to Restore MySQL database from Program files?

In this article, we will discuss about a scenario wherein a database administrator has tape backup of C drive only and production server had compromised by virus attack which was hosted in a third party hosting company. It is very frustrating for every database administrator if they have not schedule MySQL database export to a SQL backup file.

Restore MySQL database without SQL dump: To do this you have to follow the below steps.

Install MySQL server database
Stop the service of MySQL database
Copy data folder to new data folder
Restart the MySQL service
Check MySQL database table
Repair all the database table
Backup & restore to new production server

Install MySQL Server Database: Install the same version of MySQL database as you used before.

Stop the service of MySQL Database: Stop the service of MySQL database for adding a new data folder to the database.

Copy data folder to new data folder: Take the required database data folder that contains program files (.frm, .myi, .myd) from tape backup of C drive and paste them to new MySQL database data folder.

Restart the MySQL Service: After adding the data folder in new database then restart the MySQL service, hope all goes well without any problem.

Check MySQL Database Table: Run MYSQLCHECK or CHECK to check the consistency of the database. It depends upon your MySQL versions.

Repair all the Database Table: This step is not necessary but helps in ensuring that database is free from any corruption. You can use “REPAIR ” to repair MySQL database.

Backup & Restore to a new production server: Now export the mysql database to a SQL dump or SQL file.

Notification: Above discuss method works with MyISAM tables only, it does not work with InnoDB database storage engine and Tape backup of C drive is necessary.

Date Published: Dec 29, 2011 - 4:07 am

Perform Backup & Restore On MySQL Database Table

Database administrator can use Backup Table syntax for backup and Restore Table syntax for restore MySQL database table. First we will know about how to take a backup of MySQL database table then after how to restore MySQL table from backup created using Backup Table syntax.

How to Get Table Backup? You can make backup of MySQL database table by Backup Table syntax. The syntax is:

BACKUP TABLE table_name [, table_name] ... TO '/path/to/backup/directory'

This syntax will copy only .frm & myd files. MYI index file can be created using those two files. During backup process, a read lock is applied for each table but one at a time. Suppose you want to copy all the MySQL table then issue a Lock Table syntax for the tables first.

Note: Above backup syntax does not work with MySQL database 5.5. For it, you can try mysqlhotcopy or mysqldump.

How to Restore Table? You can restore corrupt MySQL database tables from backup that was made with backup table syntax using restore table syntax. The syntax to restore MySQL table is:

RESTORE TABLE tbl_name [, tbl_name] ... FROM '/path/to/backup/directory'

As we have discussed above, backup file consists .frm & .myd files only so restore table syntax restores .frm & .myd files only and index file (.myi) can be created using those two files.

Important: Restore table syntax does not overwrite existing tables. If a database administrator tries to restore over an existing table then MySQL database through an error message:

“Table is already exist”

Note: Restore table syntax does not work with MySQL database 5.5.

Applied For: Backup & Restore Table syntax work with MyISAM tables only.

Glossary: .frm, .myd & .myi are the format, data and index files respectively.

Why restore takes longer time than backup? Restore table takes longer time than backup table due to the need to rebuild index files. If a table has more indexes them it takes longer time to restore in comparison with a table with less indexes.

Date Published: Dec 27, 2011 - 3:37 am

Repercussions of InnoDB table corruption and MySQL database recovery

MySQL incorporates a blend of advanced features to offer users a performance-driven and a fully-integrated transaction-safe database. It has excellent capabilities to enable you manage any large database environment. You can use the Query Analyzer to keep a check on query performance and identify the faulty SQL code that is causing a slowdown. Some of its most distinguished features include, crash recovery, roll back, full commit, and row-level locking capabilities. Despite being so much reliable and consistent, this database is prone to corruption. MySQL corruption generally occurs due to improper server shutdown, operating system malfunction, metadata structure damage, etc. As a consequence, all vital database objects become inaccessible. To overcome this problem, you need to go for MySQL database recovery through a proficient third-party utility.

For instance, while upgrading your MySQL server that is running on InnoDB engine, you may come across the following error message:

“#1033 - Incorrect information in file 'file_name”

Cause: Due to power surge or other reasons, the upgrade could not be completed successfully. As a consequence, some of the InnoDB tables became corrupt.

This could make all the database tables inaccessible and might result in critical data loss. You can easily restore your database by using a recent/updated backup. If the backup is not available, you should follow the below mentioned resolution steps.

Resolution: The following steps may help you resolve the issue-

The 'Check table' utility may help you identify corruption and at the same time, repair the structure of damaged InnoDB tables.
Restart MySQL server using innodb_force_recovery=4 command.

If the problem still persists, take help of an efficient MySQL repair tool. These third-party software perform an extensive scan of the corrupt MySQL databases to repair and restore all database objects while retaining their original structure and properties. They have an interactive and self-descriptive interface that makes recovery easy and convenient for the end user. They effectively recover tables, keys, constraints, queries, data types, etc.

Date Published: Dec 13, 2011 - 3:22 am

How to Recover Corrupt MySQL Database - MySQL Recovery

MySQL database is an open source database with the best speed and reliability. Most of the branded organizations use it to save their money and time. It offers several syntax to optimize, backup and repair corrupt MySQL database. MySQL database can be corrupt due to several reasons like power failure, malware attack, system failure, hardware failure and many more. Sometimes repair syntax fails to fix the corruption at this situation, you should take help from any third party MySQL database repair software.

In this article, we will discuss a condition wherein a database administrator has tape backup of C drive only and how to recover corrupt MySQL database with the help that tape backup of C drive.

Recover MySQL Database with tape backup: To do this, you will have to follow the below points.

Create a new MySQL server environment: Install a same version of MySQL server to restore corrupt MySQL database. For example, if you are at MySQL version 4.1.22, then install the same version.
Stop MySQL Service: It is required for adding the data folders.
Copy & Paste Database Folder: Copy the database folder from old MySQL database and paste them in new MySQL database folder. Database folder contains information about .frm, .myd and .myi files. The default database folder location is C:Program FilesMySQLMySQL Server x.xDatadatabase-Folder-Name.
Restart MySQL Service: To restore new MySQL database.
Check & Repair MySQL Database Tables: MySQL offers check & repair syntax to check and repair corrupt MySQL database tables as discussed above. Check syntax specifies that there is a corruption in the table and those corrupt tables can be repaired by the Repair syntax. It is very necessary for ensuring that there is no any corruption in the MySQL database tables.
Make Backup: If corruption has been fixed by the above mentioned steps then make a backup to avoid data loss in future.

Summary: In the end, if check syntax specifies that corruption in the table and Repair syntax is unable to fix then it is recommended you to try any 3^rd party MySQL database repair software to fix the corruption.

Note: Above mentioned steps will work with MyISAM database storage engine not with the InnoDB database storage engine.

Date Published: Nov 29, 2011 - 9:31 pm

Types & Comparison between MySQL database Storage Engines

MySQL is an open source database and used by the most of the database administrator. It uses database storage engines as a handler to handle different MySQL database tables. There are several storage engines supported by MySQL like MyISAM, InnoDB, Merge, Memory, Archive, CSV, Example, Federated and many more. All of them have their own functionalities and characteristics.

What is the default storage engine? The point comes in your mind. If database administrators do not select the type of storage engine for the database then what is the default storage engine for the database. The answer is InnoDB. It is the default storage engine.

Applied For: After release MySQL 5.5, InnoDB will be the default storage engine.

How to Change Storage engine? A database administrator can change the storage engine for database from the pluggable storage engine. Pluggable storage engine gives users flexibility to select the best fit for their specific case.

InnoDB storage engine is the most used storage engine in comparison of other storage engine. It is used for financial systems, health care applications, telecommunications, retails built on MySQL database. This storage engine is structurally designed to handle transactional related applications that needs crash recovery, high response time, concurrency, and integrity.

Comparison between InnoDB & MyISAM Storage engine: Each storage engine has its own specific characteristic and benefits. Beyond the performance, there are various other factors that suggest for a particular storage engine.

Features	InnoDB	MyISAM
ACID Transactions	Yes	No
B-Tree Indexes	Yes	Yes
Crash Safe	Yes	No
Clustered Index	Yes	No
Storage Limits	64TB	256TB
Foreign Key Support	Yes	No
Full Text Search Indexes	No	Yes
Backup/Point-in-time Recovery	Yes	Yes
Data Cashes	Yes	No
Others

Note: I have tested all above comparison scenarios but there may be many more comparison between these two storage engines.

Summary: InnoDB is default and most used storage engine by MySQL database administrators. It offers efficient ACID transactional capabilities. Now database administrator can create application in the InnoDB storage engine without altering default configuration settings.

About Author: Author is a technical writer and had written several article on MySQL recovery scenarios. You can reach him through comment.

Comments: Share your feedback through comments. I always welcome your comments.

Date Published: Nov 10, 2011 - 3:38 am

Analyzing the root causes of Index file corruption in MySQL and methods to perform database recovery

MySQL is an open source database that is freely available under GNU General public license. It offers developers a range of storage engines, including Berkeley DB, InnoDB, Heap, and MyISAM. It incorporates adequate security measures and also provides regular security patches to keep the software up-to-date. When it comes to performance, it clearly dominates over the other databases. However, MySQL databases may get corrupt in the event of a virus infection, hardware malfunction, or an unexpected system shutdown. In such circumstances, you lose access to the vital information stored in the database. To overcome this problem, you need to go for MySQL recovery through a reliable third-party utility.

For instance, you might receive the following error message on your screen while trying to access a MySQL table:

“No more room in index file”

Cause: The above error occurs when you try to access a damaged or corrupt MySQL table. This would render all valuable records in the table inaccessible. At this stage, you may use an updated database backup to restore the table. However, if the backup is unavailable, you should follow the below mentioned resolution steps.

Resolution: For resolving the issue, follow the below given steps:

Firstly, ensure that you have full administrative rights on the database that you are trying to access.
Use the following commands to verify the integrity of the database table:

CHECK TABLE tablename;

myisamchk *.MYI

mysqlcheck *.MYI

Use the 'REPAIR' command with appropriate options to repair corruption:

REPAIR TABLE table_name

Now, use the 'EXIT' command to quit the database. Restart the MySQL server.

If the problem still persists, you should take help of an efficient MySQL repair utility. These software embed a range of advanced and highly robust mechanisms to efficiently scan corrupt MySQL databases and restore valuable objects, such as tables, primary keys, indexes, constraints, etc.

These third-party tools provide preview of all recoverable objects and allow saving log of the recovery process in a separate text file. They support all the latest MySQL versions, including MySQL 3.x, 4.x, 5.x, and 6.x. Furthermore, they are compatible with Windows 7, Vista, Server 2003, XP, and 2000.

Date Published: Oct 21, 2011 - 4:38 am

How to check & verify InnoDB TableSpace File Corruption

MySQL database offers an offline InnoDB File Checksum Utility (innochecksum) to check the checksums for innodb files. When you run innochecksum utility on the mysql database then it will read and print checksums for innodb tablespace files. After calculating checksum it will compare the calculated checksum with stored checksum, if you found checksum mismatch between calculated checksum and stored checksum that means pages are corrupt.

Process of innochecksum Utility:

Read innoDB tablespace files-->Calculate checksum-->Compare checksum-->Report checksum mismatch

Why developed this tool: There are two main motives to develop this utility that are as:

To speed up verifying the integrity of tablespace files after power outages.
To verify the integrity after file copies.

Use as soon as Possible: As we know that checksum mismatch will shutdown the running mysql server so use this utility to as soon as possible rather than waiting production database will encounter the damaged pages.

Note: innochecksum does not work on tablespace files that the server already has open. For those types of files you can use CHECK Table command to check tables within the tablespace.

Recover Tablespace: When innochecksum utility finds checksum mismatch for the innodb tablespace files then it is recommended you to restore the tablespace from backup or start mysql server and use mysqldump to make a backup of table’s within the tablespace.

How to restore without Backup: If you don't have backup of corrupt tablespace then you should try any third party MySQL repair utility that will restore corrupt tablespace of mysql database.

Attention: Always maintain a backup for any database to avoid data loss when disaster will strike to the database.

Summary: innochecksum is an offline innodb file checksum utility that calculates, compares and reports checksum mismatch for innodb database. You can restore corrupt tablespace from backup or using any third party MySQL repair utility.

Date Published: Oct 04, 2011 - 11:04 pm

Incorrect Information in .FRM file of MyISAM storage engine

MySQL database uses tables to store data and all these tables are defined by .FRM file. FRM is an internal file in MySQL database that contains the formating information or structure data for the database. It defines fields and structure of each MySQL's table. Regardless of the storage engine that you choose, every MySQL table is represented by .frm file. File bears the same name as table name with extension .FRM.

Example: suppose you have create a employee table in mysql database then frm file name will be employee.frm that will define the employee table.

Corruption in MySQL database table will resist you to access the table that can be happen due to several reasons like kernel bugs, unexpected power failure, hardware failure, virus attack, and many more. A corrupted table will placed the incorrect information in the frm file and you may got below error message:

“Incorrect information in file: './able-name.frm'”

Resolution: you have three solutions to repair MySQL table after getting above error message:

Repair corrupt table by REPAIR TABLE statement
Restore from Backup
Stop and copy method

Stop and copy method details
Note: if you are using MyISAM storage engine then follow the below steps to repair corrupt table:

Stop MySQL database
Take backup of your .frm, .myd, myi files.
Delete these files from mysql data directory.
Now start MySQL Database
Rereate table again by CREATE Table statement.
Stop MySQL database.
Copy .myd & .myi files back into the data directory, replace the ones there.
Start MySQL database again.

If all three methods fail to fix the corruption from table then at last you should try Stellar Phoenix MySQL repair software. MySQL repair software repairs corrupted table created using MyISAM as well as Innodb. This software has around 99 percent success rate. Its very safe and offers easy-to-use interface.

Date Published: Sep 09, 2011 - 4:55 am

REPAIR TABLE statement to Repair corrupt MySQL Table

MySQL database offers seven syntaxes for proper maintaining of mysql table's records. Those syntaxes are as follows:

Repair table syntax
Analyze table syntax
Backup table syntax
Check table syntax
Checksum table syntax
Optimize table syntax
Restore table syntax

In this article, we will discuss briefly about first syntax that is Repair Table syntax.

REPAIR Table Syntax: It repairs corrupted mysql database tables. A table gets corrupt due to several reasons like virus attack, system failure, power failure, hardware problem, power failure and so on. Corrupt mysql database tables can be repair by this syntax.

Systax for Repair Table:
“REPAIR [NO_WRITE_TO_BINLOG | LOCAL] TABLE
tbl_name [, tbl_name] ...
[QUICK] [EXTENDED] [USE_FRM]”

Above syntax has three options like quick, extended, and use_frm.
When you select “quick” option then repair table syntax will try to repair index file only. This kind of repair is done by myisamchk.

When you select “extended” option then mysql database creates row by row index in place of one row at a time. This kind of repair is done by myisamchk.

Use_frm option is available only when header file is corrupted or index file missing. This kind of repair is not done by myisamchk.

Caution: It is the best method to take a backup of corrupt mysql database table before trying “Repair Table” syntax on it.

Sometimes above repair syntax also fails to fix corruption in mysql database at this situation most of the database administrators suggest to try any third party mysql database repair software. It totally depends upon you to choose the best mysql repair tool that meets your requirement and budget.

Date Published: Sep 07, 2011 - 4:26 am

How to Repair MySQL Table using phpMyAdmin?

MySQL is a relational database and uses table to store the data. Table has column and row to store records. An Individual column must be created to store each type of data like employee name, employee code, employee address, age, sex, and many more. On the other side row contains the actual value that specified with the column of table.

Example: Lets consider an example, we have created an employee details table. Employee details table has five columns employee name, employee code, employee address, employee age, and employee sex. We can insert values into the employee details table through the insert query.

We have inserted John, s0300, New Jersey, 28, and M. Wherein

John= Employee name

s0300=Employee code

New Jersey=Employee adress

28=Employee age

M=Employee Sex.

Corruption in Employee Details Table: Corruption in the above table can happen due to severely reasons like operating system failure, power failure, hardware problem, metadata structure corruption, virus attack, and many more.

How to Repair?: When MySQL database tables get corrupted or damaged, you can repair and restore corrupted MySQL table by carrying out the below mentioned methods.

PhpMyAdmin Method

Third party repair software method

Repair using phpMyAdmin: Follow the below steps to repair corrupt MySQL database table through phpmyadmin.

Login to the phpmyadmin.
Select the database.
Note: if you have only one database then it will be selected by default.
Goto to the main panel and choose database.
Select the corrupted MySQL database table.
Goto to the bottom of the window and click on the drop down menu.
Select Repair Table from the menu.
And phpmyadmin automatically fix the corruption in the table.

Third party repair software: If you are unable to repair corrupt MySQL table through above mentioned method then you should try any third party MySQL repair software. MySQL repair software is very helpful in most of the corruption cases and repair table up to ninety nine percent. These software are safe in nature and don't harm your database.

Top three MySQL database repair software: Top three MySQL database repair software are stellar phoenix database recovery for MySQL, recovery for MySQL, recovery toolbox for MySQL.

Date Published: Aug 23, 2011 - 4:01 am

Feed: MySQL Database Recovery - AggScore: 45.4

Summary: Share Knowledge about MySQL Corruption & Repair Methods

Reliable Utility to Resolve MySQL Error Code 144 and Recover Precious Data Back

How to Check, analyze & repair MySQL database corruption by mysqlcheck

MySQL server (mysqld) Fails, How to fix it?

Check & Repair Corrupt MySQL Database using myisamchk

What are the Importance & Use of MySQL database Backup?

How to Restore MySQL database from Program files?

Perform Backup & Restore On MySQL Database Table

Repercussions of InnoDB table corruption and MySQL database recovery

How to Recover Corrupt MySQL Database - MySQL Recovery

Types & Comparison between MySQL database Storage Engines

Analyzing the root causes of Index file corruption in MySQL and methods to perform database recovery

How to check & verify InnoDB TableSpace File Corruption

Incorrect Information in .FRM file of MyISAM storage engine

REPAIR TABLE statement to Repair corrupt MySQL Table

How to Repair MySQL Table using phpMyAdmin?

Visitor Rating: 5 (1) (Rate)

Story Clicks: 1

Feed Views: 41

Tags

Lenses (Add|?)

Comments (Log in to add)

Feed Details

Search FeedAgg.com