Skip to content

Instantly share code, notes, and snippets.

@taylor224

taylor224/README.md

Last active July 5, 2018 12:32
Show Gist options
  • Save taylor224/3df161dd007af9a223fa6eaf2c4f3bdb to your computer and use it in GitHub Desktop.
Save taylor224/3df161dd007af9a223fa6eaf2c4f3bdb to your computer and use it in GitHub Desktop.
Download ZIP
MariaDB Auto Backup Script
Raw
README.md

MariaDB Auto Backup Script

without DB lock

Raw
backup.sh
#!/bin/bash
NOW="$(date +%Y%m%d%H%M%S)"
FILENAME="${NOW}"
echo "[INFO] Backup Started"
echo "[INFO] Filename : dbname_${FILENAME}.db"
BACKUPCOMMAND="mysqldump -u root -p --quick --single-transaction --lock-tables=false dbname > dbname_${FILENAME}.db"
eval $BACKUPCOMMAND
echo "[INFO] Backup Finish!"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment