windows系统自动备份mysql数据库的方法 mysqldump

最新推荐文章于 2023-10-17 16:19:31 发布

原创最新推荐文章于 2023-10-17 16:19:31 发布 · 297 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysqldump #mysql #数据库备份

mysql 同时被 2 个专栏收录

6 篇文章

订阅专栏

windows

3 篇文章

订阅专栏

本文介绍了一种通过批处理脚本实现MySQL数据库自动备份的方法，并使用任务计划程序进行定时执行，确保数据的安全性和完整性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、新建一个backmysql.bat文件

@echo off

set yyyy=%date:~,4%
set mm=%date:~5,2%
set dd=%date:~8,2%
if /i %time:~0,2% lss 10 set hh=0%time:~1,1%
if /i %time:~0,2% geq 10 set hh=%time:~0,2%
set mn=%time:~3,2%
set ss=%time:~6,2%
set date=%yyyy%%mm%%dd%
set time=%hh%%mn%%ss%
set filename=%date%_%time%


"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump">mysqldump --opt -P4406 -u root --password=root databasename >E:/DatabaseBackUp/databasename/databasename_%filename%.sql

@echo on
#@pause

2、使用任务计划程序导入计划 BackUpMysql.xml

<?xml version="1.0" encoding="UTF-16"?>
<Task version="1.2" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task">
  <RegistrationInfo>
    <Date>2019-03-21T15:44:44.3029412</Date>
    <Author>abc\USER001</Author>
  </RegistrationInfo>
  <Triggers>
    <CalendarTrigger>
      <StartBoundary>2019-03-21T04:00:00</StartBoundary>
      <Enabled>true</Enabled>
      <ScheduleByDay>
        <DaysInterval>1</DaysInterval>
      </ScheduleByDay>
    </CalendarTrigger>
    <CalendarTrigger>
      <StartBoundary>2019-03-22T13:30:00</StartBoundary>
      <Enabled>true</Enabled>
      <ScheduleByDay>
        <DaysInterval>1</DaysInterval>
      </ScheduleByDay>
    </CalendarTrigger>
    <CalendarTrigger>
      <StartBoundary>2019-03-22T10:33:00</StartBoundary>
      <Enabled>true</Enabled>
      <ScheduleByDay>
        <DaysInterval>1</DaysInterval>
      </ScheduleByDay>
    </CalendarTrigger>
  </Triggers>
  <Principals>
    <Principal id="Author">
      <UserId>abc\USER001</UserId>
      <LogonType>Password</LogonType>
      <RunLevel>HighestAvailable</RunLevel>
    </Principal>
  </Principals>
  <Settings>
    <MultipleInstancesPolicy>IgnoreNew</MultipleInstancesPolicy>
    <DisallowStartIfOnBatteries>false</DisallowStartIfOnBatteries>
    <StopIfGoingOnBatteries>true</StopIfGoingOnBatteries>
    <AllowHardTerminate>true</AllowHardTerminate>
    <StartWhenAvailable>false</StartWhenAvailable>
    <RunOnlyIfNetworkAvailable>false</RunOnlyIfNetworkAvailable>
    <IdleSettings>
      <StopOnIdleEnd>true</StopOnIdleEnd>
      <RestartOnIdle>false</RestartOnIdle>
    </IdleSettings>
    <AllowStartOnDemand>true</AllowStartOnDemand>
    <Enabled>true</Enabled>
    <Hidden>false</Hidden>
    <RunOnlyIfIdle>false</RunOnlyIfIdle>
    <WakeToRun>true</WakeToRun>
    <ExecutionTimeLimit>P3D</ExecutionTimeLimit>
    <Priority>7</Priority>
  </Settings>
  <Actions Context="Author">
    <Exec>
      <Command>C:\Windows\backmysql.bat</Command>
      <WorkingDirectory>C:\Windows\</WorkingDirectory>
    </Exec>
  </Actions>
</Task>