public void execute(JobExecutionContext jobExecutionContext) throws JobExecutionException {
try {
String command = "cmd /c mysqldump -uroot -ppassword databasesName >C://databaseFile/database.sql"
Process process = Runtime.getRuntime().exec(command);
System.out.println("MYSQL自动备份完成,备份时间为:"+ new java.util.Date().getTime());
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
配置环境变量path:C:\Program Files\MySQL\MySQL Server 5.7\bin
cmd /c mysqldump -uroot -ppassword databasesName >C://databaseFile/database.sql
数据库密码尽量不要是 ^ 等特殊符号