mysql 备份的的一个小脚本
BACKUP_DIR=/home/backup
NOW=$(date +%Y%m%d)
mysql -uroot -p'123456' -Ne "select concat('mysqldump -uroot -p123456 --default-character-set=''utf8'' --database ',schema_name,' > /home/backup/',schema_name,'$NOW','.sql') from information_schem
a.SCHEMATA where schema_name not in('information_schema','mysql');" > /home/backupscript.sql
/home/backupscript.sql
echo "=============== mysqldump end ===============">> $BACKUP_DIR/log;
zip -r /home/backup/TESTFULL_DB_$NOW.zip /home/backup/*.sql;
wait;
echo "=============== ftp backupset to ftpserver =====================">>$BACKUP_DIR/log;
###########ftp backupset to another server
FTP_HostName=172.166.23.200
FTP_UserName=dba
FTP_PassWord='TriffsWZY2f015'
lftp $FTP_HostName -u $FTP_UserName,$FTP_PassWord << EOF
mput $BACKUP_DIR/CAC_TESTFULL_DB_$NOW.zip
bye
EOF
wait;
echo "=============== END =====================">>$BACKUP_DIR/log;
rm -rf /home/backup/*.sql
NOW=$(date +%Y%m%d)
mysql -uroot -p'123456' -Ne "select concat('mysqldump -uroot -p123456 --default-character-set=''utf8'' --database ',schema_name,' > /home/backup/',schema_name,'$NOW','.sql') from information_schem
a.SCHEMATA where schema_name not in('information_schema','mysql');" > /home/backupscript.sql
/home/backupscript.sql
echo "=============== mysqldump end ===============">> $BACKUP_DIR/log;
zip -r /home/backup/TESTFULL_DB_$NOW.zip /home/backup/*.sql;
wait;
echo "=============== ftp backupset to ftpserver =====================">>$BACKUP_DIR/log;
###########ftp backupset to another server
FTP_HostName=172.166.23.200
FTP_UserName=dba
FTP_PassWord='TriffsWZY2f015'
lftp $FTP_HostName -u $FTP_UserName,$FTP_PassWord << EOF
mput $BACKUP_DIR/CAC_TESTFULL_DB_$NOW.zip
bye
EOF
wait;
echo "=============== END =====================">>$BACKUP_DIR/log;
rm -rf /home/backup/*.sql
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30623428/viewspace-1870424/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
请登录后发表评论
登录
全部评论
