window中mysql bat脚本_MySQL window环境下bat脚本定时备份
一、bat文件
@echo off
set hour=%time:~0,2%
if "%time:~0,1%"==" " set hour=0%time:~1,1%
set now=%Date:~0,4%%Date:~5,2%%Date:~8,2%%hour%%Time:~3,2%%Time:~6,2%
echo %now%
set host=127.0.0.1
set port=3306
set user=root
set pass=love
set dbname=test
set backupfile=C:\Users\dgw\Desktop\%now%.sql
G:\tool\MySQL\bin\mysqldump -h%host% -P%port% -u%user% -p%pass% -c --add-drop-table %dbname% > %backupfile%
二、java代码
package com.love.test;
import java.io.IOException;
import java.util.Timer;
import java.util.TimerTask;
public class Test {
public static void main(String[] args) {
Timer timer = new Timer();
MyTask myTask = new MyTask();
timer.schedule(myTask, 0,2000);
}
}
class MyTask extends TimerTask{
@Override
public void run() {
runbat("C:/Users/dgw/Desktop/dbbackup.bat");
System.out.println("备份了数据");
}
public static void runbat(String batPath) {
try {
Process ps = Runtime.getRuntime().exec(batPath);
ps.waitFor();
} catch (IOException ioe) {
ioe.printStackTrace();
}catch (InterruptedException e) {
e.printStackTrace();
}
}
}
三、运行效果图
