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