Wednesday, August 19, 2009

MYSQL DB Backup through java

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.InputStreamReader;
import java.util.Date;

public class DBBackupUtil {
public static boolean getData(String userName,String password,String dbName,String FileName) throws Exception {
boolean isCompleted=true;
FileWriter fstream=null;
BufferedWriter out=null;
BufferedReader in=null;
Process run=null;
try{
System.out.println("DBBackup Start time:"+new Date());
System.out.println("---Started--");
run = Runtime.getRuntime().exec("mysqldump -u"+userName+" -p"+password+" --database "+dbName+" --routines=1");
in= new BufferedReader(new InputStreamReader(run.getInputStream()));
String line = null;
fstream = new FileWriter(FileName);
out = new BufferedWriter(fstream);
while ((line = in.readLine()) != null) {
out.write(line+'\r');
}
out.close();
in.close();
System.out.println("---Completed--");
System.out.println("DBBackup Completed time:"+new Date());

}catch (Exception e) {
e.printStackTrace();
isCompleted =false;
}finally{
fstream=null;
out=null;
in=null;
}
return isCompleted;
}
public static void main(String[] args) {
try{
DBBackupUtil backup = new DBBackupUtil();

backup.getData("root","root","ams_cameltest2","C:\\back.sql");

}catch (Exception e) {
e.printStackTrace();
}
}
}

0 comments:

Post a Comment