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 - Where Do I Start?

[ad_1] Search engine optimisation (SEO) - The process of impacting the ranking of a website on a search engine's results for specific keywords to gain organic visibility Every search engine combined receives over 6.5 billion searches a day with Google contributing around 4.5 billion of the searches. The benefits of a good SEO are huge, from your sites ranking within keyword searches to increasing the possibility of conversion. As a consequence, developing a good SEO involves many obstacles, the largest being how a search engines rank websites is unknown to everyone. For example, Google uses an algorithm involving over 200 factors to determine the ranking of websites for a specific search yet Google will never release information on any of the factors. But through persistent testing, web designers have been able to identify some factors to include into your website and research. Market knowledge You must know your target market, including understanding the keywords potential visitor...
Post a Comment
Read more

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

SEO Techniques For Wordpress Blogs

There's a lot of amazing SEO power built into WordPress. Unfortunately it doesn't all come by default, and you might not know what's best when it comes to templates and options. This simple, easy to follow article will outline many WordPress SEO tips which people often forget to implement (even the most famous bloggers), or haven't yet arrived at for some reason or another. If you want to see your wordpress site show up in the search engine results you are going to have to do a little on page search engine optimization. Quick Facts * There are 55 million blogs out there, if you don't stand out you will have no chance. * The first second of a visitors attention is the most crucial. * Your main traffic should come to articles and posts inside your blog, not the home page. * Search engine rankings relies heavily upon the quality and quantity of links to your blog when they determine the ranking. * The best way to get links is by natural recommendations from other blogg...
Post a Comment
Read more