MySQL 5 Development (Part 1) Tutorials
Installation / What We Installed
Subtitles of the Movie (MySQL 5 Development (Part 1) / Installation / What We Installed)
I'm assuming that you're at least a little curious as to what actually got installed on your computer here so let's take a look at that. Now it does differ from one platform to another but I'll give you at least a direction where you can look and see what actually is on your machine. So, where did everything go? Well on Windows it actually installed things in two separate places, it installed the programs themselves down in the Program Files Directory and installed the Data Directory in a separate directory that we'll talk about here at the end of this slide. But on every other platform it installed the bulk of everything inside of its Installation Directory and there's a specific location that it put that. There may be a couple of files for example the UNIX Socket file would be in a different location in the ETC Directory probably but other than that everything is inside of the main directory for this software. Now, that directory is going to be different depending upon the operating system that you're running on and if you are doing this thing with the manual installation then chances are really good that you may have made your own choices about where these things go. But the default locations are these, on any of the UNIX platforms including Mac OS X, the default is to put it into the User Local Directory and then in a directory with the name not only MySQL but this big long name that includes the version of MySQL and whether it was 32 or 64-bit and what the developer had for lunch and all kinds of other things, this big, long, hyphenated name. And then if you used the Scripted Installer it also creates another directory that's actually a symbolic link at user-local-MySQL just to simplify things little bit and also to make it easier to upgrade versions and downgrade versions and so on. So, but the, the really operating things got installed inside of this directory with the big long name. On the Windows side of things the programs got installed on the Program Files Directory and then in a directory called MySQL and inside of that it made another directory called MySQL Server 5.5 and then all the stuff was dumped in there except for the Data Directory. The Data Directory was placed down the Documents and Settings path then under All Users but at this point you may not see a directory called Application Data. And that depends upon the setting that you have for your Windows Explorer there but you can type in Application Data after All Users with the backslash and so on and then continue from there, everything will be smooth sailing at that point. Then down inside Application Data there's a directory called MySQL and inside of that directory there's a MySQL Server 5.5 and inside of that is where the Data Directory is located. So I'm going to demonstrate what this looks like on my machine which is a Macintosh although everything is pretty much similar inside of these directories once we start looking at just the MySQL things. So, here is my main installation directory and notice that there are mainly directories inside of that and the only two that we're really concerned about here are the Bin Directory and the Data Directory on that top line. The Bin Directory contains all of the programs, the Binary programs that are going to run and the Data Directory contains all the data. There are lots of other things in here, you can explore those if you want to but they're not really important for us in this course or in this whole series of courses for that matter. Inside of the Bin Directory then are all of these and I chose to scroll down a little bit and show just this combination here because MySQLD is our Server and so that's where we would begin but there's also the MySQL Client further up the list and lots of other programs that we might choose to run. So this is where all of those programs reside and if we go into the Data Directory then the Data Directory contains directories which are the different databases so on this machine I already had installed my World Database that we're going to talk about a little bit later and create another one called Demo1 but the ones that come with the software are the MySQL Database, the Performance Schema which is new in Version 5.5 and the Test Database. The other things are just above the Test Database Directory, there's that thing called IBData1, that's the InnoDB Tablespace file and that's where all the InnoDB data goes and to the left of that on this illustration there are two IB Logfiles, Zero and 1 and those are the transaction logs for InnoDB. We'll talk about those in Part 2 of the MySQL 5 Development course. And then above that are just a couple of things, there's an Error Log and there's the Process ID file because my server is running and so it launched a Process ID file so we know who it is. So that's what got installed and in the next lesson we're going to take one more look at some important things here, how to turn the MySQL Server off and on without turning your computer off and on because you may need to do that if you change the configuration file and want to relaunch the server so that it reads the configuration file again, and again the configuration file is the subject for the next chapter.
Tutorial Information
| Course: | MySQL 5 Development (Part 1) |
| Author: | David Swain |
| SKU: | 34225 |
| ISBN: | 1-936334-93-3 |
| Release Date: | 2011-05-27 |
| Duration: | 11 hrs / 129 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
