java备份mysql脚本

import java.io.File;
import java.io.IOException;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.nio.file.StandardCopyOption;

public class MySQLBackup {
    public static void main(String[] args) {
        String host = "localhost";
        String user = "username";
        String password = "password";
        String database = "database_name";
        String backupPath = "/path/to/backup/directory";
        String backupFileName = database + "_backup_" + System.currentTimeMillis() + ".sql";

        try {
            // 创建备份目录
            File backupDir = new File(backupPath);
            if (!backupDir.exists()) {
                backupDir.mkdirs();
            }

            // 构建mysqldump命令
            String command = String.format("mysqldump -h %s -u %s -p%s %s > %s/%s",
                    host, user, password, database, backupPath, backupFileName);

            // 执行mysqldump命令
            Process process = Runtime.getRuntime().exec(command);
            process.waitFor();

            // 备份成功，将备份文件重命名为带日期的格式
            String date = new java.text.SimpleDateFormat("yyyyMMddHHmmss").format(new java.util.Date());
            Files.move(Paths.get(backupPath, backupFileName),
                    Paths.get(backupPath, database + "_backup_" + date + ".sql"),
                    StandardCopyOption.REPLACE_EXISTING);

            System.out.println("Backup completed successfully.");
        } catch (IOException | InterruptedException e) {
            e.printStackTrace();
        }
    }
}