OMG! My databases got zero size 🙁 The databases in cPanel aren’t showing its actual size, but it contains tables and contents. There is an option in cPanel configuration to include MySQL databases disk usage. We can simply enable this from WHM or from the shell. The steps mentioned below will help you to figure it out.
From command line
1. Run the command.
2. Edit cPanel configuration file.
disk_usage_include_sqldbs=1 ( you need to set it to '1' if '0' ) in file /var/cpanel/cpanel.config
3. Run the following script.
You can also enable this from the WHM control panel.
WHM >> Server Configuration >> Tweak Settings>>SQL>> Include databases in disk usage calculations