--- a/mydump Thu Jan 23 13:00:40 2014 +0100
+++ b/mydump Thu Jan 23 14:43:50 2014 +0100
@@ -1,4 +1,5 @@
#! /bin/bash
+# (c) 2014 Heiko Schlittermann <hs@schlittermann.de>
DIR=~backup/mysql
@@ -21,8 +22,8 @@
mysql --skip-column-names --batch -e 'show databases' | while read db
do
# skip lost+found and other
- [[ "$db" =~ '+' ]] && continue
- [[ "$db" =~ 'information_schema' ]] && continue
+ [[ $db =~ '+' ]] && continue
+ [[ $db =~ (performance|information)_schema ]] && continue
# dump the rest
out=$DIR/$db.sql.xz