Mysql backup multiple database code examples

#!/bin/bash

# date is a command in Linux date [parameter] [+format]
time=`date +%Y_%m_%d_%H_%M_%S`
# Backup output path backupdir=/home/backup/
# Backup file path filedir=/home/my_app/files/
# Use sql statement to retrieve all databases starting with 'test'. Pass the command to the mysql client through the pipeline; -N means not to output the header and end of the result, and the result is a pure data set databases=(`echo 'show databases like "test%";' | mysql -N -uroot -proot`)
# Pass the output file of mysqldump to gzip through the pipe for compression. gzip cannot save the original file and cannot compress the directory. mysqldump -uroot -proot --databases ${databases[*]} | gzip > $backupdir/$time.sql.gz
# Back up files. zip [compressed output file] [compressed file]
zip -r $backupdir/$time.zip $filedir
# Delete the backup file 7 days ago find $backupdir -mtime +7 -name "*" -exec rm -rf {} \;

mysql -u root -p DATABESE_NAME < dump.sql

mysql> source dump.sql