Mysql DB Dump without DB locking

by Taylor
0 comment

This is how to db dump without db locking.
This script makes you can dump db without have influence to live service.

MariaDB Auto Backup Script

without DB lock

view raw README.md hosted with ❤ by GitHub
#!/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!"
view raw backup.sh hosted with ❤ by GitHub

You may also like

Leave a Comment