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