How to execute mysql command from groovy/java on windows

Question

I'm trying to import mysql databases from a file in a groovy script.

I'm trying like this:

command = """mysql -f -u ${settings.dbUser} -p${settings.dbPassword} -h localhost --default-character-set=latin1 ${settings.dbName} < "$tableDefinitions" """

commandArray[0] = "cmd"
commandArray[1] = "/c"
commandArray[2] = "start " + command

def Process process = new ProcessBuilder(commandArray)
                                    .directory(workingDir)
                                    .redirectErrorStream(true)
                                    .start()

If I output the command on the console it looks like this:

mysql -f -u root -pHelloStackOverflow -h localhost --default-character-set=latin1 test123 < "C:\Users\XXX\git\YYY\commons\sqlData\table.sql"

However if I do this all that happens is a mysql console window opens, and I'm already logged into it, but nothing was imported. If I execute the same command on the console it works.

I tried calling mysql directly instead of cmd, but then I get the error "cannot run command", "system can't find the specified file"

How can I import like that without the mysql console opening?

tim_yates · Accepted Answer · 2014-04-25 10:16:57Z

1

try:

def command = [ 'cmd',
                '/c',
                'mysql -f -u ${settings.dbUser} -p${settings.dbPassword} -h localhost --default-character-set=latin1 ${settings.dbName}' ]

def process = command.execute()
proc << tableDefinitions

def out = new StringBuilder()
def err = new StringBuilder()
proc.waitForProcessOutput(out, err)
if (out) println "out:\n$out"
if (err) println "err:\n$err"

answered Apr 25, 2014 at 10:16

tim_yates

172k29 gold badges359 silver badges354 bronze badges

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

5 Comments

tim_yates Over a year ago

@Opal I believe so, as it is now a single parameter to cmd -c

Fels Over a year ago

It solved the problem with the extra console, and now I get an output if an error occurs. But if I add the file through the pipe (process << tableDefinitions) it just hangs. But thanks so far, I'll accept the answer.

tim_yates Over a year ago

@Fels is tableDefinitions a String containing SQL?

tim_yates Over a year ago

Ahhh... try proc << tableDefinitions.text

Fels Over a year ago

I already tried.. The command IS executed, I can see the mysql table, waitForProcessOutput just never returns. And groovy was indeed smart enough to use .text :)

Opal · Accepted Answer · 2014-04-25 10:12:04Z

1

You need to create a list and pass every single argument separately using cmd /c add the beginning. start is not required AFAIK.

It would be:

['mysql','-f','u'] // and so on.. then call execute()

answered Apr 25, 2014 at 10:12

Opal

85.6k29 gold badges201 silver badges220 bronze badges

1 Comment

tim_yates Over a year ago

I think it's the redirect causing the issue

Collectives™ on Stack Overflow

How to execute mysql command from groovy/java on windows

2 Answers 2

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related