Mysql完全备份
1.查看mysql上都有哪些库mysql> show databases \G*************************** 1. row ***************************Database: information_schema*************************** 2. row ***************************Database: mysql*************************** 3. row ***************************Database: test3 rows in set (0.00 sec)2.执行完全备份sh back.shback.sh#!/bin/shexport back_dir=/data/bakexport pass="123"export mysql_dir=/usr/local/mysql-5.1.56for 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).sqldone #use fetion to notice dbaLD_LIBRARY_PATH=/usr/lib/usr/local/fetion/fetion--mobile=159xxxx3240 --pwd=123456 --to=159xxxx3240 --msg-utf8=mysql backup is success !3.计划任务crontab -e0 3 * * * sh /usr/bin/back.sh
页:
[1]