DB_PWD} -h${DB_HOST} -q -R --databases $DATABASE1 | gzip > ${BACKUP}/$DATETIME/${TIME}_${DATABASE1}.sql.gz...DB_PWD} -h${DB_HOST} -q -R --databases $DATABASE2 | gzip > ${BACKUP}/$DATETIME/${TIME}_${DATABASE2}.sql.gz
mysqldump -uroot -p123456 testdb01 | gzip > /mysqlbackup/backupfiles/testdb01_$(date +%Y%m%d_%H%M%S).sql.gz...pBroot_2020 tlj-ptmis_basic-b | gzip > /mysqlbackup/backupfiles/tlj-ptmis_basic-b_$(date +%Y%m%d_%H%M%S).sql.gz
-uroot -ppassword ${src_dbname_list[$i]} | gzip > /tmp/src_dbname/${time1}/${src_dbname_list[$i]}.sql.gz...033[32m${time2} ${src_dbname_list[$i]} 源数据库压缩备份成功 路径:/tmp/src_dbname/${time1}/${src_dbname_list[$i]}.sql.gz...-uroot -ppassword ${dst_dbname_list[$j]} | gzip > /tmp/dst_dbname/${time1}/${dst_dbname_list[$j]}.sql.gz...[32m${time2} ${dst_dbname_list[$j]} 目标数据库压缩备份成功 路径:/tmp/dst_dbname/${time1}/${dst_dbname_list[$j]}.sql.gz...\n\033[0m" gunzip < /tmp/src_dbname/${time1}/${src_dbname_list[$i]}.sql.gz | mysql -uroot -ppassword
/bin/bash mysqldump -uroot -ppassword datebaes | gzip > /data/data/file_$(date +%Y%m%d_%H%M%S).sql.gz...passwd $dbname > $mysql_back_path/$time.sql.gz echo '数据库备份完成' find /home/dbback/ -mtime +3 -name "*.sql.gz
一般备份时都会进行压缩处理,以节省磁盘空间,如下 mysqldump -A -B --single-transaction |gzip>/server/backup/mysql_$(date +%F).sql.gz...恢复操作 cd /server/backup/gzip -o mysql_$(date +%F).sql.gz mysql -uroot -pMyadmin -h mysqldb.mingongge.com...mysqldump -A -B --single-transaction testDB1|gzip>/server/backup/testDB1_$(date +%F).sql.gz 什么是增量备份?...mysqldump --single-transaction -F -B ywotx|gzip >/server/backup/ywotx_$(date+%F).sql.gz find /server...done done find /server/backup/${dbname} -type f –name “*.sql.gz”-mtime +7|xargs rm -f 3、定时备份二进制文件(
mysqldump -uusername -ppassword database_name | gzip > /backup/database_name$(date +%Y%m%d%H%M%S).sql.gz...mysqldump -uusername -ppassword --all-databases | gzip > /backup/database_name$(date +%Y%m%d%H%M%S).sql.gz...我们需要备份的是近期最新的数据,所以定期删除文件就很有必要了 定期删除,我们只需要在脚本文件中添加以下命令: #删除七天之前的备份find $backup_dir -name $db_name"*.sql.gz...type f -mtime +7 -exec rm -rf {} \; > /dev/null 2>&1 #删除一分钟之前的备份 find $backup_dir -name $db_name"*.sql.gz...find $backup_dir -name $mbook"*.sql.gz" -type f -mtime +30 -exec rm -rf {} \; > /dev/null 2>&1 find
MAIN_PATH=/server/backup LOG_FILE=${MAIN_PATH}/logs_`date +%F`.log DATA_FILE=${MAIN_PATH}/backup_`date +%F`.sql.gz...MAIN_PATH=/server/backup LOG_FILE=${MAIN_PATH}/logs_`date +%F`.log DATA_FILE=${MAIN_PATH}/backup_`date +%F`.sql.gz...MYSQL_PATH}/mysql -u$MYUSER -p$MYPASS -S $MYSOCK" #recover cd ${MAIN_PATH} gzip -d backup_`date +%F`.sql.gz
done if [ $flag -ne 1 ] then #指定时间日期和备份目录 backupdir=/data/bakmysql/$dbname`date +%Y-%m-%d_%H%M%S`.sql.gz...----------------------" >> $LogFile fi done #删除七天前备份 find /data/bakmysql/ -mtime +10 -name "*.sql.gz
/bin/bash mysqldump -uusername -ppassword emp | gzip > /home/backup/emp$_(date +%Y%m%d_%H%M%S).sql.gz...#删除15天之前的备份 find /home/backup -name emp"*.sql.gz" -type f -mtime +15 -exec rm -rf {} \; > /dev/null 2...>&1 #删除1分钟之前的备份 find /home/backup -name emp"*.sql.gz" -type f -mmin +1 -exec rm -rf {} \; > /dev/null
xargs`; do (/usr/local/mysql/bin/mysqldump -u$MYSQL_USER -p$MYSQL_PASS ${db} | gzip -9 - > ${db}.sql.gz...) done #压缩数据库文件为一个文件 tar zcf /home/backup/$DataBakName /home/backup/*.sql.gz rm -rf /home/backup/*.sql.gz
BACKUP_LOG="${base_dir}/mysql_backup.log" DBNAME="radius" FILE_UPLOAD="${DBNAME}-$(date +"%Y-%m-%d").sql.gz..." FILE_DELE="${DBNAME}-$(date -d "-10 day" +"%Y-%m-%d").sql.gz" echo "ftp upload $FILE_UPLOAD finished
#mysqldump -u$user -p$password --all-databases | gzip > /backup/mysql/db_name$(date +%Y%m%d%H%M%S).sql.gz...mysqldump -u$user -p$password --all-databases | gzip > /backup/mysql/db_name$(date +%Y%m%d%H%M%S).sql.gz...删除 mtime 表示天 day='date -d "$days days ago" +%Y%m%d' #rm -rf $day #find $backup_path -name $db_name"*.sql.gz
'.sql.gz' : '.sql'); } return $this->_SaveToFile($fname, $sql, $compress);...'.sql.gz' : '.sql'); } return $this->_DownloadFile($fname, $sql, $compress);
$backup_file" # 压缩备份文件 gzip "$backup_dir/$backup_file" # 删除 7 天前的备份文件 find "$backup_dir" -name "*.sql.gz...$backup_file" # 压缩备份文件 gzip "$backup_dir/$backup_file" # 删除 7 天前的备份文件 find "$backup_dir" -name "*.sql.gz
最终,每次执行这个脚本生成的备份文件名类似于系统日期时间+.sql.gz,例如20150606.sql.gz。...RUNCMD "$FINDCMD $BACKUPDIR -name \"*.sql.gz\" -type f -mtime +$NUMDAYS -print0 | xargs -0 rm -fv"
编辑脚本,添加mysql打包备份命令: mysqldump -uroot -p'123456' shaun | gzip > /mnt/bak/database_`date +%Y%m%d%H%M`.sql.gz
Y%m%d%H%M%S).sql mysqldump -ussh -pssh --all-databases | gzip > /backup/mbook_$(date +%Y%m%d%H%M%S).sql.gz...#定时清理备份文件命令 find /backup/mbook -name $mbook"*.sql.gz" -type f -mmin +1 -exec rm -rf {} \; > /dev/null
获取到数据库名 for database in $DATABASE do $MYDUMP -B $database|gzip >/server/backup/${database}_$(date +%F).sql.gz...TABLE do $MYDUMP $database $table |gzip >/server/backup/$database/${database}_${table}_$(date +%F).sql.gz
领取专属 10元无门槛券
手把手带您无忧上云