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.

Cron Job Help ( mysqlhotcopy )

Discussion in 'General Discussion' started by kbeck@tnlog, Feb 26, 2009.

  1. kbeck@tnlog

    kbeck@tnlog Registered

    Joined:
    Jan 1, 2009
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    I am tryingto set up a cron job to backup my mysql databases everynight. I know that there is a way to run it so that it will keep the existing backup and create a new one using the allowold tag but I cannot seem to make it work as a cron. I can ssh in and run the command below and get a valid backup but not from cron. What I would like to do is to create a tar file of all of my databases and put them in a folder under public_html so that my customer can ftp or download the backups daily. Any help would be appreciated.

    /usr/bin/mysqlhotcopy -u xxxx_jutano -p xxxx -allowold xxxx_est /home/xxxx/public_html/backups/mysql

    Kevin
     
  2. JPC-Stefan

    JPC-Stefan Member

    Joined:
    Oct 29, 2008
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Check the cron log to make sure that cron is executing your command and it is not giving any error.
     
  3. kbeck@tnlog

    kbeck@tnlog Registered

    Joined:
    Jan 1, 2009
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    I am not real sure how to find that info Where are the cron job logs kept?
     
  4. hzsanjay

    hzsanjay Member

    Joined:
    Feb 25, 2009
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    In cpanel servers the cron logs are located in "/var/log/cron" .
     
  5. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    Where are user account crons located? I have seen them before but seem to be missing them.
     
  6. Networkologist

    Networkologist Well-Known Member

    Joined:
    Feb 5, 2003
    Messages:
    209
    Likes Received:
    0
    Trophy Points:
    16
    I'd like to know this also. I'm having a problem with the WHMCS cron job not running.
     
  7. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    /var/spool/cron/
     
  8. Networkologist

    Networkologist Well-Known Member

    Joined:
    Feb 5, 2003
    Messages:
    209
    Likes Received:
    0
    Trophy Points:
    16
    Thanks Solokron

    Evrything seems to be as it should but a WHMCS cron job just won't run; the only other one I have does ...
     
Loading...

Share This Page