subject: Tips To Resolve mysql Server Has Gone Away Error Message [print this page] Most frequent MySQL database users must have encountered database corruption error messages while attempting to access the records. While many of the error message are primarily a result of human errors, few might can also occur due to internal system malfunction, power outage and virus attacks. A major hazard that you might encounter after your MySQL database corruption is database unmountability and records inaccessibility. In such situations, an updated database backup comes to your rescue by restoring all the required database records. However, the database backup does not restores the desired records, then you will need to search for an advanced mysql database repair software that provides complete database repair.
To illustrate the above scenario, consider a situation where your MySQL database is corrupted and you encounter the below error message when you attempt to access its records:
ERROR 2006 (HY000): MySQL server has gone away.
The above error message appears every time you run a query to access the database records. In addition, the above error message makes data stored in the database inaccessible.
Cause:
MySQL database corruption.
Resolution:
To resolve the above error message and accessing of data, you will need to run OPTIMIZE TABLE tablename command. You will further receive any of the below error messages:
ERROR 1030 (HY000): Got error -1 from storage engine
Or
ERROR 1030 (HY000): Got error 28 from storage engine
The first error message appears when database could not recover from previous database crash. The second error pops up when there is no space left on the device.
To repair your database, you will need to follow below steps:
1.Add the below line into mysqld section in my.cnf:
innodb_force_recovery=4
2.Stop mysqld and and restore data backup to mysqld data folder.
3.Re-start mysqld and perform a thorough check on your tables.
4.Run some queries.
5.Optimize all your tables.
The above resolution fails to perform when you have not created any database backup. In case no backup is available, you will need to use advanced MySQL Database Repair utility. These MySQL Repair tools use intensive scanning methods to orderly repair the corrupted database.
Stellar Phoenix Database Recovery For MySQL is an effective repair software that repair corrupted MySQL database installed on Linux or Windows platform. Supported by MySQL 5.x and 4.x, the mysql repair software provides absolute recovery of almost all MySQL components, such as, tables, primary key(s), and relations.
