DB deployment & installation

[thesti]

hello,

i'm planning to create an application. there are some software out there that can be used to automate the installation process of an application. but the application comes with a mysql database.

i can include mysql in the installation process along with the application. but then how can i setup the database?

the query such as the create database, create user, give permission, create tables along with the insert records.

Thank you.

[Atli]

Hey.

You would have to create a script, as a part of the installation process, that logs into the newly installed MySQL server as root and executes the statements needed to create the database for you application.

This could be done in anything from a small C application to a shell script. Your choice completely.

However, there are probably other database system more appropriate for applications like these. MySQL is a database server, after all. Have you explored systems like SQLite?

Also, in case this is not a open-source/free application...
To ship MySQL as a part of a commercial application, you need to buy a commercial MySQL license. The open-source GPL license, which the free version of MySQL is licensed under, does not cover non-free applications.
(See http://www.mysql.com/about/legal/licensing/oem/)

[thesti]

ah.. Thank you for your information. that's what i don't know. i have little information about licensing, as i'm not tought about that in college.

as this is a low budget project, i prefer a free distribution... i see that SQLite is free for any purpose.

but since this application will be a multiuser app, with each user running an instance on his desktop, and there should be only one database, so the data are synchronize to all of them.
i think i must come with a client/server database engine

Thank you