After transfer SQL not showing as disk space used in account

maestroc

• June 24, 2022 19:21

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

  • June 25, 2022 13:10

  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
  

  0
• 

  maestroc

  • June 27, 2022 03:06

  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?

  0
• 

  cPanelWilliam

  • June 28, 2022 13:01

  Hey there, [QUOTE]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.

  0

Please sign in to leave a comment.