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.

using mysqldump in a cronjob options in the user panel

Discussion in 'General Discussion' started by sandoz, Mar 13, 2011.

  1. sandoz

    sandoz Registered

    Joined:
    Mar 13, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    i would like to automate the backup of a large forum with the cron job options from the cpanel advanced options with something like this:
    0 0 * * * /usr/bin/mysqldump --opt dbname -u dbuser -ppass > /home/username/dbname.sql

    will that work from within the user panel?
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    It would be better to do this in root crontab without using the password and running it as -u root without the -p flag. The root user can run such a cron without being required to enter the password. I'm not certain that it is a good idea to pass the password via a cron.

    To add a cron in root crontab, you can either use "crontab -e" command or directly edit /var/spool/cron/root file in root SSH.
     
Loading...

Share This Page