java代码实现数据库备份

java 代码实现数据库备份

• 引入xxl-job，定时调度改方法，实现数据库备份

配置类

import lombok.Data;
@Data
public class BackupConfig {
    private String ip = "10.1.132.23 ";
    private String backupPath = "D:\\test\\backup";
    private String mysqldumpPath = "mysqldump";
    private String username = "root";
    private String password = "root";
    private String port = "3306";
    private String dbName = "dbName";
}

执行方法

import com.spic.project.service.BriefingScheduleService;
import com.xxl.job.core.context.XxlJobHelper;
import com.xxl.job.core.handler.annotation.XxlJob;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;

/**
 * @project 
 * @Classname XxlJobTask
 * @Description TODO
 * @Date 2022/11/2 11:18
 * @Created by weidong
 */
@Component
public class XxlJobTask {

    private static Logger logger = LoggerFactory.getLogger(XxlJobTask.class);

    /**
     * 数据库备份
     */
    @XxlJob("buckUpDBJobHandler")
    public void buckUpDBJobHandler() throws Exception {

        XxlJobHelper.log("request param.");
        logger.info("执行--数据库备份--定时任务begin时间: " + LocalDateTime.now());
        BackupConfig backupConfig = new BackupConfig();
        File file = new File(backupConfig.getBackupPath());
        if (!file.exists()) {
            file.mkdirs();
        }
        String fileName = backupConfig.getBackupPath() + "/" + "mysql" + System.currentTimeMillis() + ".sql";
        /** 默认使用linux*/
        //String cmdPrefix = "/bin/sh -c ";
        String c1 = "/bin/sh";
        String c2 = "-c";
        String os_name = System.getProperty("os.name");
        // 判断是否是windows系统
        if (os_name.toLowerCase().startsWith("win")) {
            //cmdPrefix = "cmd /c ";
            c1 = "cmd";
            c2 = "/c";
        }
        String cmd = backupConfig.getMysqldumpPath()  // mysqldump的绝对路径，配置环境变量，直接写mysqldump即可
                + " -h " + backupConfig.getIp()  // ip
                + " -u" + backupConfig.getUsername()  // 数据库用户名
                + " -p" + backupConfig.getPassword()  // 数据库密码
                + " -P" + backupConfig.getPort()      // 数据库端口号
//                + " " + " --databases MySQL"      // 数据库名
                + " " + " -A"      // -A
                + " > " + fileName;                   // 最终写入的文件路径
        try {
            System.out.println("第一个参数 " + c1);
            System.out.println("第二个参数 " + c2);
            System.out.println("具体命令 " + cmd);

//            log.error("数据库备份START" + LocalDateTime.now());
            /**
             * exec重载方法有一个参数的，window下执行正常，linux下无法完成备份。
             * 使用多参数重载方法都可以正常备份
             */
            Process process = Runtime.getRuntime().exec(new String[]{c1, c2, cmd});
            process.waitFor();

//            log.info("数据库备份END" + LocalDateTime.now());
        } catch (Exception e) {
            e.printStackTrace();
//            log.error("数据库备份失败:{}", e.getMessage());
        }


        logger.info("执行--数据库备份--定时任务时间: " + LocalDateTime.now());
        XxlJobHelper.log("执行--数据库备份--定时任务时间: " + LocalDateTime.now());
    }
}