How to copy MySQL database with java jar file

Question

my MYSQL DB can find in wamp\bin\mysql\mysql5.6.12\data path called cament_factory_db I copy that cament_factory_db folder to my netbeans project folder and changed the connection string jdbc:mysql://localhost:3306/cement_factory_db to jdbc:mysql://cement_factory_db re-compiled it. then compiler says

Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. Communications link failure

I want to create portable jar file with MYSQL data base? How does it do ?

The last part of JDBC URL is database name, not directory name. You must create databases using mysql commands, not by filesystem operations. — Leos Literak
– Leos Literak, Commented Mar 16, 2014 at 7:22
I create DB using PHPmyAdmin. then bin\data folder has data base based on file system like this is there any essay way to do this without typing cmd prompt ? — Roledenez
– Roledenez, Commented Mar 16, 2014 at 7:28

Pantelis Natsiavas · Accepted Answer · 2014-03-16 09:26:49Z

4

MySQL is not a file based database management system. It always requires a MySQL server to which the application would connect to. If you want to distribute an application which uses a database, you have two options.

Use a flat file based database. Then you could add the flat file to your application's distribution. Examples of such database management systems are (SQL Server Compact, SQLite, HSQLDB,H2 and Derby).
Use a database server architecture. This means that your distributed applications would not transfer the database with them, but they would connect to your database hosted somewhere over the internet. As a server database, you could use MySQL which follows this architecture.

If I get it right, the first approach would be more suitable for you.

Hope I helped!

answered Mar 16, 2014 at 9:26

Pantelis Natsiavas

5,3875 gold badges24 silver badges40 bronze badges

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

Comments

Roledenez · Accepted Answer · 2014-03-16 09:09:41Z

2

Finally I found the answer. if I use mysql database, I have to install it in every computer that my program run. otherwise I have to use embedded database like sqlite that can embedded with jar file

answered Mar 16, 2014 at 9:09

Roledenez

7614 gold badges17 silver badges44 bronze badges

Collectives™ on Stack Overflow

How to copy MySQL database with java jar file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related