Skip to content

Instantly share code, notes, and snippets.

@meineerde

meineerde/mysql_backup.sh

Created January 31, 2011 21:24
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save meineerde/804845 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save meineerde/804845 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. meineerde created this gist Jan 31, 2011.
    19 changes: 19 additions & 0 deletions mysql_backup.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,19 @@
    #!/bin/bash

    umask 022

    # paranoia settings
    #
    PATH=/sbin:/bin:/usr/sbin:/usr/bin
    export PATH

    TARGET="/backup/database"
    mkdir -p "$TARGET"
    date=$(/bin/date '+%Y-%m-%d')

    ## cleanup first
    find -name '*.tar.gz' -mtime +14 "$TARGET" -delete

    ## Backup Database
    mysqldump --defaults-extra-file="/opt/redmine/config/database_backup.cnf" "redmine" | gzip > $TARGET/redmine_${date}.sql.gz
    done