Skip to main content

How to Fix a Corrupted WordPress Database

[ad_1]

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 use database_name; to access the database.

• Type in show tables to view all the tables. Look for the corrupted table from the list.

• Type in check table wordpress_table_name to ensure that this is the table that is giving you the error.

• Now it's time to repair the corrupted table. You can do this by keying in repair table wordpress_table_name.

c. In cPanel:

• Log into cPanel and find your MySQL Databases.

• Select the database from the dropdown list under MySQL Databases.

• Click the Repair DB button.

If the SSH option seemed rather long for you, try this shortcut:

• type in mysqlcheck database_name to see which tables has crashed.

• then type in mysqlcheck database_name --auto-repair to repair the corrupted files.

You could also set up WordPress to automatically repair corrupted databases by adding this line:

define('WP_ALLOW_REPAIR', TRUE);

into your wp-config.php. This works only for WordPress version 2.9 or later.

Two things that you should always do with regards to WordPress databases: Backup and Optimize.

Optimizing your database is very much like defragging your hard drive. It is a way to clean up your database so that it runs smoothly. Optimizing helps clean up your database and frees up server disk space.

Check out the following plug-ins to help you optimize your database:

• WP-Optimize: This plug-in allows you to optimize and clean up your database and perform other tasks easily and with just a few clicks.

• Clean Options: If you have orphaned options in your database, this plug-in could help you easily clean them up.

• WP Database Optimize: This allows you to set up a schedule for your optimization.

Backing up your database should help you get back on your feet if more database problems arise and these suggestions do not work. Instead of losing your blogs, articles and readers, you can just restore a previous backup of your WP installation.

And that's how you fix a corrupted WordPress database.


[ad_2]

Source by Sherly A. Mendoza
Labels:

Comments

Post a Comment

Popular posts from this blog

SEO Vs Google Ads - Which One Is Better?

[ad_1] Companies and shops that have created a website to showcase their products/services would certainly like as many potential customers to find it. However, they should find a way for their website to land on top of search results. When viewers are able to search their products/services on Google, their webpage is displayed in either organic search results or Google paid ads. Organic Search Results and Search Engine Optimization (SEO) People can find organic search results just below paid ads. If businesses like to rank among the top in organic search results, they have to optimize their site. Google's first and foremost objective is to direct users to the most relevant, high quality content related to the topic they are searching. Advantage SEO lets their webpage appear in search results with no costs. Their efforts will produce results that will last for so long. Disadvantage SEO is a very long, continuous activity and certainly, competition is working hard as well. More ofte...
Post a Comment
Read more

What Exactly Is SEO and Why Does My Website Need It?

[ad_1] Some people are not familiar with the term SEO. Others may have heard about Search Engine Optimisation (SEO), but may not be aware of its meaning and significance. There are actually a number of things that are critical to a website more than ranking high in search engines, though, when different people are asked, they have different ways of achieving this. To get a more comprehensive and accurate answer, people can look closely at Google's guidelines found on the Webmaster Tools site, and search under SEO's hood. In the past, SEO has earned a bad reputation due to a number of individuals who made use of unallowed techniques to benefit from search engines, rather than work with them. The wrong choice of SEO professionals has negatively affected the reputation of many websites, making them invisible in search engine rankings when Google updated their algorithms. On the other hand, deciding to choose quality SEO professionals can give several advantages to a website, inclu...
Post a Comment
Read more

The Easy Way To Create An Affiliate Marketing Blog

[ad_1] When it comes to setting up an affiliate marketing website, you have a few options. You can choose to create a static website using HTML. This requires you to know the specific programming language. You will also need to have an HTML editor handy to create your pages. An alternative to this is setting up a blog using WordPress, which is a free platform that many people are using to build their affiliate sites these days. Why WordPress? There are many benefits to using WordPress for your affiliate marketing efforts. For one, it can be easily installed from your web host's cPanel. You can use Fantastico to install WordPress in less than one minute. Once it's up and running, your site is live with a fully functional blog for you to use to promote your affiliate products. Another reason many affiliate marketers prefer WordPress is because of the easy to use admin panel. When you log into your WordPress installation, you will have access to the different sections of the admin...
Post a Comment
Read more