自动备份mysql数据库(兼容windows,linux)
自动将mysql服务器的各数据库分别备份压缩并上传到指定FTP服务器，先编辑脚本更改数据库连接配置,留空FTP信息则只备份不上传。windws用bat脚本,linux用bash脚本,请分别将此脚本加载到计划任务中定时执行. @ECHO OFF REM name: mysql_backup.bat REM description: mysql backup and upload REM version: v1.0.0 REM author: Shi Zhuolin REM E-mail: shizhuolin@hotmail.com shizhuolin@qq.com REM the directory for story your backup file SET backup_dir=”D:\mysql_backup\files” REM your mysql login information SET db_host= SET db_user= SET db_passwd= REM your ftp login information SET ftp_host= SET ftp_user= SET ftp_passwd= […]