Solved

MySQL as a user database vs. Server

Posted on 2016-07-18
9
54 Views
Last Modified: 2016-07-19
Hi Experts;
I am new to MySQL and need assistance.
We want to replace our current MS Access .mdb with a MySQL local database.
I am not sure which/where to find a 'client-type' MySQL installer.
Our server is running MySQL and I will sync to it to keep the local MySQL up to date.
All our customers who will be using this d/b are running Windows.
Can someone point me to an installer that will work for this setup? Internet searches show 'server' etc; but we don't need the customers to be server - just use a local copy of a MySQL database.

Thank you.
0
Comment
Question by:klheitz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
9 Comments
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 41718160
>> 'client-type' MySQL installer.
try download and install the MySQL Workbench
https://dev.mysql.com/downloads/workbench/
0
 
LVL 51

Assisted Solution

by:Ryan Chong
Ryan Chong earned 200 total points
ID: 41718162
>>but we don't need the customers to be server - just use a local copy of a MySQL database.

you can download and install the MySQL Community Server, it serves and manage to run on a single machine.
https://dev.mysql.com/downloads/mysql/
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41718261
MySQL itself is a database server, it does not have a 'front end' built-in like Access does.  MySQL Workbench is a 'front end' for MySQL but it is a separate program.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:klheitz
ID: 41720027
Thank you Ryan and Dave.

So maybe I'm approaching our MSAccess d/b replacement in the wrong way.

Here's a little background:
We have a program installed many user systems. That program uses data from an MSAccess d/b (also on user's system) to crunch data, generate reports, set configuration settings etc.
Daily the data for MSAccess is updated via FTP and a proprietary 'import' method.

Our directive is remove this import step. It takes too long and is error prone.

We have all our master data on a SQL Server and the user's program has the ability to access those SQL records instead of their local MSAccess .mdb; but users often don't have internet and still need to be able to run the program using their local version.

Our thought was to replace the MSAccess with something closer to SQL so we use many of the same select calls (we're aware there are some differences).
Also, our data is reaching the MSAccess d/b size limit.

LocalDB looked like a great option, but we want larger size. This let us to MySQL.

Sorry for the long story - here's the up-shot. Is MySQL (workbench or Community Server) even going to work for this scenario?

I appreciate your patience. As I mentioned ... new-bie.
Thanks
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41720060
MySQl can be 'made' to work but you have to 'make' it do it.  If you're using SQL statements with the Access database, it shouldn't be too difficult.  You will also have to write a new import method.

Another alternative is MS SQLExpress.  It's free and the limits are probably far above the amount of data you're using and storing.  I think that no matter which one you choose, you will find it takes more to install and configure them than it did with Access.
0
 

Author Comment

by:klheitz
ID: 41720066
Thanks Dave!
I'll look into MS SQLExpress.
*If* we decide on MySQL; would I use workbench, or some other MySql product?
0
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 300 total points
ID: 41720069
You would use the MySQL Community version for the database server.  MySQL Workbench is a utility program, not a database program.
0
 

Author Closing Comment

by:klheitz
ID: 41720070
Thank you both! I appreciate your help & advice very much.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41720074
You're welcome, glad to help.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question