[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MySQL as a user database vs. Server

Posted on 2016-07-18
9
Medium Priority
?
74 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:k heitz
  • 4
  • 3
  • 2
9 Comments
 
LVL 54

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 54

Assisted Solution

by:Ryan Chong
Ryan Chong earned 800 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 84

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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:k heitz
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 84

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:k heitz
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 84

Accepted Solution

by:
Dave Baldwin earned 1200 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:k heitz
ID: 41720070
Thank you both! I appreciate your help & advice very much.
0
 
LVL 84

Expert Comment

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month19 days, 6 hours left to enroll

834 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