Fixing the “MySQL Server Has Gone Away” Error in WordPress

Given that databases make up the majority of contemporary websites, you should take mistakes seriously if they have an impact on your website. For instance, the error “MySQL server has gone away” might lead you to think that your database has been lost. It implies that in order to get your website up and running, you might need to restore your most recent backup.

Even though it seems a little difficult, fixing this problem is actually rather simple. Your website will return to normal in a matter of minutes if you just follow the instructions exactly.

You can fix the “MySQL server has gone away” issue and learn what causes it by reading this post.

Understanding the “MySQL Server Has Gone Away” Error

At first, let’s see how the “MySQL server has gone away” error looks like:

You can see that the error itself is straightforward and it almost always is displayed in the same way. Based on the browser you use and server configuration, the words might change to some extent.

From the error itself, you can identify that it is related to your MySQL database. For being more specific, the reasons for this error to occur on most websites are as below:

A broken table is present within your database. Your database gets corrupted and so you need to get back to a recent backup or repair it.

The PHP ‘timeout’ setting is lower than what it should be. In case a PHP script requires accessing your database and it isn’t able to fetch the information within the timeout window that is set, this can also give rise to the above-mentioned error.

The packets are dropped or may be are too large. The server might believe the same and closes the connection, displaying the error.

Thankfully, you can easily address these issues. Let’s see the troubleshooting process for them.

3 Ways to Fix the “MySQL Server Has Gone Away” Error in WordPress

As mentioned above, there are a few potential reasons for this particular WordPress error to occur.

You have different possible solutions for this error. In several cases, one of the below method will help you to get rid of the error on your website. So, if one doesn’t help you, you can try another one.

1. Editing Your WordPress wp-db.php File

In case your website’s PHP timeout setting is extensively low and your database is very large, you won’t be able to fetch the data required. As mentioned earlier, this can display the “MySQL server has gone away” error.

In order to avoid this, it is required to edit one of your WordPress core files, called wp-db.php. This file is located within your WordPress root folder, by opening up the wp-includes directory:

In order to access these files, it is recommended to use an FTP client such as FileZilla and connect via SFTP. After you get connected to your site, find wp-db.php, and right-click on it to open the file using your default local text editor.

Then, search for the following line in the file:

$this->ready = true;

Now add the below line right below that code:

$this->query("set session wait_timeout=300");

This code will set your PHP timeout value to 300 seconds, which is a lot more than you need to avoid any errors from showing up.

Then save the changes to your wp-db.php file and ensure your website is loading normally.

2. Repair Your WordPress Database

Sometimes your WordPress database can get corrupted and this can trigger error when you try to establish a connection with it. Though this isn’t common, it can happen even with a normal website’s growth when you add more tables to your database ( plus plugin and theme information).

For fixing this issue, a built-in WordPress function can be used to repair your database. At first, you will need to enable that feature. This can be done by accessgin your WordPress root directory and opening the wp-config.php file for editing it.

After file is open, scroll to the bottom and add the below line to it:

define('WP_ALLOW_REPAIR', true);

This code asks WordPress to enable the database repair function. Next save the changes to wp-config.php, and close the file. To run the function, just browse the below URL:
https://yourwebsite.com/wp-admin/maint/repair.php

WordPress will then prompt that you want to simply repair your database or repair and optimize it. Select the first option to fix the “MySQL server has gone away” error:

It will need just few minutes for the process and when it’s done, the error in question will get disappeared. But there is still some cleanup left to do, because you will need to disable the database repair function on your website. If you avoid this, anyone can trigger it by accessing the same URL.

So, go to your WordPress root directory and remove the line of code which you had added earlier. After this, save changes to the file and close it.

3. Restore Your Website Using a Backup Through Your Hosting Provider

Use your website’s complete backup to restore it to a point where the database was operating correctly if none of the aforementioned solutions work for you. Naturally, in order to minimize data loss, this must be done using a recent backup.

Not every WordPress site hosting company gives its customers access to built-in backup features. As a result, employing plugins for backups becomes difficult for you regularly. These tools aren’t horrible, however recovering backups gets very difficult if you can’t reach your WordPress admin area.

You may purchase the website backup function offered by Hostvento, but you shouldn’t pass it up.

Conclusion

When your website is in growing, it will need to store more data. All the information gets stored into your WordPress database. In some cases, if the data is too big, you might get errors such as “MySQL server has gone away”.

Now that you know the troubleshoot process, you can get rid of this annoying error message.