How to restore a MySQL dump file by Java?

Question

I backup my MySQL databse to a specific folder, say, d:\backup\ by a webpage. The backup goes without issues, but I am not able to restore it using the following command.

Runtime.getRuntime().exec("mysql -u root -p root sgapp <  D:/backup/bkup.sql");

What is the cause and how can I solve this?

Read this: javaworld.com/jw-12-2000/jw-1229-traps.html All 4 pages. — BalusC
– BalusC, Commented Mar 14, 2011 at 11:48

Nishant · Accepted Answer · 2011-03-14 04:39:18Z

1

 Runtime.getRuntime().exec("mysql -u USERNAME -pPASSWORD DBNAME <  D:/backup/bkup.sql");

Mind the lack of gap between -p and password string.

answered Mar 14, 2011 at 4:39

Nishant

56.1k13 gold badges119 silver badges131 bronze badges

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

4 Comments

Nishant Over a year ago

@pheonix4eva -- that was an obvious error. But, I think you should also include the stack trace of the error that you getting when you try from JSP. That will help to dig any deeper.

pheonix4eva Over a year ago

i tried try { runtime.exec("mysql -uroot -proot dd < D:/backup/bkup.sql"); } catch (IOException ex) { ex.printStackTrace(); } but i get no error

Stephen C Over a year ago

@Nishant - big mistake - if you are going to use redirection, you have to exec via cmd.exe ... I think.

Nishant Over a year ago

@Stephen C I was wondering the same, but can't do a quick POC right now. :) our jobs.

animuson · Accepted Answer · 2011-11-19 23:34:40Z

1

That works for me:

 Runtime.getRuntime().exec("cmd /c start mysqldump -u root -ptestpsw workone -rscript_name.sql");

use -rfilename.sql instead of redirect < . Maybe it works for you too.

edited Nov 19, 2011 at 23:34

animuson♦

54.9k28 gold badges142 silver badges150 bronze badges

answered Jul 2, 2011 at 22:02

ionut

111 bronze badge

Collectives™ on Stack Overflow

How to restore a MySQL dump file by Java?

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related