Execute mysql database import script from java on linux machine

Question

I want to execute database import from .sql file from java program. My program is working fine on windows. But I am facing problem on linux machine.

Code -

 try { ProcessBuilder builder = new ProcessBuilder("mysql -u root -p password db-name < db_script.sql"); builder.redirectErrorStream(true); Process pr = builder.start(); InputStream is = pr.getInputStream(); // Now read from it and write it to standard output. BufferedReader reader = new BufferedReader(new InputStreamReader(is)); String line = reader.readLine(); while (line != null) { System.out.println(line); line = reader.readLine(); } } catch (Exception e) { e.printStackTrace(); }

I am getting - java.io.IOException: Cannot run program "mysql -u root -p password db-name < db_script.sql": java.io.IOException: error=2, No such file or directory

The above command is working fine on linux terminal. Some one please advice me on this.

Thanks in advance

Maurice Perry · Accepted Answer · 2012-01-20 11:51:03Z

9

The < redirection is a shell thing. Try something like this:

ProcessBuilder builder = new ProcessBuilder("/bin/sh", "-c", "mysql -u root -p password db-name < b_script.sql");

UPDATE:

Otherwise, if you're using java 7+, you can do the redirection in java:

ProcessBuilder builder = new ProcessBuilder( "mysql", "-u", "root", "-p", "password", "db-name"); builder.redirectInput(ProcessBuilder.Redirect.from(new File("b_script.sql")));

edited Jan 20, 2012 at 11:51

answered Jan 20, 2012 at 9:50

Maurice Perry

32.8k9 gold badges72 silver badges97 bronze badges

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

4 Comments

mahesh Over a year ago

After trying above. I started getting "/bin/sh: Can't open mysql -u root -p password db-name < b_script.sql".

Maurice Perry Over a year ago

The -c was missing. Sorry about that.

mahesh Over a year ago

Thanks Maurice for reply. With updated command, it is not giving me error. But at the same database is not getting updated. Surprisingly, I am getting output as we get if type mysql help command on terminal. I don't know what i am missing.

mahesh Over a year ago

Thanks Maurice for your valuable help. The problem is resolved. I was using space between -p and password. There should be no space between password and -p option. Thanks a million.

Hemant Metalia · Accepted Answer · 2012-01-20 09:47:20Z

have you checked that your code is executed from proper dir??

that if your db_script.sql is inhome then you are running from home as

home>mysql -u root -p password db-name < db_script.sql

or provide full path of db_script.sql in the command

I tried by giving full path of .sql file also. But I think the issue does not seems with the file path. Thanks

Alex · Accepted Answer · 2013-11-12 08:05:46Z

A simple way to achieve it.

String DBUSERNAME = ""; String DBUSERPASSWORD = ""; String sqlfilename = ""; PrintWriter writer = new PrintWriter("tmp.dmp", "UTF-8"); writer.println("mysql --user " + DBUSERNAME + " --password=" + DBUSERPASSWORD + " < " + sqlfilename); writer.close(); runCommand("chmod 777 tmp.dmp"); runCommand("./tmp.dmp"); runCommand("rm tmp.dmp"); public static void runCommand(String command) throws IOException { String s = ""; Process p = Runtime.getRuntime().exec(command); BufferedReader stdInput = null; BufferedReader stdError = null; try { stdInput = new BufferedReader(new InputStreamReader(p.getInputStream())); stdError = new BufferedReader(new InputStreamReader(p.getErrorStream())); // read the output from the command while ((s = stdInput.readLine()) != null) { System.out.println(s); } // read any errors from the attempted command while ((s = stdError.readLine()) != null) { System.out.println(s); } } finally { if (stdInput != null) { stdInput.close(); } if (stdError != null) { stdError.close(); } } }

Collectives™ on Stack Overflow

Execute mysql database import script from java on linux machine

3 Answers 3

4 Comments

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

Comments

Related