Automated MySQL backup issue

techpro

Member
Oct 22, 2006
12
0
151
Cumbria, UK
I have a number of sites on a shared server that I need to back up locally, so to avoid the need to log in to cPanel and back up manually, I wrote a program, Site Backup CP, that issues the backup commands with authentication automatically, so you can just click one button to backup whatever you want, or run the job from a scheduler. I thought that others would find it useful, so I released it as a shareware product.

I have received a couple of reports from people who have tried the program who have said that the MySQL backups are incomplete, or not downloaded at all. The other backups are fine. I have determined, as far as I can, that they have entered the database name correctly, and that the MySQL backup works when done manually from cPanel.

As some of you may know, a backup is initiated simply by issuing an HTTP GET for a URL like: http://domain:2082/getsqlbackup/database.gz with authentication . There is not much scope for getting it wrong. I don't need to lnow anything about the database itself as I don't talk to MySQL directly. cPanel handles all of that.

Has anyone any suggestions as to why backups may fail when run from a program instead of a web browser? Since this only affects some people, is there some cPanel configuration option that could cause this problem?
 

ramprage

Well-Known Member
Jul 21, 2002
655
0
166
Canada
Note sure if its part of it or not but the browser might create a session with the server that cPanel also uses to verify its a real user online. I know curl supports sessions.

Just a thought, I'm not sure.
 

techpro

Member
Oct 22, 2006
12
0
151
Cumbria, UK
If that's the case, I don't know how to solve it.

It isn't possible to download a MySQL backup using wget either. It returns a 404 error. Wget seems to be a widely recommended way to automate the downloading of backups, so why doesn't it work?
 

sardelich

Well-Known Member
Apr 28, 2010
72
1
58
Well, your software worked for some time and then it just stopped backing up SQL correctly. Since I paid for this software and it is no longer being supported any help would be great.I have dedicated server and on some accounts it works and on others it doesnt. Doing SQL backup from cPanel works. Go figure.