Repair/Optimize Database

Introduction

AutoKB's database repair and optimize function allows you to repair and "cleanup" the MySQL database tables that it uses so they are optimized for both speed and disk usage. In general, you will not need to run this command more than once every few weeks, as MySQL is quite efficient in maintaining it's datafiles. The only time you may need to run it more often is if you delete or add a large number of articles to your database or one of your database tables has crashed and needs to be repaired.

Repairing and Optimizing Your Database

The only time a database table would need to be repaired is if you are getting an error message telling you that it has been damaged. AutoKB will always run the repair command on the tables before optimizing them, as it will not hurt the tables if they do not need to be repaired. If you ever get an error message that contains information about a database table, you should try running the Repair/Optimize function first to see if it can be automatically corrected.

To repair and/or optimize your database, simply click on the Repair/Optimize Database link in the Setup section of the control panel menu. A small window will pop-up and let you know that the procedure is in progress and it will tell you when it is done. There is nothing further that you need to do, your MySQL database repair and optimization is complete.