From: Jorge Bastos Date: March 17 2006 11:24pm Subject: Fw: Please help List-Archive: http://lists.mysql.com/win32/18113 Message-Id: <00cf01c64a1a$01c9df10$0101a8c0@pcjorge> MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit I agree, it happens to me sometimes... Jorge ----- Original Message ----- From: "Armando" To: 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" wrote on 03/16/2006 12:50:15 >> >> PM: >> >> >>>On 3/16/06, 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 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 >>>>> >>>> >>>> >>>> >>> >>>-- >>>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=sgreen@stripped >> >> > > -- > MySQL Windows Mailing List > For list archives: http://lists.mysql.com/win32 > To unsubscribe: > http://lists.mysql.com/win32?unsub=mysql.jorge@stripped > >