MySQL Database sub-Library backup, sub-table backup

Sub-Library Backup #!/bin/sh DBPATH= /server/backup MYUSER=root MYPASS=oldboy123 SOCKET= /data/3306/mysql .sock MYCMD= "mysql -u$MYUSER -p$MYPASS -S $SOCKET" MYDUMP= "mysqldump -u$MYUSER -p$MYPASS -S $SOCKET" [ ! -d $DBPATH ] &&  mkdir $DBPATH for dbname  in `$MYCMD -e  "show databases;" | sed ‘1,2d‘ | egrep - v "mysql|schema" ` do    $MYDUMP $dbname| gzip >$DBPATH/${dbname}_$( date +%F).sql.gz doneSub-table Backup #!/bin/sh DBPATH= /server/backup MYUSER=root MYPASS=oldboy123 SOCKET= /data/3306/mysql .sock MYCMD= "mysql -u$MYUSER -p$MYPASS -S $SOCKET" MYDUMP= "mysqldump -u$MYUSER -p$MYPASS -S $SOCKET" [ ! -d $DBPATH ] &&  mkdir -p $DBPATH for dbname  in `$MYCMD -e  "show databases;" | sed ‘1,2d‘ | egrep - v "mysql|schema" ` do     mkdir $DBPATH/${dbname}_$( date +%F) -p     for table  in `$MYCMD -e  "show tables from $dbname;" | sed ‘1d‘ `     do      $MYDUMP $dbname $table| gzip >$DBPATH/${dbname}_$( date +%F)/${dbname}_${table}.sql.gz     done done

MySQL Database sub-Library backup, sub-table backup