By "repair", this article means using the "db repair" utility of your web host for maintenance purposes and assumes that you database is still in working order. "Repair" here does not mean fixing a database that has been heavily corrupted due to bad upgrades/mods or hardware issues, etc. In those case, the below method may not work.

Sometimes, you might find that your ZenCart store is running a bit slow. One possibility is that with heavy use, the database indexes needs to be re-indexed in order to maintain optimal performance.

In some webhost, they will have an utility via their cpanel to "repair" a MySQL database. They called it "db repair". But essentially, it re-indexes the all the tables of the database.

Regardless, of whether this is the cause of your performance problem or not, there is no harm in trying the "db repair". It should not have any adverse effects regardless of whether your database needs it or not.

Using Hostmonster as an example, the process of performing the database repair would be ...

• Log into the webhost's cpanel.
• Click on "MySQL databases".
• Under the "Modify Database" section, select the database being used by your ZenCart store. And click "Check DB".
• Selection the database, and click "Repair DB".