Every once in a while it is a good idea to check your MySQL databases to see if any of your tables are out of whack. I make no claims as far as database expertise, but I do know the layman’s method of checking and repairing databases and wanted to share. Personally, I will conduct a check daily, as I am typically logged into my site’s CPanel, but I’d recommend the average guy do this every week or two, just to make sure everything is working properly. Here’s how:

Checking & Repairing Your Website’s MySQL Databases

  1. Log into your websites control panel (CPanel)
    cpanel

  2. Go to your main database panel by clicking on the MySQL button
    mysql

  3. Choose a database from the list and click on the “check” link
    check your database

  4. If your database is in need of repair, you’ll see a page like the one below, with one or several different tables that are not listed as “OK”
    database errors

  5. You’ll need to return to the main MySQL menu and click on the “Repair” link to fix any problems
    repair MySQL

  6. Your database should now be repaired and you’ll see a clean page with all “OKs”
    clean database

  7. Repeat the process for all of your databases until they are all fixed, and you’re done!

That’s it! Quick and easy.

Share This