How to resolve when MySQL DB size showing zero Mb in cPanel on CentOS Linux Server ?

How to resolve when MySQL DB size showing zero Mb in cPanel on CentOS Linux Server ?

If you are getting 0 MB size for MySQL database in your cPanel account. Then you can resolve it through below given steps.

1). Login to SSH as root.

2). Open cpanel.config file through vi editor

# vi /var/cpanel/cpanel.config
3). Now, look for

disk_usage_include_sqldbs=0
4). You have to change the value to 1 from 0

disk_usage_include_sqldbs=1
5). If this parameter is not present in the file then you have to add it.

6). Save the file and execute the following command:

# /scripts/update_db_cache
It may take some time to get it fixed depending on number of users with databases. Once it is done then you will be able to see database disk usage show up accurately in cPanel.
Author
bhawanisingh
Views
3,608
First release
Last update
Rating
0.00 star(s) 0 ratings
Top