If you login to cpanel, download a mysql backup and the backup is empty, try this:
Go to your home directory. You can use cpanel’s File Manager. Or you can access your home directory through ftp. Find a file called my.cnf. Rename it to my.cnf.backup.
What will happen? You probably changed your cpanel password. The new password was not updated in my.cnf. By deleting this file, the next time you login to cpanel, it will have to recreate it with your new password. And that will solve your mysql backup problem.
The mysql backup process uses that file to access the mysql databases. If the password is incorrect, the cpanel process will be denied access to those databases. You will not see any error, because it’s not logged in your cpanel interface. But you will get an empty database backup instead.
Thank you so much, this was driving me insane after my backup script produced 10 days worth of empty backups for no apparent reason. Thanks again!
This post is great, helped me a lot, thanks!!!
cJH79L Touchdown! That’s a really cool way of putting it!
Excellent blog right here! Also your website rather a lot up very fast! What host are you the use of? Can I am getting your affiliate hyperlink for your host? I desire my website loaded up as quickly as yours lol