How to Fix a Corrupted WordPress Database

how-to-fix-a-corrupted-wordpress-database Published 1 month ago Views (16) Finance

WordPress is controlled by its database. You cannot display a post properly if your database is corrupt, as sometimes the categories and tags are all wrong, or sometimes you cannot even log in.

However, corrupted databases for WordPress happens more than you would have liked. And it could be because of a variety of reasons, such as installing a faulty plug-in, your WordPress being hacked, a server crash, hardware failure on your server, or a bug in MySQL, or for no particular reason it seems.

Before you panic, though, take a deep breath and know that there are simple ways to fix a corrupted database.

So what do you do when the dreaded error message, “… is marked as crashed and should be repaired” crops up?

Fix corrupted WordPress databases via SSH or PhpMyAdmin, or cPanel

a. PhpMyAdmin – find the suspected WP database and check the table that has been corrupted.

Then look for the drop-down box and select “Repair table” from the options.

b. Secure Shell

• Log into your shell, then access the databases by keying this in mysql -u username -p database_name.

• View all the databases by typing in show databases.

• Then type in...

Content Source

profile-avatar

Kwame Alexander is a poet, educator, publisher, and New York Times Bestselling author of 36 books, including SWING, BECOMING MUHAMMAD ALI, co-authored with James Patterson, REBOUND, which was shortlisted for prestigious UK Carnegie Medal, The Caldecott Medal and Newbery Honor-winning picture book, THE UNDEFEATED, illustrated by Kadir Nelson, and his NEWBERY medal-winning middle grade novel, THE CROSSOVER.

Related Posts