#!/usr/bin/bash MYUSER=root MYPASS=nht@123 socket=/tmp/mysql.sock MYCMD="mysql -u$MYUSER -p$MYPASS -S $socket" MYDUMP="mysqldump -u$MYUSER -p$MYPASS -S $socket" for database in $MYCMD -e "show databases;"|sed '1,2d' |egrep -v "mysql|schema|sys" do mkdir /server/backup/${database} -p for table in $MYCMD -e "show tables from $database;"|sed '1d' do $MYDUMP $database $table|gzip>/server/backup/${database}/${table}_$(date +%F).sql.gz done done