Shulou(Shulou.com)05/31 Report--

This article shows you how to back up multiple databases in Mysql, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Backup data script

#! / bin/bash# date is a command of linux date [parameters] [+ format] time= `date +% Y_%m_%d_%H_%M_%S `# backup output path backupdir=/home/backup/# backup file path filedir=/home/my_app/files/# use the sql statement to retrieve all databases starting with 'test'. Pass instructions to the mysql client through the pipeline -N means the header and end of the result are not output, and the result is a pure dataset databases= ('echo' show databases like "test%";'| mysql-N-uroot-proot`) # send the output file of mysqldump to gzip for compression through pipeline. Gzip is a mysqldump-uroot-proot-- databases ${databases [*]} | gzip > $backupdir/$time.sql.gz# backup file that cannot save the original file and cannot compress the directory. Zip [compressed output file] [compressed file] zip-r $backupdir/$time.zip $filedir# delete the backup file find $backupdir-mtime + 7-name "*"-exec rm-rf {}\

Then set crontab to run the backup script in the early hours of each day.

Data recovery

Mysql-u root-p DATABESE_NAME

Source dump.sql the above is how to back up multiple databases in Mysql. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.