Script UpdatedThis cPanel MySQL Backup script has been completely rewritten and updated with FTP support.
We have just released a script to the Host Like Toast Developer Channel that lets you do a full backup of all MySQL databases in a cPanel Web Hosting account.
Continuing the tradition of offering tools to help people with their web hosting, we’re releasing this tool free to all members of the Developer Channel.
To get access to this script and all other free tools, simply join for free and download.
What does the cPanel Database Backup Script do exactly?
This is version 1.0 of the publicly released full MySQL database backup script for cPanel, and so it has some limitations. Since it is licensed under GPL, you are free to add and modify it as desired, but you must honour the license.
The cPanel MySQL Database Backup Script operates as follows:
- After you edit the script (in a text editor of your choice) with your personal web hosting credentials you must upload the script to your FTP directory.
- You then run the script from your web hosting, or set it to run under a cron job.
- The script will connect to the webhosting account you have configured and perform a complete dump of all databases in the account.
- The script will save those database backup files in the directory from which the script is run.
What the cPanel Database Backup Script does NOT do
In the current release, v1.0, the script does not perform any remote/off-site FTP/file-copy operations.
The script will simply store the MySQL database backup files in the same folder from which it is run. If you want to take them offsite, you must log into your FTP (or otherwise) and download the files.
The functionality to FTP the backup files may or may not be made available in a future release.
How to perform a full backup of a cPanel web hosting account
If you would like to not only backup databases, but files also, you will likely be interested in our Full cPanel backup script that was released several weeks ago.
This script is also free and we have provided a video to see how it is installed using cron. We think it is a good idea to review the video below if you want to learn how to run this script as they are similar in nature.
You may go to the Developer Channel download section using the button below, or signup if you haven’t already.
Also, check out the video below to see how to setup the cron job (note that this video is for another script, but you can follow along in principle)