WordPress Database Repair

June 30, 2015   /   by Marco  / Categories :  Technology
WordPress Repair Database

Today, one of my sites was not loading correctly – images and text were not displaying which I guessed that the database was corrupted.
In an older post I outlined how to repair mySQL tables using a tool called mysqlcheck. This process may have been a bit too difficult for some so I wanted to outline an easier way of doing a repair if you’re using WordPress. Follow these steps:

1. Login to your hosting account

2. Edit the wp-config.php file

3. Add the line

define('WP_ALLOW_REPAIR', true);

So the config should look like this:

WordPress Repair Database

4. Make sure you save the file.

5.Now go to your wordpress site: e.g.

http://websiteaddress.com/wp-admin/maint/repair.php

You will see the below screen. Just click on Repair and Optimize Database.

WordPress Repair Database Screen

6. Let it run and once completed test your site to see if it now works.

7. If it works, then go back into the wp-config.php file and remote the line

define('WP_ALLOW_REPAIR', true);
RESOURCES

Here’s a list of resources that you might find useful:

WordPress Site

Other method for repairing database using mySQL

DO YOU LIKE WHAT YOU'VE READ?
Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!

Our Sponsors

  • Follow us:

OTHER ARTICLES YOU MAY LIKE


REVIEWING AND UNBOXING THE TOOCKI USB-C RIGHT ANGLE 1.2M CABLE

REVIEWING AND UNBOXING THE TOOCKI USB-C RIGHT ANGLE 1.2M CABLE

USB C cables are among the most ordinary accessories we own, yet they can make a surprisingly noticeable difference to how comfortable our devices are to use while charging. The Toocki USB C right angle cable is a good example of a simple accessory that tries to solve a very common irritation, because instead of […]

read more
SUPABASE BACKUP TUTORIAL: USE DBEAVER TO EXPORT YOUR DATABASE SAFELY

SUPABASE BACKUP TUTORIAL: USE DBEAVER TO EXPORT YOUR DATABASE SAFELY

If you are building anything serious on Supabase, whether that is a client portal, a SaaS app, an internal dashboard, or even a small side project that is starting to get traction, having a reliable database backup process is one of those tasks that quickly moves from optional to essential. Supabase makes a lot of […]

read more

Like our Page