Back up mysql database from java program

Question

I'm trying to backup my database from a Java application. Currently, I'm using xampp as a localhost 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 backup.sql 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) {
        ex.printStackTrace();
    }

Nishant · Accepted Answer · 2012-08-09 05:02:53Z

2

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 \
--database DB_TO_BACKUP > FILENAME_FOR_SQL_STATEMENTS

Refer here.

edited Aug 9, 2012 at 5:02

answered Aug 9, 2012 at 4:45

Nishant

56.1k13 gold badges119 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

efficacy Over a year ago

what sud i write if the database password is ""(null).

Nishant Over a year ago

@user1154781 -- it ask a password and after giving a password back up file backup.sql is created successfully. -- I thought you have a password. If there is no password, I think, you should remove -p option from the executeCmd

efficacy Over a year ago

Hey thanx it worked and what if i had to restore this file as database in my application.

Nishant Over a year ago

@user1154781 glad it worked. If this answer solved your problem, please mark it as answered by clicking on the up-tick next to this answer. See here how. If you liked the answer, you may also up-vote by clicking on up arrow next to the answer.

efficacy Over a year ago

I'm just a beginner so voting is forbidden to me..surely i will in near future now can u tell me how can i restore the saved backup.sql file

|

Collectives™ on Stack Overflow

Back up mysql database from java program

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related