After transfer SQL not showing as disk space used in account

Operating System & Version
centos 7
cPanel & WHM Version
11.104.0

maestroc

Well-Known Member
Aug 23, 2012
86
2
58
cPanel Access Level
Reseller Owner
I am transferring some accounts from one server to another using the transfer tool. Both servers are using the same cpanel version.

The old account on old server says it has 2500mb in it.
The new server says it only has 2300mb in it.

When I try to compare things by looking at the Disk Usage tools I see that everything is the same except on the new server the MySQL usage is zero where on the old server SQL usage is around 200mb. However, if I go into PHPMyAdmin on both servers and compare both appear to have identical databases, tables, and relative sizes.

For some reason after the transfer the new server is not counting SQL usage against the user's account quota. Did I miss something when doing the transfer?
 

kodeslogic

Well-Known Member
PartnerNOC
Apr 26, 2020
516
242
118
IN
cPanel Access Level
Root Administrator
Please check disk_usage_include_sqldbs in the file /var/cpanel/cpanel.config, if it is set to 0 then change it to 1 and execute the following command with root login from commandline:

Code:
# grep "disk_usage_include_sqldbs" /var/cpanel/cpanel.config
Expected Output:
disk_usage_include_sqldbs=1

Code:
# /scripts/update_db_cache
 

maestroc

Well-Known Member
Aug 23, 2012
86
2
58
cPanel Access Level
Reseller Owner
It appears the disk usage config was already set to 1 so I did not need to change it.

I ran the script though and now the accounts show the correct disk usage. Thank you. Will I need to run that script every time I transfer an account or should it do it on its own now that I ran it once?
 

cPanelWilliam

Administrator
Staff member
Mar 13, 2018
119
20
93
Houston
cPanel Access Level
Root Administrator
Hey there,

I ran the script though and now the accounts show the correct disk usage. Thank you. Will I need to run that script every time I transfer an account or should it do it on its own now that I ran it once?
The update_db_cache script should run as a cron job under the root user every 4 hours, so it shouldn't be necessary to manually run this script each time you transfer a new account.