Roxy

If by chance, and lets hope not, you ever have a problem with either your whole database or with just a table within the database, here are two very easy ways to fix them on your own. Of course there are no guarantees, as sometimes errors can be bigger then they look, but this is one way to help yourself rather then asking support.

MySQL Database in cPanel

This will probably be the easiest way to do this. Going into your cPanel, click on the MySQL Database icon under the databases category. Not even having to scroll down, you will see two drop down menus with a list of all of your databases. One is to check the whole the database, while the other to repair it. Its a good idea to check your DB on a regular basis, so that you'll know if anything wrong and can quickly fix it. Now click on the repair button for the problematic DB.



The page that comes up will show you a list of all of the tables made under that database and whether they are OK (fixed) or not (not fixed). This is also a great image to have to show support if need be.



PHPMyAdmin

The second way to fix your database would be through PHPMyAdmin. Its suggested to learn a little bit about this software before using it, as its more complex then just using the MySQL DB feature in cPanel. You basically have more control over your DB within PMA and can create, modify, delete and so on with your DBs and tables. Clicking on the PMA icon in cPanel will redirect you to your PMA home page. You will notice the list of all of your DBs on the left hand side bar. Click on the one that is having problems.



You're then taken to a page with the list of all the tables under that database. There are a few features that come along with each table, but that'll be explained in a later tutorial.



Here you are able to select individual or multiple tables at once, rather then having the whole DB repaired. Not much of a big difference, but convenient. Once selected (by clicking on the radio button next to it) there is a drop down menu at the very bottom of the tables table. Click it and then select where it says repair table. On the right bottom hand corner click on the go button and there you have it!



Good luck!