java中备份mysql数据库的通用方法，支持win和linux-优快云博客

本文介绍了一种使用Java进行MySQL数据库备份与还原的方法。通过Java程序调用mysqldump命令实现数据库备份，并将备份文件保存为指定路径下的文件。同时，提供了数据库还原的功能，从备份文件中恢复数据到指定的数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

备份:

public static void backup() {
try {
Runtime rt = Runtime.getRuntime();

Process child = rt.exec("mysqldump -u用户名 -p密码 -R -c --set-charset=utf8 数据库名");

InputStream in = child.getInputStream();

InputStreamReader xx = new InputStreamReader(in, "utf8");

String inStr;
StringBuffer sb = new StringBuffer("");
String outStr;

BufferedReader br = new BufferedReader(xx);
while ((inStr = br.readLine()) != null) {
sb.append(inStr + "\r\n");
}
outStr = sb.toString();

FileOutputStream fout = new FileOutputStream("备份的文件路径名");
OutputStreamWriter writer = new OutputStreamWriter(fout, "utf8");
writer.write(outStr);
writer.flush();

in.close();
xx.close();
br.close();
writer.close();
fout.close();
} catch (Exception e) {
e.printStackTrace();
}

}

还原:
public static void load() {
try {
String fPath = "备份的文件路径名";
Runtime rt = Runtime.getRuntime();

Process child = rt.exec("mysql -u用户名 -p密码数据库名");
OutputStream out = child.getOutputStream();
String inStr;
StringBuffer sb = new StringBuffer("");
String outStr;
BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream(fPath), "utf8"));
while ((inStr = br.readLine()) != null) {
sb.append(inStr + "\r\n");
}
outStr = sb.toString();

OutputStreamWriter writer = new OutputStreamWriter(out, "utf8");
writer.write(outStr);
writer.flush();

out.close();
br.close();
writer.close();
} catch (Exception e) {
e.printStackTrace();
}
}