# HG changeset patch # User Heiko Schlittermann (JUMPER) # Date 1390484630 -3600 # Node ID 0d0715b661f7ea92455fcf1c093f6dc41d16e273 # Parent bbacf6d77c19924352f86453a3addbe210847299 exclude the performance_schema diff -r bbacf6d77c19 -r 0d0715b661f7 mydump --- 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 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