How to Restore backup file(mysql) with java?

Question

I have a java project and placed sql file(backup) in this project.
how to Restore this file inside library to mysql with java(Restore of jar file)?

Maybe this can help you: stackoverflow.com/questions/8437240/… — HectorLector
– HectorLector, Commented Feb 13, 2012 at 22:37

davidethell · Accepted Answer · 2012-02-13 20:02:04Z

1

Is this against a remote server? If you are not opposed to combining Java with the MySQL command line client then you can just do:

Runtime.getRuntime().exec("/usr/bin/mysql <your connection options> < your_sql_backup.sql");

If you want it all native Java then you'll end up needing to parse your sql backup and execute the queries through JDBC.

answered Feb 13, 2012 at 20:02

davidethell

12.1k6 gold badges47 silver badges67 bronze badges

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

Comments

AlexR · Accepted Answer · 2012-02-13 20:05:28Z

0

Run mysql -uUSERNAME -pPASWORD SCHEMA <yourfile.sql. You can use either Runtime.getRuntime().exec() or ProcessBuilder to execute external program.

The mysql command requires redirect to restore data. You can either create shell script/batch file (depending on your operating system) and run it from java or run command line like cmd /c mysql... or /bin/sh mysql directly from java application (again, depending on your OS)

answered Feb 13, 2012 at 20:05

AlexR

116k16 gold badges137 silver badges216 bronze badges

Collectives™ on Stack Overflow

How to Restore backup file(mysql) with java?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related