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.

MySQL backup cron job not working

Discussion in 'General Discussion' started by mrnabo, Apr 18, 2010.

  1. mrnabo

    mrnabo Registered

    Joined:
    Mar 3, 2010
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    Not sure if this is the correct forum for this, so apologies if not.

    I'm trying to get my Cron job working in cPanel and everything is working ok except I need to email the database to my client:

    Code:
    mysqldump -u USERNAME -pPASSWORD DATABASENAME | gzip > /home/USERNAME/bkups/mysql-$(date +\%Y-\%m-\%d-\%H.\%M.\%S).gz
    Does anyone know how I can modify the code above to instruct cron to email te database?

    Thanks
     
  2. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    Why does your client need the database sent by email?

    That does seem a bit peculiar and if their intention is simply keeping
    backups, there is much better ways of doing all of that.
     
Loading...

Share This Page