After transfer SQL not showing as disk space used in account

[maestroc]

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]

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:

# grep "disk_usage_include_sqldbs" /var/cpanel/cpanel.config

Expected Output:
disk_usage_include_sqldbs=1

# /scripts/update_db_cache

 

[maestroc]

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]

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.