The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Automated MySQL backup issue

Discussion in 'General Discussion' started by techpro, Dec 8, 2006.

  1. techpro

    techpro Member

    Joined:
    Oct 22, 2006
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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?
     
  2. ramprage

    ramprage Well-Known Member

    Joined:
    Jul 21, 2002
    Messages:
    667
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    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.
     
  3. techpro

    techpro Member

    Joined:
    Oct 22, 2006
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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?
     
  4. sardelich

    sardelich Well-Known Member

    Joined:
    Apr 28, 2010
    Messages:
    72
    Likes Received:
    1
    Trophy Points:
    8
    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.
     
Loading...

Share This Page