Repairing a Broken Database in Account Manager

A broken website database can lead to downtime and data loss, often caused by corrupted files, misconfigurations, or server issues. You can diagnose and repair these errors using database tools in Account Manager to restore functionality quickly.

• Checking Your Database
• Repairing Your Databases
• Additional Troubleshooting
• Summary

If you encounter the following error, you can quickly resolve it by using the database tool available in your Account Manager.

Checking Your Database

1. Log in to your Bluehost Account Manager.
2. Navigate to the Websites tab on the left side of your Account Manager dashboard and select the website you are working on.
   
   Another way is to navigate to the Hosting tab and click the MANAGE button to select the hosting package you're working on.
   
3. Once you locate your website, click Settings.
   
4. Under the ADVANCED tab, look for the Databases card and click its MANAGE button.
   
5. Here, you can now access your Databases Management panel.
   
6. From this section, choose the database name you're experiencing issues with by verifying the associated Site.
   
7. Once you locate the database associated with your website, click the vertical ellipsis icon and then select Check Database.
   
8. If the process is successful, a green check mark icon will be displayed.
   

Repairing Your Databases

The diagnostic process will pinpoint the issue. If the result shows "Issues were detected. Repair recommended," proceed with the steps below to address it.

1. Choose the database name you're experiencing issues with by verifying the associated Site.
   
2. Locate the database linked to your website, click the vertical ellipsis icon, and then choose Repair Database.
   
3. If the repair process is successful, a green check mark icon will be displayed.
   
4. If a red exclamation point icon is still displayed, consider the following options below:

Additional Troubleshooting

For detailed guidance on repairing and optimizing your database tables, refer to our article: MySQL Repair and Optimize Tables in phpMyAdmin to learn more.

If you have reliable backups of your database in CodeGuard or Jetpack, check our articles for a detailed tutorial:

• Restoring Backups with CodeGuard
• Jetpack Backup and Restore

Summary

A database error occurs when your website cannot correctly connect to or interact with its database, often resulting in messages like "Error establishing a database connection" or "Database marked as crashed." These errors can disrupt your site's functionality. In this article, we provide a set of instructions on using database tools in your Account Manager to check and repair the database. It also includes troubleshooting tips for persistent issues and links to resources for optimizing databases or restoring backups.