java代码实现在linux服务器上mysql数据库备份以及恢复

1、备份

public Object insertDataBase(DataBaseBean dataBaseBean) {

long count = System.currentTimeMillis();

int num = 1;

// 测试备份 /usr/bin/mysqldump为数据库的路径以及备份命令 -u用户名 -p密码  数据库名称database

String command1 = "/usr/bin/mysqldump -uroot -p123456 database";// 参数依次是IP、账号、密码、数据库名

 

String fileName = TimeUtils.getCurrentTime("yyyyMMddHHmmss") + NumberUtils.createRandom(true, 6) + ".sql";

#img_path linux服务器路径 

String savePath1 = img_path + "/database/" + fileName;

 

String b1 = DataBaseUtils.backup(command1, savePath1);

if ("1".equals(b1.substring(0, 1))) {

dataBaseBean.setSize(b1.substring(1));

dataBaseBean.setData_name(fileName);

dataBaseBean.setUrl(img_path + "/database/" + fileName);

dataBaseBean.setVersion("V"+count);

num = settingDaoC.insertDataBase(dataBaseBean);

if (num <= 0) {

throw new AppException("备份失败");

}

} else {

throw new AppException("备份失败");

}

 

return num;

}

 

2、恢复

public Object updateDataBase(DataBaseBean dataBaseBean) {

String command2 = "/usr/bin/mysql -uroot -p123456 --default-character-set=utf8 database";

Stri