mysql数据备份

使用定时任务进行备份

/**
 * 每天中午十二点备份
 * */
@Scheduled(cron = "0 0 12 * * ?")
public void saveBackup() {
    Runtime rt = Runtime.getRuntime();
    SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
    Date date = new Date();
    String password = "123456";		//数据库连接密码
    String backup_path = "C:\\backup_file";	//备份文件存放位置
    // 要用来做导入用的sql目标文件：
    String filename = backup_path +"\\数据库名_"+ sdf.format(date) + ".sql";
    //调用外部执行exe文件的javaAPI
    try {
        Process process = rt.exec("cmd /c mysqldump -hlocalhost -uroot -p"+ password +" -x 数据库名_ > " + filename);
        System.out.println("数据备份成功..................................................");
    } catch (IOException e) {
        e.printStackTrace();
    }

}