Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    51
    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:
    23
    Likes Received:
    0
    Trophy Points:
    51
    Check the cron log to make sure that cron is executing your command and it is not giving any error.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. kbeck@tnlog

    kbeck@tnlog Registered

    Joined:
    Jan 1, 2009
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    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:
    51
    Hi,

    In cpanel servers the cron logs are located in "/var/log/cron" .
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    850
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    Where are user account crons located? I have seen them before but seem to be missing them.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Networkologist

    Networkologist Well-Known Member

    Joined:
    Feb 5, 2003
    Messages:
    209
    Likes Received:
    0
    Trophy Points:
    166
    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:
    850
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    /var/spool/cron/
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. Networkologist

    Networkologist Well-Known Member

    Joined:
    Feb 5, 2003
    Messages:
    209
    Likes Received:
    0
    Trophy Points:
    166
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice