user1154781 user1154781 - 1 year ago 75
Java Question

Back up mysql database from java program

I'm trying to backup my database from a Java application. Currently, I'm using xampp as a

for database. I tried these codes in my program, but when I execute these codes my program goes on waiting state. When I execute the same code from command line it ask a password and after giving a password back up file
is created successfully.
The code I'm using is:

String executeCmd = "C:\\xampp\\mysql\\bin\\mysqldump.exe -u root -p db1 -r D:/mine/backup.sql";

Java code:

Process runtimeProcess;
try {

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

int processComplete = runtimeProcess.waitFor();

if (processComplete == 0) {
System.out.println("Backup created successfully");
return true;
} else {
System.out.println("Could not create the backup");
} catch (Exception ex) {

Answer Source

Try using the command with password in it, like

String executeCmd = "C:\\xampp\\mysql\\bin\\mysqldump.exe -u root -pYOUR_DB_PASSWORD db1 -r D:/mine/backup.sql";

Mind the NO SPACE between -p and the DATABASE PASSWORD.

Edit1: (from comment)

To resotre your database you need to execute

mysql -u root -pPASSWORD db1 < /full/qualified/path/to/backup.sql

Edit2: (improvements)

You may also want to try some of the cool options like

mysqldump --user MYSQL_USER --password=MYSQL_PASSWORD --add-locks --flush-privileges \
--add-drop-table --complete-insert --extended-insert --single-transaction \

Refer here.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download