Problem Downloading MYSQL Backup From Cpanel? Try This Small Fix!
Are You Missing Out On Our HOT Internet Marketing Secrets?
Subscribe to NuttieZine newsletter and get HOT internet marketing tips! NO junk!
You might have faced a similar issue-once you change your Cpanel™ login details, and try to backup your SQL database from the "Backups" section, you are astounded to find out that the size of the database backup you just downloaded is just 20 bytes or so. If you believe that your database size is larger than that, then maybe the culprit is a file called my.cnf.
If you login to your server using FTP, and then click to go one level above the "public_html" directory, you will find that file there! This file is usually created as soon as you change your Cpanel login details (per my experience, this issue is not common to all Cpanel-based servers; it happens only on a few servers). You just need to logout of Cpanel, delete the "my.cnf" through FTP, then re-login into your Cpanel account and download the SQL backup again!
Did you notice any difference in the database size?
If the above fix does not work for you, my friend Rosie has other tips you may want to try!
Please note that there is NO harm in deleting the "my.cnf" file from your server; however, if you want to, you may take a local backup of that file before deleting it.
Like This Article? Click Here To Buy Me A Cool Beer!
Want to Receive More Tips Like This? Subscribe to NuttieZine newsletter!
Related posts:
- WordPress ERROR-MYSQL Server Gone Away!!! If you ever get this error message-WordPress database error MySQL server has gone away for query..., here is what you...
- WordPress 404 ERROR When Trying to Access Cpanel If you ever get a 404 error message when trying to login to your website's Cpanel, here is what you...
- The Appendix of Cpanel! Cpanel is a software, and not much different in this respect. It offers you several useful tools; at the same...
- Hosting Headache-Part 1 Thieves could easily peek into these folders and steal your files (unless you have password-protected those folders)! I know of...
- 4 More Web Hosting Tips to Save Your Business! Whatever you do, DO NOT rely exclusively on your host for data backups! If you have a Virtual Private Server...