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
- Log into your websites control panel (CPanel)
- Go to your main database panel by clicking on the MySQL button
- Choose a database from the list and click on the “check” link
- 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”
- You’ll need to return to the main MySQL menu and click on the “Repair” link to fix any problems
- Your database should now be repaired and you’ll see a clean page with all “OKs”
- Repeat the process for all of your databases until they are all fixed, and you’re done!
That’s it! Quick and easy.
Related posts:
I'm glad you found it helpful! I guess I'm doing my job then!
- spam
- offensive
- disagree
- off topic
Like