mysql数据库有什么好备份方案吗

hasanrejan7

今天dmit的高仿spro 断了下
mysql数据库也没备份  好担心数据没了

朋友推荐用阿里云的云数据库rds 但是一年要1万块

除了这个方案还有别的好方案备份sql数据库么  最好是同步的

tkv2373

增量备份到异地就行了。

sinalook

有教程吗

chjian

请自行百度哦 亲亲

fjord

fqdLNMP里的备份脚本

1. #!/usr/bin/env bash#Funciont: Backup website and mysql database#Author: licess#Website: https://lnmp.org#IMPORTANT!!!Please Setting the following Values!Backup_Home="/home/backup/"MySQL_Dump="/usr/local/mysql/bin/mysqldump"######~Set Directory you want to backup~######Backup_Dir=("/home/wwwroot/vpser.net" "/home/wwwroot/lnmp.org")######~Set MySQL Database you want to backup~######Backup_Database=("lnmp" "vpser")######~Set MySQL UserName and password~######MYSQL_UserName='root'MYSQL_PassWord='yourrootpassword'######~Enable Ftp Backup~######Enable_FTP=0# 0: enable; 1: disable######~Set FTP Information~######FTP_Host='1.2.3.4'FTP_Username='vpser.net'FTP_Password='yourftppassword'FTP_Dir="backup"#Values Setting END!TodayWWWBackup=www-*-$(date +"%Y%m%d").tar.gzTodayDBBackup=db-*-$(date +"%Y%m%d").sqlOldWWWBackup=www-*-$(date -d -3day +"%Y%m%d").tar.gzOldDBBackup=db-*-$(date -d -3day +"%Y%m%d").sqlBackup_Dir(){    Backup_Path=$1    Dir_Name=`echo ${Backup_Path##*/}`    Pre_Dir=`echo ${Backup_Path}|sed 's/'${Dir_Name}'//g'`    tar zcf ${Backup_Home}www-${Dir_Name}-$(date +"%Y%m%d").tar.gz -C ${Pre_Dir} ${Dir_Name}}Backup_Sql(){    ${MySQL_Dump} -u$MYSQL_UserName -p$MYSQL_PassWord $1 > ${Backup_Home}db-$1-$(date +"%Y%m%d").sql}if [ ! -f ${MySQL_Dump} ]; then      echo "mysqldump command not found.please check your setting."    exit 1fiif [ ! -d ${Backup_Home} ]; then      mkdir -p ${Backup_Home}fiif [ ${Enable_FTP} = 0 ]; then    type lftp >/dev/null 2>&1 || { echo >&2 "lftp command not found. Install: centos:yum install lftp,debian/ubuntu:apt-get install lftp."; }fiecho "Backup website files..."for dd in ${Backup_Dir[@]};do    Backup_Dir ${dd}doneecho "Backup Databases..."for db in ${Backup_Database[@]};do    Backup_Sql ${db}doneecho "Delete old backup files..."rm -f ${Backup_Home}${OldWWWBackup}rm -f ${Backup_Home}${OldDBBackup}if [ ${Enable_FTP} = 0 ]; then    echo "Uploading backup files to ftp..."    cd ${Backup_Home}    lftp ${FTP_Host} -u ${FTP_Username},${FTP_Password} << EOFcd ${FTP_Dir}mrm ${OldWWWBackup}mrm ${OldDBBackup}mput ${TodayWWWBackup}mput ${TodayDBBackup}byeEOFecho "complete."fi

复制代码