Sometimes when viewing databases in cPanel, you might notice that the database size appears as zero, even though the database contains tables and data. This can be confusing, but it’s usually just a display issue caused by a configuration setting. The good news is, it’s easy to fix. In this article, we’ll walk you through the steps to correct the configuration and update the database size display in cPanel.
Enter WHM - If you don't know how, you can follow this guide.
Access the server via root using ssh.
Access the below file and edit the line as below
vi /var/cpanel/cpanel.config
Find the line disk_usage_include_sqldbs line and change it to 1 if its zero.
Now run below script to refresh and rebuild the database size cache.
/scripts/update_db_cache
Congratulations! You’ve successfully fixed the issue of the database size showing as zero in cPanel.
If you have any questions, please don’t hesitate to contact our team via live chat.
For technical inquiries, please feel free to reach our support team by emailing support@bigscoots.com from your registered email or by submitting a support ticket.