java实现mysql还原_java实现mysql数据库的备份和还原

备份：

public class BackUpDataServiceImpl implements BackUpDataService {

public void dbBackUp() throws IOException {

String backPath="D:/backUp/backup.sql";

String root="root";

String pwd="root";

String dbName="数据库名称";

File fileSql = new File(backPath);

//创建备份sql文件

if (!fileSql.exists()){

fileSql.createNewFile();

}

StringBuffer sb = new StringBuffer();

sb.append("mysqldump");

sb.append(" -h127.0.0.1");

sb.append(" -u"+root);

sb.append(" -p"+pwd);

sb.append(" "+dbName+" >");

sb.append(backPath);

System.out.println("cmd命令为："+sb.toString());

Runtime runtime = Runtime.getRuntime();

Process process = runtime.exec("cmd /c"+sb.toString());

System.out.println("备份成功!");

}

还原

public void dbRestore(){

String filePath = "D:/supplierBackUp/backup.sql";

String root="root";

String pwd="root";

String dbName="数据库名称";

StringBuilder sb = new StringBuilder();

sb.append("mysql");

sb.append(" -h127.0.0.1");

sb.append(" -u"+root);

sb.append(" -p"+pwd);

sb.append(" "+dbName+"