Announcement

Collapse
No announcement yet.

Cron to run backups

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • steven s
    replied
    I've been using
    http://sourceforge.net/projects/automysqlbackup/

    Leave a comment:


  • Zachery
    replied
    What do you mean it doesn't work? Is there some error message?

    Leave a comment:


  • matt4
    replied
    Any idea why none of them work for me?

    Leave a comment:


  • matt4
    replied
    Thanks, Does this still send a email out?

    Leave a comment:


  • Jobe1986
    replied
    Originally posted by matt4 View Post
    I just replaced the place where my values should be with mine.

    I get this when the cron tries to run...


    What can I do?

    Thanks,
    For my DB backups I use:
    Code:
    mysqldump --opt -Q -e --hex-blob --skip-comments -u USER --password=PASSWORD DATABASE > mysql-backup.sql

    Leave a comment:


  • matt4
    replied
    I just replaced the place where my values should be with mine.

    I get this when the cron tries to run...
    mysqldump: unknown option '-U'
    What can I do?

    Thanks,

    Leave a comment:


  • Hiiragi
    replied
    Code:
    mysqldump --opt -U DBUSER -p DBPASSWORD DBNAME > /path/to/backup.sql
    should be

    Code:
    mysqldump --opt -U DBUSER -pDBPASSWORD DBNAME > /path/to/backup.sql
    right? You can't have the space between -p and the password

    Leave a comment:


  • Steve Machol
    replied
    That should work with the proper values. What did you do exactly and what is not working?

    Leave a comment:


  • matt4
    started a topic Cron to run backups

    Cron to run backups

    Hi,

    Can someone post a working cron job I can use to backup my database nightly.

    I have this but it doesn't work.

    Code:
    mysqldump --opt -U DBUSER -p DBPASSWORD DBNAME > /path/to/backup.sql
    Thanks,
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X