Run MySQL without install it

Question

I have a java project. It use MySQL database transactions. I would run this java project in the another computer. I would making a setup. In this setup need to be import the .sql data file. But MySQL must be. And i don't would install MySQL in the another computer. I would put the MySQL server file in the setup.

How can i do?

Please [edit] your question to give more information. Will your users (the ones running your setup program) use their own MySQL servers to run your Java program? Will several users share the same MySQL server with each other? Will the MySQL server always be on a different machine from your Java program? — O. Jones, Feb 24 '17 at 13:50

score 1 · Answer 1 · edited May 23 '17 at 10:29

1

Instead to use localhost connection like this :

Connection connection = DriverManager.getConnection(
                    "jdbc:somedb://localhost/databasename", "username", "password");

You can use the @IP of the other computer or server for example 10.6.99.122, so this can solve your problem and not need to install or import your sql file in the other computers:

Connection connection = DriverManager.getConnection(
                    "jdbc:somedb://10.6.99.122/databasename", "username", "password");

EDIT

You can learn more about embedded database here Java, MySQL: Is there a way to embed a MySQL server with a Java program? and here Embedding mysql in java desktop application and also here

edited May 23 '17 at 10:29

Community

1
1

answered Feb 24 '17 at 13:37

Youcef LAIDANI

55,661
15
90
140

Is there another way? I don't woyld change the program code. – SOF JMP Feb 24 '17 at 13:41
if you are using mysql or any DBMS witch is not embedded database https://en.wikipedia.org/wiki/Embedded_database so i afraid that is not possible @SOFJMP – Youcef LAIDANI Feb 24 '17 at 13:45
Yes i use MySQL. @YCF_L – SOF JMP Feb 24 '17 at 13:47
@SOFJMP so you can't use backup or .sql without MySQL installation because it not provide an embedded database – Youcef LAIDANI Feb 24 '17 at 13:48

score 0 · Answer 2 · answered Feb 24 '17 at 13:43

0

You either use external connection and host your database to a web hosting, or if you don't need to share the data and the data is locally stored and generated by the user himself, then you can use sqlite file instead. Your question should explain more about the type of data and how will be used so that we give you the best solution.

answered Feb 24 '17 at 13:43

Mohamed Hassan

11
1
3

I don't would use sqlite. – SOF JMP Feb 24 '17 at 13:45

score 0 · Answer 3 · answered Feb 24 '17 at 14:06

If you hope your customers will run your Java program on their computers and connect it to their MySQL servers, you must put your database connection string into a Java properties file. You have no choice about this. You must allow your customers to set their own connection string values.

Connection strings are used to make new JDBC connections. They usually look something like this:

jdbc:mysql://mysql1.datacenter.example.com:3306/sofjmp?user=username&password=xxxxxsx

You can include the user's database username and password secrets in the connection string you store in the properties file. That gives your customers a way to specify their own database credentials.

Your setup program should include instructions for users about setting that connection string property. You can also include your .sql file with your table definitions in your setup program. You can instruct your customers to run the .sql file when they first set up your program.

Run MySQL without install it

3 Answers3