When we login to any clients cpanel , it is not showing actual database size , instead it is showing zero. With phpmyadmin we can see correct size but as you login to capnel >> click on database >> and see the size , it will show O mb db size.
sol-
Edit line
disk_usage_include_sqldbs=1 ( you need to set it to '1' if '0' )
in /var/cpanel/cpanel.config
OR
If you are using 11.25 stable, check the following option in Tweak Settings:
"When displaying disk usage in cPanel/WHM include Postgresql and MySQL® disk usage. [Requires MySQL® 5+] (SQL disk usage is only updated every four hours)"
The mysql usage will be updated shortly.
then run:
#/scripts/update_db_cache
