How to solve ‘MySQL server has gone away’ error in my application

Published by Jacob Martin on March 3, 2015

Nowadays, people work a lot and because of this huge amount of workload or large number of database also take place. Therefore in order to store, create, and manage such bulk sized, large number of database a capable application was required.

Although MySQL is a core process for maintaining numerous copies of data – and it is a very important aspect in database administration. In order to synchronize data between master and slaves you need to make sure that data transfers smoothly, and to do so you need to act promptly regarding replication errors to continue data synchronization. However the segment offers information about the need of using SQL erver database restore program when your server is struck with an error message -1236.

The error message is “got fatal error 1236” can be triggered by several reasons that you get. However there are tow main reasons for such type of error message:

• The MYSQL query that you are truing to execute takes too long and MYSQL server times out

The solution of this issue is to optimize your database for the queries which fail

• You have crashed table in your database

However the solution in this case is to repair and optimize your database.

This error occurs when the slave server required binary log for replication no longer exists on the master database server. In one of the scenarios for this, your slave server is stopped for some reason for a few hours/days and when you resume replication on the slave it fails with above error.

If a particular table crashes often and repairing/optimizing it does not help, this most probably means that the table’s structure has an issue with our MySQL server setup. In such cases the easiest way to fix a crashed MyISAM table for good is to change its database engine from MyISAM to InnoDB.

How to solve the MySQL error-1236

However there are several reasons for the occurrence of the error mentioned above but there is a solution by which you can resolve the error and you can get back the data without losing any data. You can use third party utility as this third party tool will help you to fix the issue and your original data will be delivered.

You should use MySQL File Repair tool which is an excellent tool. This tool is very powerful recovery software to recover corrupted MySQL server database files. When there is a sudden database fails or some other emergency comes then MySQL repair tool meet these requirements very perfectly. With the help of this software, you can recover back all the saved information in Transact-SQL script that is fit for quick database recreation. Also it recovers table structure and data. MySQL repair tool is very easy to use and it also does not require any technical knowledge. It supports MySQL versions like 5.x, 4.x, 3.x, 2.x and 1.x and available for all modern platforms which includes windows 95/98/2000/XP/2003 server. It has the ability to repair password protected SQL files smoothly. So without wasting time, you should download MySQL Repair Tool.

Steps to solve ‘MySQL server has gone away’ error

Step 1: Download, install and launch the MySQl Database repair tool.

Step 2: Click ‘Select’ button to find and add corrupt MySQL database to the application and then select OK. Here you have the option of ‘Repair corrupt database which is stored at default location of MySQL’ and ‘Manual option to selct your database from default location’.

Step 3: After the scanning process you can now see the preview of the file in the left panel of the software.

Step 4: Now you can start the reairing process, just click on Repair button. A dialoguie box will appear. Click Yes.

Step 5: After successful completion of the process, a message box is displayed as ‘repair process finished successfully’. Click ‘OK’ to close the message box.

524 Total Views 1 Views Today