mysql-backup: exclude builtin databases

[monosys] / backup-mysql

diff --git a/backup-mysql b/backup-mysql
index 2b66f0a8b8c0f1f8b6952e655d46f857d33a10e8..2747ca122db0f478a2754c8420a2c09295186611 100755 (executable)
--- a/backup-mysql
+++ b/backup-mysql
@@ -4,7 +4,7 @@ set -eu
 
 cd ~/backup-mysql/
 
-DATABASES="$(echo 'show databases' | mysql | tail -n+2)"
+DATABASES="$(echo 'show databases' | mysql | grep -vE '^(Database|mysql|information_schema|performance_schema)$')"
 for db in ${DATABASES}; do
     mysqldump --add-drop-table --single-transaction "${db}" | \
         gzip -9 > "${db}-$(date '+%Y%m%d').sql.gz"