Database size shows 0.00 MB

AndyX

• November 20, 2017 14:44

While viewing the MySQL databases page in cPanel, a newly copied database is showing 0.00 MB in size. I know the copy was successful as I can see all the tables and content. Is there a trick to make the database size show correctly?

• 

  cPanelMichael

  • November 20, 2017 19:51

  Hello, Try running the following command manually to update the disk space usage of the database:
  /usr/local/cpanel/scripts/update_db_cache
  It runs as part of the following root cron job:
  30 */4 * * * /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache
  Thank you.

  0
• 

  AndyX

  • November 20, 2017 19:57

  Thank you, Michael. So if I understand correctly it would be automatically updated when the cron job runs, what time does the cron job run? I see this: 30 */4 * * * off hand I don't know what times these are.

  0
• 

  cPanelMichael

  • November 20, 2017 20:00

  So if I understand correctly it would be automatically updated when the cron job runs, what time does the cron job run?

  
  Yes, that's correct. The cron job is configured to run at thirty minutes past the hour, every four hours. Thank you.

  0

Please sign in to leave a comment.