mysql无法备份_MySql备份无法正常工作

Backup:

/******************************************************/

//Database Properties

/******************************************************/

String dbName = “dbName”;

String dbUser = “dbUser”;

String dbPass = “dbPass”;

/***********************************************************/

// Execute Shell Command

/***********************************************************/

String executeCmd = “”;

executeCmd = “mysqldump -u “+dbUser+” -p”+dbPass+” “+dbName+” -r backup.sql”;

}

Process runtimeProcess =Runtime.getRuntime().exec(executeCmd);

int processComplete = runtimeProcess.waitFor();

if(processComplete == 0){

out.println(“Backup taken successfully”);

} else {

out.println(“Could not take mysql backup”);

}

Restore:

/******************************************************/

//Database Properties

/******************************************************/

String dbName = “dbName”;

String dbUser = “dbUser”;

String dbPass = “dbPass”;

/***********************************************************/

// Execute Shell Command

/***********************************************************/

String executeCmd = “”;

executeCmd = new String[]{“/bin/sh”, “-c”, “mysql -u” + dbUser+ ” -p”+dbPass+” ” + dbName+ ” < backup.sql” };

}

Process runtimeProcess =Runtime.getRuntime().exec(executeCmd);

int processComplete = runtimeProcess.waitFor();

if(processComplete == 0){

out.println(“success”);

} else {

out.println(“restore failure”);

}