List:MySQL on Win32« Previous MessageNext Message »
From:Jorge Bastos Date:March 17 2006 11:24pm
Subject:Fw: Please help
View as plain text  
I agree, it happens to me sometimes...

Jorge


----- Original Message ----- 
From: "Armando" <dijital@stripped>
To: <win32@stripped>
Sent: Friday, March 17, 2006 10:23 PM
Subject: Re: Please help


> Off topic, but I have to comment because I've seen it far too often. The 
> answer is, WAY too many. Non-technical managers usually don't know or care 
> about technical aspects. You're right, they just want to hear that "it's 
> done", most especially when deployment of a product or solution is 
> expected to bring an ROI (return on investment) to the organization. Try 
> explaining to the non-technical manager that a half-million dollars spent 
> on a solution wouldn't produce an ROI in the current fiscal year and watch 
> them hit the roof. That's when they turn on the I.T. people and blame them 
> for it not happening. Sometimes anyways.
>
> From a project perspective, I find the largest problem is that the 
> "business" managers often go and make product selections too often without 
> consulting with the I.T. department. They define their product 
> requirements, send to the providers and when one comes along with the 
> right price and the claim that they can meet most of if not all the 
> requirements, they go ahead and sign the deal.
>
> Then it's up to the I.T. folk to reinvent the wheel to make the product 
> work in their environment. It's a sad story, but I'm sure it happens very 
> often in the enterprise. Cheers.
>
> Armando
>
> John.Cook@stripped wrote:
>> 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
>>
>>
>
> -- 
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: 
> http://lists.mysql.com/win32?unsub=1
>
> 

Thread
Fw: Please helpJorge Bastos18 Mar