List:MySQL on Win32« Previous MessageNext Message »
From:<John.Cook Date:March 17 2006 7:05pm
Subject:RE: Please help
View as plain text  
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
> 
Thread
Please helpMatt Carolan15 Mar
  • Re: Please helpPeter Monk16 Mar
    • Re: Please helpDaniel da Veiga16 Mar
  • Re: Please helpErich Dollansky16 Mar
    • Re: Please helpMatt Carolan16 Mar
      • Re: Please helpSGreen16 Mar
        • Re: Please helpDaniel da Veiga16 Mar
          • Re: Please helpSGreen17 Mar
Re: Please helpBernard LEFEUVRE16 Mar
RE: Please helpJohn.Cook17 Mar
  • Re: Please helpArmando17 Mar