How can I back up mysql database from java?

Question

How can I back up a MySQL database using a Java program?

Answer 1

execute mysqldumpfrom java code

Example:

Backup:

Runtime.getRuntime().exec("mysqldump -u USERNAME -pPASSWORD DBNAME > /path/to/location/backup.sql");

Recovery:

Runtime.getRuntime().exec("mysql -u USERNAME -pPASSWORD < /path/to/location/backup.sql");

Answer 2

Runtime.getRuntime().exec("mysqldump -uroot -psome_password database_name > /whereever/dump_todays_date.sql");

Answer 3

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");
}

Answer 4

?

:

mysql

Answer 5

,

http://www.programmingforums.org/thread19446.html