Databases showing 0 MB size in cPanel

If you found this post helpful, kindly share it and show your support :)

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 🙂

Loading

Mohammed Noufal

I'm Mohammed Noufal, working as Server Admin for the last 10 years.  In my day-to-day life, l had to face different problems related to Web-hosting. On my website Errorlogz.com, you can find solutions for different Web-hosting-related problems. Sometimes, I spent hours searching/googling to find a solution. This inspired me to start a website that gives solutions to different Webhosting problems. This website includes basic Linux and windows commands, and different control panels like cPanel, Plesk, DirectAdmin, Webmin & so on. You can find solutions and or suggestions for different Web-hosting related problems from here. Hence I would like to say Errorlogz is your server protector.  I will be glad if Logdetect can help any one of the Server admins to find a solution to his problem.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *