java mysql备份还原

import java.io.File;
import java.io.IOException;
import java.util.concurrent.TimeUnit;

public class MySQLBackup {
    public static void main(String[] args) {
        String dbName = "your_database_name";
        String backupPath = "/path/to/backup.sql";
        String user = "your_username";
        String password = "your_password";

        try {
            ProcessBuilder pb = new ProcessBuilder("mysqldump", "-u" + user, "-p" + password, dbName);
            pb.redirectErrorStream(true);
            Process process = pb.start();

            File outputFile = new File(backupPath);
            try (FileOutputStream fos = new FileOutputStream(outputFile)) {
                process.getInputStream().transferTo(fos);
            }

            process.waitFor(60, TimeUnit.SECONDS);
        } catch (IOException | InterruptedException e) {
            e.printStackTrace();
        }
    }
}

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.concurrent.TimeUnit;

public class MySQLRestore {
    public static void main(String[] args) {
        String dbName = "your_database_name";
        String backupPath = "/path/to/backup.sql";
        String user = "your_username";
        String password = "your_password";

        try {
            ProcessBuilder pb = new ProcessBuilder("mysql", "-u" + user, "-p" + password, dbName);
            pb.redirectErrorStream(true);
            Process process = pb.start();

            File inputFile = new File(backupPath);
            try (FileInputStream fis = new FileInputStream(inputFile)) {
                process.getOutputStream().transferFrom(fis);
            }

            process.waitFor(60, TimeUnit.SECONDS);
        } catch (IOException | InterruptedException e) {
            e.printStackTrace();
        }
    }
}