WordPress database controlled by it. You can not display posts properly if your database is damaged, because sometimes all the wrong categories and tags, or sometimes even if you can not log in.However, corrupted database for WordPress happen more than you would like. And may be due to various factors, such as faulty installation of plug-ins, mother WordPress hack, server crashes, hardware failures on your server, or MySQL bug, or for no particular reason that you seems.
Before panic, though, take a deep breath and know that there are simple ways to fix a broken database.So what do you do when the dreaded error message “… is marked as crashed and should be repaired “crop up? Fix broken WordPress database via SSH or PhpMyAdmin, or cPanela. PhpMyAdmin – Find suspected WP database and check the records that have been corrupted.Then search drop-down box and select “Repair table” from options.b. Secure Shell
Login to your shell, then access the database by entering into mysql-u name-p database_name
See all event database by typing Database
Then type in use database_name; … To access the database
To type a display table to see all the tables. Find a broken table from the list.
Please check wordpress_table_name typed table to ensure that it is a table that gives the error.
Now it’s time to repair the damaged table. You can do this by applying corrections wordpress_table_name.c table. CPanel:
Login CPanel and locate your MySQL database
Select the database from the dropdown list at the bottom of the MySQL Database
Click the Repair DB button.If SSH option seems a bit long for you, try this shortcut: ..
DATABASE class to look at tables fallen mysqlcheck then type DATABASE
mysqlcheck – auto-repair to fix broken files.You can also set up WordPress automatically repair the corrupted database by adding this line:. define (‘WP_ALLOW_REPAIR’, TRUE); wp-config.php. It works only for objects WordPress version 2.9 or later.Two you should always do the WordPress database: Backup your database and Optimize.Optimizing quite like defragging your hard drive. It is a way to clean up your database so that it runs smoothly. Optimization helps to clean up the database server and free up disk space.Check out the following plug-ins to help you optimize your database:
WP-Optimize: This plug-in gives allows you to optimize and clean up your database and perform other tasks with ease and just a few clicks
Clean Options:. If you are an orphan option in your database, plug-ins can help you easily clean WP
Database optimization:. It allows you to set a schedule for optimization.Backing up your database will help you get back on your feet if more problems arise database and these suggestions do not work. Rather than lose your blogs, articles and readers, you can simply restore the previous backup WP installation.And you how to repair the corrupt database by WordPress.