Does the database at your cPanel show 0mb? There seems to be a fix to this, an option that has been an opener to fixate problems that includes the method to configure the cPanel which has MySQL disk usage database. Enabling this from WHM or from the shell seems to be a cakewalk.

1. Run the command as mentioned below first as the beginning

Code:
# /usr/local/cpanel/bin/setupdbmap
2. Edit cPanel configuration file to get the next initiated

Code:
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 as mentioned below to help it fix this.

Code:
#/scripts/update_db_cache
Sometimes, when you log into cPanel, you’ll encounter some non-empty MySQL databases that keeps popping up 0mb as its size. Those databases usually displays the table and data stacks are default with 0 as the number so one has to be extra careful while trying to determine the size of the SQL file.

Command line issue fixing that seems to be a tad problem:

1) The first step would be to Log on SSH server easily.

2) You have reset the numbers or value from the configured cPanel from the starting such as 0 to 1 disk_usage_include_ in and initate that step in order to accelerate the process

Code:
# vi /var/cpanel/cpanel.config
disk_usage_include_sqldbs=1
3) Execute the database cache which gives the detailed script and that would be a final step in resolving this issue

Code:
# /scripts/update_db_cach
Steps to fix the database size issue from WHM

1) Login to WHM as an initial step.

2) Navigate to ‘Tweak Settings’ under ‘Server Configuration’.

3) Go the section of “SQL” and exactly you will encounter the calculation of disk usage in databases which has been included. You have to just turn on the section.

4) Now, tap the save and make sure the changes. Wait for the next proceedings

Sometimes we may encounter that the mysql database size as zero in cPanel. This can be fixed as follows by following these simple steps SSH to the root as the server and you can make changes in cpanel.config file

Code:
vi /var/cpanel/cpanel.config
Search for

Code:
disk_usage_include_sqldbs=0
And then make change to

Code:
disk_usage_include_sqldbs=1
If the parameter is absent, kindly add it to the last running method.

Code:
/scripts/update_db_cache
This may take few minutes to get fixed if you have a large number of users with databases trying over the same data, but once done it should be able to make us able see the database disk usage show up accurately in cPanel.

There are a few more steps that seemed to solve the issues

1)
Code:
Edit/var/cpanel/cpanel.config
Change:

Code:
disk_usage_include_sqldbs=0
to
disk_usage_include_sqldbs=1
Execute the script as mentioned:
Code:
/scripts/update_db_cache
The process may carry out for few minutes. If more users are in the performance thenthey will seek the same problem along with the database issue. You have to check the disk usage in database at cPanel.

When you create a database, many users are unaware that there are several other items that you need to do as well to form a proper database. The new database creation process actually involves:
  • Creating a database firstly
  • Secondly Creating a database user
  • Giving your database user access to work with your database
So by following these steps one can properly make sure that the cPanel has 0MB to prevent showing up

Hope the above steps and options were useful!
Author
Bhawani Singh
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from Bhawani Singh

Top