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

260009610

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

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

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

lonefly

军哥LNMP里的备份脚本
[ol][*]#!/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.gz
[*]TodayDBBackup=db-*-$(date +"%Y%m%d").sql
[*]OldWWWBackup=www-*-$(date -d -3day +"%Y%m%d").tar.gz
[*]OldDBBackup=db-*-$(date -d -3day +"%Y%m%d").sql
[*]
[*]Backup_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 1
[*]fi
[*]
[*]if [ ! -d ${Backup_Home} ]; then  
[*]    mkdir -p ${Backup_Home}
[*]fi
[*]
[*]if [ ${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."; }
[*]fi
[*]
[*]echo "Backup website files..."
[*]for dd in ${Backup_Dir[@]};do
[*]    Backup_Dir ${dd}
[*]done
[*]
[*]echo "Backup Databases..."
[*]for db in ${Backup_Database[@]};do
[*]    Backup_Sql ${db}
[*]done
[*]
[*]echo "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} 复制代码

Salta

增量备份到异地就行了。

260009610

Salta 发表于 2023-8-5 15:35

增量备份到异地就行了。
有教程吗

Salta

260009610 发表于 2023-8-5 15:36

有教程吗
请自行百度哦 亲亲

why?

本帖最后由 why? 于 2023-8-5 16:32 编辑

实时同步的叫主从   ， 非常简单

容灾手段


不懂技术的 有钱的用阿里 也不错，除了贵点，正常用也没啥问题。 阿里云的备份什么的 都是单独算钱的，实例+备份+日志  估计费用还得涨