|
 |
MYSql Windows Installation
1. Download the MySQL-Win32 version
of the program.
2. Open up Windows Explorer (Start
| Programs | Accessories | Windows Explorer).
3. Find the downloaded file and
copy or move it into a temporary directory, if
you want to.
4. Unzip the file.
a. cd /path/to/file
b. unzip mysql-3.23.55-win.zip -d temp
c. chmod 700 temp/*
o Via WinZip or PKZIP for Windows, or other such
utilities
a. Double click on the zip file.
b. If you need to maintain good security, modify
the permissions on the temp dir and its files
via File | Properties.
5. Once the files are extracted,
go back into Explorer and double click on Setup.exe.
6. Follow the instructions within
the installation program.
7. If you choose "Custom"
when you get to the Setup Type dialog box, you'll
be presented with the following options:
The MySQL Servers
Required. The executables that run the system.
The MySQL clients and Maintenance Tools
Optional, though highly recommended. Command line
programs used for editing and mataining databases.
The MySQL Documentation with defferent formats.
Optional. Manuals on how to use MySQL.
Examples, Libraries, Includes and Script files.
Optional. Benchmarking utilities, system tests,
Libmysql for embedding functionality into applications,
C header files and other utilities. If you are
updating from 3.23 to 4.0, make sure this option
is selected.
The Grant Tables and Core Files
Required. The components that regulate access
to the database.
8. If you will be using transactions
and/or InnoDB tables, create two directories:
ibdata and iblogs. The standard location for them
is c:\. Feel free to put those directories wherever
you like. But, if you're putting them in alternate
locations, make sure to set the innodb_data_home_dir
and innodb_log_group_home_dir variables in the
next step...
9. If you're customizing your
installation, such as having your mysql/data and/or
mysql/bin directories in non-default locations,
and you haven't already set up your my.cnf file,
do the following:
a. Again, in Explorer, copy one of the *.cnf files
from the mysql directory to the c:\ drive and
change the name of the copy to my.cnf.
b. Open up c:\my.cnf in Notepad (Start | Program
| Accessories | Notepad). Then in Notepad: File
| Open.
c. Alter the file as needed. I've stripped my
configuration file down to only a few lines:
[mysqld]
basedir = x:/Program Files/mysql/
datadir = y:/mysql/
innodb_data_home_dir = y:/mysql/ibdata/
innodb_log_group_home_dir = y:/mysql/iblogs/
innodb_data_file_path = ibdata1:10M:autoextend
set-variable = lower_case_table_names=0
d. Set permissions on this file so only administrators
can modify it.
e. To ensure your installation doesn't get subverted,
make another my.cnf file and place it in your
mysql\data directory. This file should only contain
the following line: [mysqld] . Set permissions
on this file so only administrators can modify
it.
10. Let's make a Command Prompt
shortcut to make it easy to manually work with
MySQL.
. Open Windows Explorer.
a. In the Address Bar, type in %UserProflie% and
hit the ENTER key.
b. Navigate to the Start Menu\Programs\Accessories
directory.
c. Select the Command Prompt file.
d. Hit CTRL-C then CTRL-V
e. Select the Copy of Command Prompt file.
f. Hit F2 and rename it to something like MySQL
Prompt
g. Open it's properties via File | Properties
and go to the "Shortcut" tab, then the
"Start In" box and type in the path
where your MySQL binaries are. For example: C:\MySQL\bin
h. Edit the items in the remaining tabs to suit
your preferences.
i. Hit OK when you're done.
j. Now move the shortcut to the Start Menu folder
you want it in.
k. For the rest of this lesson, we'll be calling
this the "MySQL Shortcut".
11. Open the MySQL Shortcut.
12. Next, we need to "install"
the appropriate MySQL service. You have several
options. The options and the command to implement
it are as follows:
. NT/2000/XP. Transactions. Named pipes.
mysqld-max-nt --install
a. NT/2000/XP. Transactions.
mysqld-max --install
b. NT/2000/XP. Named pipes.
mysqld-nt --install
c. Transactions.
mysqld --install
d. Optimised binary with no support for transactional
tables.
mysqld-opt --install
|
|
|
|
