Databases showing 0MB in cPanel

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.

# /usr/local/cpanel/bin/setupdbmap

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.

#/scripts/update_db_cache

You can also enable this from the WHM control panel.

WHM >> Server Configuration >> Tweak Settings>>SQL>> Include databases in disk usage calculations

That’s it!!

Related

1, How to change default time zone in MySQL?
2, How to know the MySQL uptime from commandline – 3 Methods
3, How to enable remote MySQL for an IP address on a cPanel server via CSF

Post navigation

Arunlal Ashok

Linux Systems Architect at Endurance International Group. I know her (Linux) since many years. Linux lover. Like to play on Linux console. I started this blog to share and discuss Linux thoughts.

Always happy for an open discussion! Write to arun (@) crybit (dot) com. Check about me for more details. About this blog and our strong members, check The team CryBit.com

2 thoughts on “Databases showing 0MB in cPanel

Leave a Reply

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