Skip to content

Instantly share code, notes, and snippets.

@yesmeck

yesmeck/mysql_backup.sh

Created October 27, 2011 05:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yesmeck/1318833 to your computer and use it in GitHub Desktop.
Save yesmeck/1318833 to your computer and use it in GitHub Desktop.
Download ZIP
mysql backup
Raw
mysql_backup.sh
#!/bin/bash
max_file_count=15
file_count=$(ls mysql-* | wc -l)
if [ $file_count -gt $max_file_count ]
then
rm mysql-*
fi
current_dir=$(dirname $0)
now=$(date +%Y-%m-%d)
db_user="root"
db_password="asdf"
mysqldump --user=$db_user --password=$db_password --all-databases > $current_dir/mysql-$now.sql
exit 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment