cPanel sometimes displays the mysql database size as 0MB in the Mysql Databases section of a client and the reason is the database cache file of the user is not updated.
To make sure cPanel displays the correct database size, follow the below steps:
1) SSH to the server and edit the cpanel.config file
# pico /var/cpanel/cpanel.config
search for
disk_usage_include_sqldbs=0
and change to
disk_usage_include_sqldbs=1
If the parameter is not present, add it. Save the file and execute the following command:
# /scripts/update_db_cache
OR
2) Login to the WHM, goto SQL section under Tweak Settings and enable the following option:
When displaying disk usage in cpanel/WHM include Postgresql and MySQL.
This will fix the issue.
Comments are closed.