Skip to content

Instantly share code, notes, and snippets.

@n1mh

n1mh/mysql_backup.sh

Last active February 28, 2018 22:15
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 n1mh/ed4773298cd79d33e14d33218b35d1e5 to your computer and use it in GitHub Desktop.
Save n1mh/ed4773298cd79d33e14d33218b35d1e5 to your computer and use it in GitHub Desktop.
Download ZIP
mysql/mariadb complete backup
Raw
mysql_backup.sh
#!/bin/bash
OUT="`date +%Y%m%d%H%M%S`-backup-`hostname -f`.sql"
mysqldump -u root -p \
--all-databases \
--routines \
--events \
--triggers \
--single-transaction \
--result-file=$OUT
bzip2 $OUT
echo "complete backup has been generated in $OUT.bz2 file"
exit 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment