WordPress Database Repair
June 30, 2015 / by Marco / Categories : Technology
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:
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.
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);
Here’s a list of resources that you might find useful:
OTHER ARTICLES YOU MAY LIKE
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
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

