By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,830 Members | 1,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,830 IT Pros & Developers. It's quick & easy.

distributing MySQL

P: n/a
Hello
Recently changed from using Access to MySQL.
Looked at the online docs but could not find anything about the process of
distributing a database to customers.
Can anyone give me a general idea of what is required. I sort of did a test
by simply moving the database files to a different directory but was unable
to connect after that through my VB front end.

Also If anyone could point me in direction of links that show how to do
this. Im particularly interested to know what happens to user names and
passwords. Do they remain on my system or do they move with the database?

Also would I have to pay for a special licence to do this or just tell
customers to install their own versions of the server and if the latter how
would it recognise my database and the permissions I have created
Ian
Nov 1 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ian Davies wrote:
Hello
Recently changed from using Access to MySQL.
Looked at the online docs but could not find anything about the process of
distributing a database to customers.
Can anyone give me a general idea of what is required. I sort of did a
test by simply moving the database files to a different directory but was
unable to connect after that through my VB front end.

Also If anyone could point me in direction of links that show how to do
this. Im particularly interested to know what happens to user names and
passwords. Do they remain on my system or do they move with the database?

Also would I have to pay for a special licence to do this or just tell
customers to install their own versions of the server and if the latter
how would it recognise my database and the permissions I have created
Ian

Last thing first, no you don't have to pay for a special license. The
beauty of Open Source Database. Secondly, as to distribution of the
database; it depends. Are they working on a set of common data, or do they
just need the structure and are going to put in their own data. If the
latter, then check out mysqldump for dumping the file

Dec 23 '05 #2

P: n/a
Thanks for the reply

I will look into sqldump
But have written into my VB program lots of mysql commands that are run when
the the software is run for the first time. It took a long time but they
create a database if not already present, creates all tables and foreign
keys etc, populates with default data and creates all required users.
I think this is the best method if I need to distribute upgrades to either
the program or the database as I just distribute a single new front end
which automatically does any updating to tables, structure etc when run.
However, If you know of an alternative approach I m always open to better
solutions
Ian

"John Meyer" <jo**********@gmail.com> wrote in message
news:jp********************@comcast.com...
Ian Davies wrote:
Hello
Recently changed from using Access to MySQL.
Looked at the online docs but could not find anything about the process of distributing a database to customers.
Can anyone give me a general idea of what is required. I sort of did a
test by simply moving the database files to a different directory but was unable to connect after that through my VB front end.

Also If anyone could point me in direction of links that show how to do
this. Im particularly interested to know what happens to user names and
passwords. Do they remain on my system or do they move with the database?
Also would I have to pay for a special licence to do this or just tell
customers to install their own versions of the server and if the latter
how would it recognise my database and the permissions I have created
Ian

Last thing first, no you don't have to pay for a special license. The
beauty of Open Source Database. Secondly, as to distribution of the
database; it depends. Are they working on a set of common data, or do

they just need the structure and are going to put in their own data. If the
latter, then check out mysqldump for dumping the file

Dec 27 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.