Optimize and Repair Database

Introduction

TGP Rotator's database optimize function allows you to "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 a large number of galleries from your database.

In some cases, usually after your server recovers from a serious error, your MySQL database may become corrupted. When this happens you will get error messages from TGP Rotator indicating that there is a problem with one or more of your database tables. In most circumstances MySQL is able to repair damaged tables with it's built in functions. TGP Rotator allows you to run these built in functions through the Database section of the control panle menu. If you ever get these types of error messages, simply login to the control panel and use the Optimize/Repair function.

Optimizing and Repairing Your Database

To optimize and repair your database, click on the Repair/Optimize Database link in the Database 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.