Skip to content

Instantly share code, notes, and snippets.

@ozgun
Created October 11, 2012 12:44
Show Gist options
  • Select an option

  • Save ozgun/3872050 to your computer and use it in GitHub Desktop.

Select an option

Save ozgun/3872050 to your computer and use it in GitHub Desktop.
mysqldump.sh
#!/bin/bash
DATETIME=`date +%Y.%m.%d_%H.%M.%S`
DB_NAME="test"
BACKUP_FILE="/home/ozgun/backups/${DB_NAME}-${DATETIME}.sql"
/usr/bin/mysqldump -uroot --default-character-set=utf8 $DB_NAME > $BACKUP_FILE
/bin/gzip $BACKUP_FILE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment