第一步 ：添加mysqldump.exe 进环境变量

第二步  新建一个spring boot 项目,连接数据库

spring.datasource.url=jdbc:mysql://localhost:3308/springbootdb?useUnicode=true&characterEncoding=utf8&allowMultiQueries=truespring.datasource.username=rootspring.datasource.password=mysqlspring.datasource.driver-class-name=com.mysql.jdbc.Driver

第三步  添加相关需要的jar

<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope></dependency><!-- quartz --><dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-quartz</artifactId></dependency>

第四步 创建定时任务

 /** * 执行定时任务 */ @Override protected void executeInternal(JobExecutionContext context) throws JobExecutionException { // TODO Auto-generated method stub System.out.println("执行定时任务》》》"+new Date()); String filePath="D:\\数据库文件\\"; String dbName="springbootdb";//备份的数据库名 String username="root";//用户名 String password="mysql";//密码 File uploadDir = new File(filePath); if (!uploadDir.exists()) uploadDir.mkdirs(); String cmd = "mysqldump -u"+ username +" -p "+password + dbName + " -r " + filePath + "/" + dbName+new java.util.Date().getTime()+ ".sql"; try { Process process = Runtime.getRuntime().exec(cmd); System.out.println("备份数据库成功!!!"); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } }

第五步  配置quartz，设置每10秒执行一次定时任务

@Configurationpublic class QuartzConfig { @Bean public JobDetail teatQuartzDetail(){ return JobBuilder.newJob(TestQuartz.class).withIdentity("testQuartz").storeDurably().build(); } @Bean public Trigger testQuartzTrigger(){ SimpleScheduleBuilder scheduleBuilder = SimpleScheduleBuilder.simpleSchedule() .withIntervalInSeconds(10) //设置时间周期单位秒 .repeatForever(); return TriggerBuilder.newTrigger().forJob(teatQuartzDetail()) .withIdentity("testQuartz") .withSchedule(scheduleBuilder) .build(); }}

第六步  运行项目

 备份成功！！！！！！！！！！！！！！！！！！！！

github项目地址    copyDatabase