Mysql backup script

The mysql backup script writes a mysql backup file today, mainly using the mysqldump tool. The requirement is to back up some databases at three o'clock every day and keep the backups for two days. Simple requirement: The following script

#! /Bin/shdbs = $ (echo '/usr/bin/mysql-uroot-ppasswd-s-e "show databases; "| egrep-v" performance_schema | information_schema | test | mysql "') bak_name = 'hostname' 'date' + % Y % m % d % H % m' '/usr/bin/mysqldump-uroot-ppasswd -- single-transaction -- databases $ dbs> /data/backup/$ bak_name. SQL & gzip/data/backup/$ bak_name. SQL/usr/bin/find/data/backup/-type f-mtime + 2-exec rm-f {}\;

 

Crontab is set to 0 3 */bin/sh/root/script/backup. sh>/dev/null 2> & 1