备份mysql schema_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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30623428/viewspace-1870424/，如需转载，请注明出处，否则将追究法律责任。