May I humbly suggest getting managers to read it also? How many of
those folks only want to hear that "Its done" and they don't know or
care what it really takes.
-John C.
-----Original Message-----
From: SGreen@stripped [mailto:SGreen@stripped]
Sent: Friday, March 17, 2006 12:53 PM
To: Daniel da Veiga
Cc: MySQL Win32 List
Subject: Re: Please help
Daniel,
Yes, you have permission to quote this. In fact, I grant everyone
permission to quote this in whole or in part. If you find it useful,
good.
If not, please ignore.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Daniel da Veiga" <danieldaveiga@stripped> wrote on 03/16/2006 12:50:15
PM:
> On 3/16/06, SGreen@stripped <SGreen@stripped> wrote:
> > OK, Matt,
> >
> > Time to step back and understand the nature of what you are trying
> > to
set
> > up. Also time to help you to understand how MySQL allows you to
configure
> > their products.
> >
> > You are trying to set up a database server. This means there are two
> > components to make this work. Part one is a program running
> > somewhere
that
> > takes requests and responds with answers. To do this is manages
several
> > files containing data in several places on one or more drives. This
part
> > is the server. Part two is the client. The client makes requests
> > to
the
> > server and handles the responses. There are several types of
> > clients available to work with MySQL servers. Most of them are
> > designed for
human
> > interaction. I assume you are using one to test your setup (though
> > you haven't said which one you are using)
> >
> > =============
> > PART ONE -- setting up the server. You may or may not have
accomplished
> > any or all of these steps in your previous attempts (we don't know
because
> > you left that information out of your initial posts).
> >
> > A) FIND THE DOCUMENTATION - How about I just give you this one for
free:
> > http://dev.mysql.com/doc/refman/5.0/en/installing.html
> > B) READ THE DOCUMENTATION - this is an important step overlooked by
many
> > new administrators. You should try an entire mental "dry run"
> > installation by reading through the documentation so that you are at
least
> > partially familiar with the process.
> > C) Locate a copy of the server suitable for your operating system --
there
> > are pre-compiled binaries (another term for ready-to-use versions)
> > of
the
> > server available for the most popular platforms.
> > D) Install using a method appropriate for your OS. For windows, you
have 3
> > choices: 1) an unautomated ZIP file (my recommendation), 2) a
> > self-extracting exe, and 3) an MSI file. Many new users pick the
MSI
> > because they think it will be less hassle. For the over 80% where it
works
> > correctly, this does indeed turn out to be a very hands-off method
> > of installing the server. I encourage everyone to use the
> > unautomated
ZIP.
> > It's not that hard to follow along and you get a better
> > understanding
of
> > what you are doing and what may be wrong later.
> > E) configure your installation - edit the config file (on windows it
is
> > called "my.ini") so that when the server is started it knows several
very
> > important bits of information: where you put the data files, what
port it
> > needs to listen to for incoming requests, and anything else about
> > any option you want to either turn on, turn off, or modify. Details
> > are in
the
> > reading. Most installation packages come with various examples of
config
> > files, each example roughly tuned to different sizes of
> > installations. Make sure you put this file where the server program
> > can find it
(again
> > details are in the reading and vary by platform)
> >
> > PART TWO - testing the installation (I think this is where you think
you
> > are)
> >
> > a) complete part one - this is critical to the success of part two
> >
> > b) make sure that the server installed in part one is actually
running. On
> > windows systems you can either start the server every time you want
> > to
use
> > it or it can be managed for you as a "service". Services are
unautomated
> > programs that perform a variety of functions. Services are started
> > as
the
> > machine boots and are shutdown as it turns off. Services can also be
> > manually controlled and configured if the need arises. In a general
sense
> > of the terms a windows service is equivalent to a unix (linux, etc)
> > daemon. Frequently you will see servers (database servers, web
servers,
> > ftp servers, remote access servers, etc) just called daemons as it
applies
> > to any computing platform.
> >
> > Refer to the manual for various ways of testing troubleshooting an
> > installation:
> > http://dev.mysql.com/doc/refman/5.0/en/post-installation.html
> > http://dev.mysql.com/doc/refman/5.0/en/windows-testing.html
> > http://dev.mysql.com/doc/refman/5.0/en/windows-troubleshooting.htm
> >
> > c) start your client in such a way that it knows where the server is
> > (which socket or address/port combination) , which mysql you want to
use
> > to make this connection (not which OS user, which database user),
> > and
the
> > password needed to authenticate the account you are using. A
> > typical command would be (assuming you were already in the folder
> > where
mysql.exe
> > resides) :
> >
> > mysql -u root
> >
> > d) send various commands to the server to test that it is responding
with
> > reasonable information - what you can do varies by your level of
> > experience.
> >
> > ===================
> >
> >
> > You have left out a LOT of details of what you have and haven't
> > done. Without more history to your problem, it's very difficult to
> > diagnose
its
> > cause. Should I come to you some day (in your role as systems
engineer)
> > and say "My computer is beeping at me. Help me make it stop" ? You
would
> > need to know what I was doing when the beeping started and what I
> > have tried to do to make it stop correct? Same with us. The more
information
> > you can give us the easier it will be to get you operational.
> >
> > Shawn Green
> > Database Administrator
> > Unimin Corporation - Spruce Pine
> >
>
> Hey Shawn, can I get permission to use this email as a RTFineM for new
> MySQL users? I just couldn't put the right words the way you did... I
> guess it is at least 50% of the initial install problems solved...
>
> >
> > Matt Carolan <mpcarola@stripped> wrote on 03/16/2006 11:31:04 AM:
> >
> > > No it's not I can't get it to start. I have it installed on the D
> > > Drive and it won't start their. When I reinstall it on the C drive
> > > it starts but when I remove it and reinstall it on the D drive it
> > > keeps failing. I have totally cleaned up all directories and the
> > > registy before I reinstall but I just can't seem to get it to run.
> > > I need to get this on my drive because that is where I have the
> > > space allocated for the database.
> > >
> > > Thanks,
> > >
>
> Mathew, as I explained before, the installer is for MOST common
> installs, yours is not that common since you'll use a different setup
> from the "defaults". Follow Shawn's notes on installing and come back
> after you had read, understand and used the docs to do your install.
> If the error persists, post back.
>
> > > Matthew P. Carolan
> > > IBM Certified Professional
> > > Enterprise Systems Management Engineering
> > > Operations Infrastructure Delivery - IBM (OID)
> > > wk 602-537-0510
> > > e-mail: mpcarola@stripped
> > >
> > <previous responses clipped>
> >
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END
> GEEK CODE BLOCK------
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=1
>
