Issue :
After downloading a database backup through cPanel (Download a MySQL database back-up) , the tar file generated is empty!
Solution :
This usually happens when you are logged in to cPanel with the root/reseller password. Log in with the user password and then try to take a back-up. That should work.