How to create mysql dump with Java on Linux system?

Question

i have to make backups of mysql database in my application.

I run the command in Windows and works nice. This is the command:

String executeCmd = mysqldumppath +" -u " + dbUserName + " -p" + dbPassword + " --add-drop-database -B " + dbName + " -r " + filePath;
Runtime.getRuntime().exec(executeCmd);

When i try this command on my linux server, i need to put a sudo password. How i pass password in the command line?

I had read many solutions but no success.

Are you running your java code from the command line? NOT the mySQL command. I mean java MyClass. — MadConan
– MadConan, Commented Jun 19, 2015 at 17:16

Piper McCorkle · Accepted Answer · 2015-06-19 17:08:48Z

2

Either run your Java program as root (with sudo) or pass the sudo password via stdin to sudo (very insecure, practically no secure way to implement this).

answered Jun 19, 2015 at 17:08

Piper McCorkle

1,08213 silver badges27 bronze badges

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

2 Comments

Vítor Nóbrega Over a year ago

I am using glassfish server wih war file deployed. Should i start glassfish with sudo command?

MadConan Over a year ago

@VítorNóbrega That information would be useful in your question.

Shawyeok · Accepted Answer · 2016-06-15 14:53:25Z

0

Why are you have to enter password when execute the mysqldump command use the glassfish user?

Because you just have the privilege that execute the command with a password. If you want to execute commands password-less, edit the /etc/sudoers file use visudo, put a line in the end(if you run the glassfish server use glassfish user), eg:

glassfish    ALL=(All)    NOPASSWD: mysqldumppath

You can also copy the line into a file and put it to the /etc/sudoers.d directory. Now, try execute the command use sudo again! Good luck! :-)

edited Jun 15, 2016 at 14:53

answered Jun 21, 2015 at 17:11

Shawyeok

1,2381 gold badge10 silver badges15 bronze badges

Collectives™ on Stack Overflow

How to create mysql dump with Java on Linux system?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related