Difference between revisions of "Database Status"
(Created page with "You can monitor the status of your WHMCS installation's database, optimize the tables, and download backups manually at '''Utilities > System > Database Status'''. ==Optimise...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | You can monitor the status of your WHMCS installation's database, optimize the tables, and download backups manually at '''Utilities > System > Database Status'''. | + | You can monitor the status of your WHMCS installation's database, optimize the tables, and download backups manually. |
| + | |||
| + | You can access this feature at '''Utilities > System > Database Status'''. | ||
==Optimise Tables== | ==Optimise Tables== | ||
Latest revision as of 22:42, 14 April 2022
You can monitor the status of your WHMCS installation's database, optimize the tables, and download backups manually.
You can access this feature at Utilities > System > Database Status.
Optimise Tables
In normal operation, MySQL® tables can generate overhead. This is disk space that you have assigned to the table but aren't using. You can use MySQL's optimize tables function to reduce this.
To run this function, click Optimise Tables. The function may require several seconds to run, and then a success message will display.
You can also run this command from the server's command line or phpMyAdmin.
Manual Database Backup
It is important to create frequent backups of your database in case of any problems. If you do not regularly back up your data, you risk losing some or all of your customer data and WHMCS configuration.
To manually download a backup of the WHMCS database, click Download Database Backup. Your browser may prompt you to download a file or it may download automatically, depending on your browser's settings.
Make certain that you save the file to your computer in a known location. Depending on the database size, this may take a few moments.