Skip to content

Instantly share code, notes, and snippets.

@infoslack

infoslack/bkp-mysql.sh

Created June 29, 2012 21:00
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save infoslack/3020610 to your computer and use it in GitHub Desktop.
Save infoslack/3020610 to your computer and use it in GitHub Desktop.
Download ZIP
Backup Mysql Shell Script
Raw
bkp-mysql.sh
#!/bin/bash
DATA=`date +%Y%m%d-%H%M`
DUMP=/usr/bin/mysqldump
MYSQLDIR='cd /tmp/bkp'
TAR=/bin/tar
$DUMP -uroot -p123 --all-databases > /tmp/bkp/mysql.bkp_$DATA
$MYSQLDIR
$TAR czvf mysql.bkp_$DATA.tar.gz mysql.bkp_$DATA
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment