/*
* 备份操作
*/
@Test
public void testMySqlBackup(){
String cmd = "cmd /c mysqldump -uroot -p111 cms";
BufferedReader br = null;
BufferedWriter bw = null;
try {
Process process = Runtime.getRuntime().exec(cmd);
br = new BufferedReader(new InputStreamReader(process.getInputStream(),"UTF-8"));
bw = new BufferedWriter(new FileWriter("F:\\SpingSourceTools\\cmsworkspace\\cms\\WebContent\\sql\\cms.sql"));
String str = null;
while((str=br.readLine())!= null){
bw.write(str);
bw.newLine();
}
} catch (IOException e) {
e.printStackTrace();
}finally{
try {
if(br!=null) br.close();
if(bw!=null) bw.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
/*
* 恢复操作
*/
@Test
public void testResume(){
String cmd = "cmd /c mysql -uroot -p111 cms";
BufferedReader br = null;
BufferedWriter bw = null;
try {
Process process = Runtime.getRuntime().exec(cmd);
bw = new BufferedWriter(new OutputStreamWriter(process.getOutputStream(), "UTF-8"));
br = new BufferedReader(new FileReader("F:/SpingSourceTools/cmsworkspace/cms/WebContent/sql/cms.sql"));
String str = null;
while((str=br.readLine())!=null){
bw.write(str);
bw.newLine();
}
} catch (IOException e) {
e.printStackTrace();
}finally{
try {
if(br!=null) br.close();
if(bw!=null) bw.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
使用java进行mysql数据库的备份和恢复
最新推荐文章于 2024-05-08 17:33:03 发布