[slmclarengt]

Hey everyone, I have a question regarding the use of Cron Jobs and backing up SQL databases.

I have a database we will name "slm_db1" that I use for vital website/server information. However, I need to backup said database more than I do (recently my webhost deleted my user account associations leaving me deleting databases when I accidentally deleted a system critical database out of frustration and blind rage). I have access to CPanel which provides just basic "Backups" but it cannot be scheduled to backup say once a week but only every time I press the button to back it up. I'd like to know how I could go about retrieving a backup automatically whether having it saved to my webserver or sent via e-mail to me via Cron Jobs or any other method/script you can think of that is secure enough.

Slmclarengt

[YamiKaitou]

Input your cPanel details and the FTP info of where to upload the back up to and your email address (Email notify doesn't always work for me). Just edit the file, upload it to your site, and cron it and it will do a backup for you.

[slmclarengt]

Originally Posted by YamiKaitou Input your cPanel details and the FTP info of where to upload the back up to and your email address (Email notify doesn't always work for me). Just edit the file, upload it to your site, and cron it and it will do a backup for you.

This is a great help, however this from the looks of it is meant to perform a full backup of my site when I don't know if a full backup is completely necessary seeing that I am providing over 30 members of these forums with space (many of which have same/similar files), it would waste space. I also read through the script and if I understand correctly:

fputs($socket,"POST /frontend/".$skin."/backup/dofullbackup.html?".$params." HTTP/1.0\r\n");

this would attempt to go into http://mydomain:2082/frontend/backup/dofullbackup.html and grab the information when really that does not exist on my CPanel (Cpanel X if that makes a difference). Plus, I was wondering if I could configure that to say be configured to "http://mydomain.com:2082/getsqlbackup/slm_01.tar.gz" so that it only backs up my database on a regular basis? I also want to backup other stuff, but frankly, I don't want to backup all the users I give free space to (not because I'm mean, but because I would much rather not waste that space when it's already on the internet plenty).

Slmclarengt

[YamiKaitou]

Yes, the script is for a full backup. The part that you quoted puts data on that page using post. You can change up the script to fit your needs with the SQL backup, I am just not sure what params each page requires. I just gave you a base script that I had found someplace.