Mysql Database size showing '0' in cPanel

In cPanel >> mysql databases , it shows database size as 0 even if it is not.

Make the following changes to fix.

nano var/cpanel/cpanel.config 

and search for following line.

disk_usage_include_sqldbs=0 ( set it to 1 instead of 0 )

then run following command

/scripts/update_db_cache

You are done.

Recipient receiving same emails many times

It happens that when you send email, the recipient receive the same email many times in period of intervals. It is because of exim database corrupted and also you receive following error in exim_mainlog.

Berkeley DB error: /var/spool/exim/db/retry: unexpected file type or format

Apply following solution to fix this issue.

Stop exim service using following command

/etc/init.d/exim stop
or
service exim stop

then go to /var/spool/exim/db/ and remove all the files. Make sure to take the backup of /db folder if in case if there is another problem arise. 

Start Exim service.

/etc/init.d/exim start
or
service exim start

After starting exim service, It will rebuild exim database. 

How to enable .zip file import in PHPMyAdmin

If you have cPanel server and you are not able to import .zip file in PHPMyAdmin then make following changes and you will be able to do it.

Nano /var/cpanel/easy/apache/profile/makecpphp.profile.yaml

Search for following line

Cpanel::Easy::PHP5::Zip: 0=0

Change it to

Cpanel::Easy::PHP5::Zip: 1

Save the file

and run /scripts/makecpphp