shell学习笔记（6）
# cat mysql_bak02.sh #!/bin/bashmyuser="root"
mypass="oldboy123"
mycmd="mysql -u$myuser -p$mypass"
mydump="mysqldump -u$myuser -p$mypass"
for database in `$mycmd -e "SHOW DATABASES;" | sed '1d' | grep -Ev "mysql|information_schema"`
do
[ ! -d "/backup/${database}" ] && mkdir -p /backup/${database}
for table in `$mycmd -e "SHOW TABLES from $database;" | sed '1d'`
do
$mydump $database $table | gzip > /backup/${database}/${database}_${table}_$(date +%F).sql.gz
done
done
# tree /backup/
/backup/
├── hellodb
│ ├── hellodb_classes_2018-03-05.sql.gz
│ ├── hellodb_coc_2018-03-05.sql.gz
│ ├── hellodb_courses_2018-03-05.sql.gz
│ ├── hellodb_scores_2018-03-05.sql.gz
│ ├── hellodb_students_2018-03-05.sql.gz
│ ├── hellodb_teachers_2018-03-05.sql.gz
│ └── hellodb_toc_2018-03-05.sql.gz
├── oldboy
│ ├── oldboy_kecheng_2018-03-05.sql.gz
│ └── oldboy_student_2018-03-05.sql.gz
├── test
└── zabbix
├── zabbix_agent_2018-03-05.sql.gz
└── zabbix_server_2018-03-05.sql.gz
页:
[1]