package com.ecarvalues.util.general;
import java.io.IOException;
/**
*
* @author jeff
*
*/
public class MySQLManager {
public static boolean backup(String username,String password,String dbName,String mysqldumpPath, String backupPath) {
boolean status = false;
String command = mysqldumpPath + "/mysqldump -u " + username + " -p" + password + " " + dbName + " -r " + backupPath;
try {
Process runtimeProcess = Runtime.getRuntime().exec(command);
int processComplete = runtimeProcess.waitFor();
if (processComplete == 0) {
System.out.println("MySQLManager: Backup database Successfull");
status = true;
} else {
System.out.println("MySQLManager: Backup database Failure!");
}
} catch (IOException ioe) {
System.out.println("Exception IO");
ioe.printStackTrace();
} catch (Exception e) {
System.out.println("Exception");
e.printStackTrace();
}
return status;
}
public static boolean backup1(String username,String password,String dbName,String mysqldumpPath, String backupPath) {
boolean status = false;
String[] command = new String[]{"/usr/local/mysql/bin/mysqldump", "-u" + username, "-p" + password,"transactions", "-r"+backupPath };
try {
Process runtimeProcess = Runtime.getRuntime().exec(command);
int processComplete = runtimeProcess.waitFor();
if (processComplete == 0) {
System.out.println("MySQLManager:Restore database Successfull");
status = true;
} else {
System.out.println("MySQLManager:Restore database Failure");
}
} catch (IOException ioe) {
System.out.println("Exception IO");
ioe.printStackTrace();
} catch (Exception e) {
System.out.println("Exception");
e.printStackTrace();
}
return status;
}
public static boolean restore(String username,String password,String filePath){
boolean status = false;
String[] command = new String[]{"/usr/local/mysql/bin/mysql", "exp_transactions", "-u" + username, "-p" + password, "-e", " source "+filePath };
try {
Process runtimeProcess = Runtime.getRuntime().exec(command);
int processComplete = runtimeProcess.waitFor();
if (processComplete == 0) {
System.out.println("MySQLManager:Restore database Successfull");
status = true;
} else {
System.out.println("MySQLManager:Restore database Failure");
}
} catch (IOException ioe) {
System.out.println("Exception IO");
ioe.printStackTrace();
} catch (Exception e) {
System.out.println("Exception");
e.printStackTrace();
}
return status;
}
//for testing
public static void main(String args[]){
//String backupName = "D:/DatabaseBackup/backupHvs.sql";
//MySQLManager.restore(backupName);
MySQLManager.backup1("root","123","transactions","/usr/local/mysql/bin","/Users/jeff/Movies/backup_20120419_101741.sql");
//MySQLManager.restore("root","123","/Users/jeff/Movies/backup_20120419_101741.sql");
}
}
linux下java备份还原mysql数据库
最新推荐文章于 2024-07-27 12:05:59 发布