diff options
author | Florian Pritz <bluewind@xinu.at> | 2016-07-09 17:02:06 +0200 |
---|---|---|
committer | Florian Pritz <bluewind@xinu.at> | 2016-07-09 17:02:06 +0200 |
commit | d27b37c68725bf9a11a027e801d539cd471ffacd (patch) | |
tree | de2f0f3aa56d237f18691340700c8f349b1e0b09 /create-mysql-dumps | |
parent | ed6f1dd19591383de299d0d97ef60829db955d28 (diff) | |
download | bin-d27b37c68725bf9a11a027e801d539cd471ffacd.tar.gz bin-d27b37c68725bf9a11a027e801d539cd471ffacd.tar.xz |
Add DB dumper scripts
Signed-off-by: Florian Pritz <bluewind@xinu.at>
Diffstat (limited to 'create-mysql-dumps')
-rwxr-xr-x | create-mysql-dumps | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/create-mysql-dumps b/create-mysql-dumps new file mode 100755 index 0000000..2bec29c --- /dev/null +++ b/create-mysql-dumps @@ -0,0 +1,10 @@ +#!/bin/bash + +mysql_opts="--defaults-file=/root/backup/mysql-defaults-backup" +backupdir="/root/backup/mysql-dumps/" + +for db in $(mysql $mysql_opts -e 'show databases' -s --skip-column-names); do + if [[ $db != "information_schema" && $db != "performance_schema" ]]; then + mysqldump $mysql_opts "$db" --quick --create-options --disable-keys --add-locks --add-drop-table --lock-tables --complete-insert --skip-extended-insert | gzip > "$backupdir/$db.sql.gz" + fi +done |