mysql_backup_simple
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
mysql_backup_simple [2014/11/18 05:26] kyxap update |
mysql_backup_simple [2015/04/04 10:39] (current) kyxap |
||
|---|---|---|---|
| Line 44: | Line 44: | ||
| # validate $DB and skip default dbs | # validate $DB and skip default dbs | ||
| - | [[ $DB == all ]] && DB=$(mysql -e 'show databases' | tail -n +2 | grep -v -E "information_schema|performance_schema") | + | [[ $DB == all ]] && DB=$(mysql -e 'show databases' | tail -n +2 | grep -v -E "^(information_schema|performance_schema)$") |
| # create dumps | # create dumps | ||
| Line 82: | Line 82: | ||
| # rm | # rm | ||
| - | [[ -d $dir ]] && rm -r "$dir" || print_error "Can't remove $dir: dir not exists" | + | [[ -d $dir ]] && rm -r "$dir" || print_error "Can't remove $dir" |
| done | done | ||
| fi | fi | ||
| </code> | </code> | ||
mysql_backup_simple.1416288399.txt.gz · Last modified: 2014/11/18 05:26 by kyxap
