How to check MySQL databases for errors
If you are unable to access or connect to one of your MySQL databases, you can check it for errors within the Hosting Manager.
To check your MySQL database for errors, follow the steps below:
- Click on My Account at the top of the page.
- Select Hosting Manager from the drop-down menu.
- Enter your username and password, and click Log In.
- On the Home page, click the word Databases or the [ v ] arrow symbol on the right side.
- Click the MySQL Databases button, which is next to phpMyAdmin icon.
- Under Modify Databases, go to Check Database. Select the database you want to check, then click the Check Database button to the right.
- The system will then run a script to check the database.
If the system detects an error, it will say so in the results page and will even specify where the corrupted files or sections can be found.
If the database has no problems, it will display grey box with list of sections with OK statuses and the phrase Check Complete at the bottom.
Congratulations, you now know how to check MySQL databases for errors.
If the Checking Database test returned some errors, you can try to resolve these by running Repair Database. To know how to do this, click the link below.
If you have a backup copy of your MySQL database, you may also restore your database to a previous version. To know how to do this, click the link below:
If you want to learn more about database connection errors, click the links below:
Note: There is also the possibility that the likely causes of service unavailability are either a temporary high load on the server, or the service is being restarted. This should clear up within minutes.
If you want to know how to access your Hosting Manager, click here.
If you want to know how to backup MySQL databases, click here.
Fantastic...Thank you for your feedback =)
Sorry... Please submit a support ticket or try another search.
- How to backup MySQL databases
- How many MySQL databases can I have?
- Add MySQL databases to your Web Hosting
- Check MySQL with Telnet
- How to fix a MySQL database