window下mysql日常备份

最新推荐文章于 2024-07-15 20:47:42 发布

何超杰

最新推荐文章于 2024-07-15 20:47:42 发布

阅读量5.4k

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/hechaojie_com/article/details/82012947

版权

mysql 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

1.使用mysqldump备份数据库

rem author hecj
rem ******MySQL backup start********
@echo off

forfiles /p "E:\db_backup\backup" /m crm_admin_*.sql -d -800 /c "cmd /c del /f @path"

set "Ymd=%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%"

rem set "Ymd=%date:~0,4%%date:~5,2%%date:~8,2%"

E:\db_backup\tools\mysql\MySQLServer5.5\bin\mysqldump --opt --single-transaction=TRUE --user=root --password=123456 --host=192.168.168.28 --protocol=tcp --port=3306 --default-character-set=utf8 --single-transaction=TRUE --routines --events "crm_admin" > E:\db_backup\backup\crm_admin_%Ymd%.sql

cd E:\db_backup\backup
rar a -df crm_admin_%Ymd%.rar crm_admin_%Ymd%.sql

@echo on
rem ******MySQL backup end********