cPanel: Database size is Zero

Wonder why cPanel database size is not calculated and it is always showing zero (0) in the database section?

You may fix this by 2 options,
Option 1:
1. Log into WHM(Web Host Manager).
2. Go to Server Configuration and look for Tweak Settings.
3. Look for “Include databases in disk usage calculations” and enable it.
4. Save it.

Option 2:
1. Log into SSH.
2. Open the file named /var/cpanel/cpanel.config.
vi /var/cpanel/cpanel.config
3. Search “disk_usage_include_sqldbs” and change the value to 1.
4. Lastly, run the command as below,
/scripts/update_db_cache

How to Import/Export a scheduled task

It is very important when you want to move your server from one web host to another one and you wish to move your scheduled task hosted from Windows Server.

In this case, I will take Windows Server 2008 as an example:

Export Scheduled Task,
1. Open Task Scheduler or run taskschd.exe.
2. Select the Task that you wish to export and hit on the Export link from the right bar.
3. Save the xml file.

Import Scheduled Task,
1. Open Task Scheduler or run taskschd.exe.
2. Click the Import link from the right bar and you will now see the Task created.