I have programmed with databases for many years, but for the first time I am developing my own program that uses a database. In my laptop I just access the database in Java with the database URL. I understand that if I am going to install the program in another computer, I will have to install the database in some directory. I know how to install the database by hand, but how do I do it with a self installing zip file?

Your help will be greatly appreciated,

Alejandro Barrero

At first, welcome on this forum Alejandro.

Second: what database are you talking about, and on which system ?
Installing from a zip file don't means much, and can be almost anything (except Oracle or ms sql server, as I'm pretty sure those are not distributed in zip files).

So, which database are you trying to install, on which kind of server ?

Thanks for your answer Thierry. I am not trying to install the database from a zip file. I want to create a self extracting zip file that will install my application and will also install the database. I would like to know the answer for all databases if there is one, but in particular, I am interested in MySQL.

Originally Posted by tripy

(except Oracle or ms sql server, as I'm pretty sure those are not distributed in zip files).

I can't speak to Oracle, since I haven't used it at this level ... but a zip file could be part of how a SQL Server database is deployed, at least in theory. The database server would have to already be installed, and up and running on the target server. You'd have to decompress the mdf/ldf files into the place you want them, and then attach the database using sql. There's a bit of complexity, mainly because one way the storage engine reduces I/O is to hold the files open [locked] the entire time it's running. And since it runs as a service, that's whenever the host machine is running.

I think MySql tends to be distributed through zip files more often, though?

Thank you very much.

Instead of distributing entire database as zip file, it would be far more better in my opinion if you just included database schema and required database data as csv files and reconstructed the database the first time user ran the program. Also, instead of hardcoding database name in the program, make it so that the user can specify the database name to be used by your application (prefereably a table name prefix as well, so that multiple instances of your application can be run by using single database).