Databases showing 0 MB size in cPanel
If your databases in cPanel are not showing its actual size, but it contains tables and content, you can enable “Include databases in disk usage calculations” option from WHM or update cPanel configuration to include MySQL databases disk usage to resolve this issue.
From WHM :-
- Login to WHM
- Click on Tweak Settings under Server Configuration
- Select “On” to Include databases in disk usage calculations under SQL tab
- Click on save to reflect the changes
From command line :-
- Run the command.
/usr/local/cpanel/bin/setupdbmap
- Edit cPanel configuration file.
vi /var/cpanel/cpanel.config
and set the value of disk_usage_include_sqldbs to 1
disk_usage_include_sqldbs=1
- Run the following script.
/scripts/update_db_cache
That’s it 🙂