Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- # MySQL Console Dumper
- # author: Nico Hemkes <www.nokes.de>
- # date: 26.09.2016
- # settings
- user="USER"
- pw="PASSWORD"
- backupDir="/media/backup/"
- today=$(date +"%m-%d-%Y")
- filename="mysql_dump-$today.sql.gz"
- # output start
- printf "\n= = = MySQL Console Dumper = = ="
- printf "\nstarting ...\n\n"
- # dump
- mysqldump -u"$user" -p"$pw" -Q --events --ignore-table=mysql.event --all-databases | gzip -9 > $backupDir$filename
- # output end
- printf "Backup placed at $backupDir$filename\n\n"
- printf "done!\n"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement