213的数据库备份脚本
备份表结构和存储过程
[root@linux-i77amysqllist]#cat dbbak.sh
#!/bin/sh
set -x
data=`date +%Y%m%d%H%M`
mkdir /tmp/mysqllist/bak$data/
dir1=/usr/local/mysql516-3303/bin/
dir2=/tmp/mysqllist/bak$data/
cd $dir1
./mysql -uroot -p123 -S /tmp/mysql3303.sock <<EOF > /tmp/mysqllist/tables.txt
show databases;
EOF
for i in `cat /tmp/mysqllist/tables.txt`
do
./mysqldump -uroot -p123 -S /tmp/mysql3303.sock -d -R --add-drop-table $i > $dir2$i.sql
done
set +x
216的项目备份
[root@datingdb02 shell]# cat bak.sh
#!/bin/sh
date=`date +%Y%m%d%H%M`
echo "=========bakup qzxy========"
tar -jcvf /bak/backup/web/qzxy.$date.bz2 /data/web/qzxy
echo "=========show files======="
ls -lnt /bak/backup/web
