mysql> show databases g
*************************** 1. row ***************************
database: information_schema
*************************** 2. row ***************************
database: mysql
*************************** 3. row ***************************
database: test
3 rows in set (0.00 sec)
2.执行完全备份
sh back.sh
back.sh
#!/bin/sh
export back_dir=/data/bak
export pass=123
export mysql_dir=/usr/local/mysql-5.1.56
for i in $(mysql -uroot -p$pass -e show databases g | grep database | cut -d: -f2)
do
$mysql_dir/bin/mysqldump --opt $i -p$pass --skip-lock-tables>$back_dir/$i.$(date +%y%m%d).sql
done
#use fetion to notice dba
ld_library_path=/usr/lib /usr/local/fetion/fetion --mobile=159xxxx3240 --pwd=123456 --to=159xxxx3240 --msg-utf8=mysql backup is success !
3.计划任务
crontab -e
0 3 * * * sh /usr/bin/back.sh bitscn.com