Sign in to follow this  
spaceJockey123

Question about program with a backend database

Recommended Posts

Let's say I write a program in C++ - a system for a videoshop. I write the program and the backend database using mySQL.

Now, if I wanted to install this on another machine does MySQL need to be installed?

My other question is this... when you create tables with data in MySQL, where on earth does this get stored on the machine? I'm working on a macbook and confuzzled!

Share this post


Link to post
Share on other sites
Quote:
Now, if I wanted to install this on another machine does MySQL need to be installed?
The program needs to connect to some, properly set up, MySQL database. If you aren't connecting to a remote database, then MySQL must be installed on the local machine.

Quote:
when you create tables with data in MySQL, where on earth does this get stored on the machine?
Files on the machine. They are managed by MySQL.

Share this post


Link to post
Share on other sites
Yes, MySQL also needs to be installed.

I think SQLite can built into your exe and just use one flat file for database storage, thus making a nicer alternative if you want to simplify installation process.

MySQL stores databases in files placed wherever you told it to place itself when installing MySQL. It has it's own structure, loosely speaking, one table is stored in one or more files.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this