Windows下实现mysql定时备份

分类: 文章 • 2024-01-13 11:03:52

1. MySQL备份bat处理: odls_auto_backup.bat

rem *******************************Code Start*****************************
@echo off

set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
mysqldump --opt -u root --password=h3c.odls --default-character-set=utf8 odlsportal > D:\DBBackup\odlsportal_%Ymd%.sql

@echo on
rem *******************************Code End*****************************