Place of all tech articles

techarticles

  • Home
  • About
  • aStore
  • Contact Info
  • Tools
    • SEO Page Audit
    • SEO Keyword Rank
    • google pagerank checker
    • whois

Repair WordPress Database by PhpMyAdmin

28th February, 2014 · techinf1

Repair WordPress Database by PhpMyAdmin

This post will describe how to “Repair WordPress Database by PhpMyAdmin” in step by step. WordPress use MySQL database; and sometimes MySQL table become inaccessible due to some errors and need to be repaired. “Repair WordPress Database” is an easy procedure but may save you at your very crucial moment.

  1. Log in to your cPanel and select phpMyadmin

    cPanelPHPMyAdmin

  2. After logged in to phpMyAdmin, select the database from the right corner
    PHPMyAdminDatabase
  3. Check all tables
    PHPMyAdminCheckTables
  4. Just right of check all select “Repair table”
    PHPMyAdminRepairTable
  5. Check the output after clicking “Repair table”
    PHPMyAdminRepairOutput
  6. Repair all tables by sql command
    you can also run repair command from your sql window or sql command prompt.

     REPAIR TABLE  `wp_commentmeta` ,  `wp_comments` ,  `wp_links` ,  `wp_options` ,  `wp_postmeta` ,  `wp_posts` ,  `wp_terms` , `wp_term_relationships` ,  `wp_term_taxonomy` ,  `wp_usermeta` ,  `wp_users`
    

Repair is not a frequent operation. It requires only when you can’t access a table of your database. However for safe purpose you can run it once a month

There is a same procedure by which you can Optimize WordPress Database by PhpMyAdmin

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Posted in Database, MySQL, WordPress |
« Optimize WordPress Database by PhpMyAdmin
Migrating WordPress website to a new hosting provider »

Leave a Reply Cancel reply

Android App to challenge math ability
MathQuiz

Top Posts

  • Optimize MySQL table_open_cache
  • Optimize MySQL query_cache_size
  • Optimize MySQL tmp_table_size
  • Optimize MySQL innodb_buffer_pool_size
  • MySQL Replication skip error

Recent Posts

  • Recover MySQL 5.7 root Password in Redhat/CentOS 7
  • SSH login without password in Linux
  • How to write automated FTP script in Linux
  • Installing Nginx with PHP support
  • How to access HTML5 local storage

Follow US

Follow US

Categories

© Techinfobest is the house of tech articles
  • About
  • aStore
  • Contact Info
  • google pagerank checker
  • SEO Keyword Rank
  • SEO Page Audit
  • Tools
  • whois