A case of MySQL database backup script

example, MySQL database backup script.
Vim mysql.sh

#!/bin/Bashday= ' Date +%y-%m-%d '//date is displayed and given the day variableSize= ' Du-sh/var/lib/mysql//check the size of MySQL and assign a variable sizeEcho"Date: $DAY">>/tmp/mysqlbak.txt//output date to mysqlbak.txt fileEcho"Date Size: $SIZE">>/tmp/mysqlbak.txt//output file size to Mysqlbak.txt fileCd/tmp/mysql//switch to the MySQL directoryTar zcvf mysqlbak-${day}.tar.gz/var/lib/mysql/tmp/mysqlbak.txt//package MySQL database files and date size filesRm-rf/tmp/mysql.txt//Delete mysqlbak.txt storage mysql data size file

A case of MySQL database backup script