MySQL Sub-table backup

#!/bin/sh

Myuser=root

Mypass=123123

Mysock=/tmp/mysql.sock

Backup_path=/test

dblist= "' Mysql-u$myuser-p$mypass-e" show databases; "|grep-ev ' Database|mysql|schema '"

dump= "Mysqldump-u$myuser-p$mypass-f-r-x"

Mkdir-p $backup _path

For DB in $DBLIST

Do

echo "DB:" $db

Tblist= "$ (mysql-u$myuser-p$mypass-e" show tables from $db; "|sed 1d)"

For TB in $TBLIST

Do

$DUMP $db $TB |gzip >${backup_path}/mysqltest_${db}_${tb}_$ (date +%f). sql.gz

echo "Table:" $TB

Done

Done

This article from "Magic Conch" blog, declined reproduced!

MySQL Sub-table backup