0 MB for a MYSQL DB in cPanel
Sometimes after migration of a database or after restoring the cpanel shows 0 MB for the database size even the database is not empty.
In order to remove this error you can follow following steps:
1) Login to the server as root
2)Open the file /var/cpanel/cpanel.config
[root@server ~]# vi /var/cpanel/cpanel.config
3) In the file locate the line “disk_usage_include_sqldbs”.
Check if the disk_usage_include_sqldbs=0
Change it to 1 if it is 0.
4)Once done run following command .
[root@server ~]# /scripts/update_db_cache
This command will update the cache stored for the databases.
This should now correct your error.