Solved

How to copy and install manually Mysql database on Windows?

Posted on 2016-08-16
5
26 Views
Last Modified: 2016-09-10
Hello,

I need the following scenario:

-I install MySql on a computer with the parameters I want  (on Windows)
-I create mysql users
-I create a database with tables and fill with data

When I finished the steps above I need to gather the minimum files of MySql which will run smoothly - without installing - on another computer.

So I will copy the respective directory with the mysql files on the target computer and use :
mysqld --install mysql
and NET START mysql so as to install and start it.

I intend to make my own Install application to do this.

The questions:
-What are the exact minimum files I need to gather for this?
-What should I be aware of?

Thank you
0
Comment
Question by:Member_2_7965240
  • 2
  • 2
5 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 41757715
you choose the "no install" package from here:
http://dev.mysql.com/doc/refman/5.7/en/windows-choosing-package.html
to get the mysql runnable on the target pc without "installing" it otherwise.
0
 
LVL 39

Assisted Solution

by:noci
noci earned 250 total points (awarded by participants)
ID: 41764442
mysql users & databases can be created as usual using the mysql client command.
and adding the users.

C> mysql    ( optional arguments if needed  for username, host etc. )
mysql> grant all on *.* to 'user' identified by 'password';
mysql> flush privileges;
mysql> create database blah;
mysql> use blah
mysql> create table blahblah (id ....... etc.);

Or restore a .sql backup file using that as input to mysql.
0
 

Author Comment

by:Member_2_7965240
ID: 41764905
Guy Hengel: I think you misunderstood me.

As I wrote I don't want to install a "no install" package on the client's computer.

1.I need to install MySql on my computer
2.Then I configure the databases, my.ini etc.
3.Then I need to create the no installation archive of the minimum files I need
This way my client would have the exact copy of my database without installation

Thank you.
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points (awarded by participants)
ID: 41764917
minimal: the mysql folder as is
if you configure the data folder to be somewhere else than within mysql, that folder also.
nothing else, nothing less
0
 
LVL 39

Expert Comment

by:noci
ID: 41792471
Copy as is vs. Copy from backup.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Roguekiller has no option of deleting 19 48
File Server Migration - Questions and advice 7 83
Slow SQL query 12 29
Update in Sql 7 12
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now