How to restore a mysql dump file using java jdbc? [duplicate]

Question

Is there any way to restore a .sql which is a backup of a database into a newly created database using java jdbc?

"mysql -u root -password stdtravels1 < C:/Users/j/Desktop/std.sql"

I already tried the above code. still with no sucess

mysql is the command. not query

CSK
– CSK

2016-09-08 14:48:35 +00:00
Commented Sep 8, 2016 at 14:48 — CSK
– CSK, Commented Sep 8, 2016 at 14:48

Rishi · Accepted Answer · 2016-09-07 18:17:21Z

1

Runtime.getRuntime().exec("mysql -u username -password dbName  xxx.sql")

Using this you could restore.

answered Sep 7, 2016 at 18:17

Rishi

1,2038 silver badges13 bronze badges

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

2 Comments

Janaka Bandara Over a year ago

Runtime.getRuntime().exec("cmd /c start mysqldump -u root -password stdtravels1 < C:/Users/j/Desktop/std.sql"); this is how I did it? but does not work.... anything wrong in here?

Rishi Over a year ago

Try to look at this : stackoverflow.com/questions/4755552/…

Collectives™ on Stack Overflow

How to restore a mysql dump file using java jdbc? [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related