linux和windows进行MySQL数据异地备份

linux数据备份

varDate=$(date "+%Y-%m-%d")
delDate=$(date -d "15 day ago " +%Y-%m-%d) 
"/www/server/mysql/bin/mysqldump" -h192.168.100.122 -P3309  -uroot -p3cb160c75a596be7 -R -E b2b2c > "/mnt/dataCopy/117/b2b2c/b2b2c_"$varDate".sql"

windows数据备份

@echo off
echo 设置MySql数据库的连接信息

set host=192.168.100.122
set port=3309
set user=root
set pass=3cb160c75a596be7

echo 设置要备份的MySql数据库名称

set dbname=demo
 
echo 获取当天的日期格式，例如：2022122031300

set hour=%time:~0,2%
if "%time:~0,1%"==" " set hour=0%time:~1,1%
 
set backup_date=%Date:~0,4%%Date:~5,2%%Date:~8,2%%hour%%Time:~3,2%%Time:~6,2%
 
echo 设置备份文件的路径

set backupfile=C:\Users\lsf\Desktop\dataCopy\117\%dbname%-%backup_date%.sql
 
echo 使用mysqldump对指定的MySql进行备份
echo 注意路径中有空格的要加上双引号
 
"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump" -h%host% -P%port% -u%user% -p%pass% -c --add-drop-table %dbname% > %backupfile%
 
echo 删除过期文件，这里是超过30天就删除
 
forfiles /p F:\backData /s /m *.sql /d -30 /c "cmd /c del @file /f"