SpirirHost Support Centre: MySQL Reference Manual p.67

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

Chapter 2: MySQL Installation 67 A ZIP program to unpack the distribution le. Enough space on the hard drive to unpack, install, and create the databases in acco- randance with your requirements. If you plan to connect to the MySQL server via ODBC, you will also need the MyODBC driver. See Section 8.3 [ODBC], page 546. 2.1.2.1 Installing the Binaries 1. If you are working on an NT/2000/XP server, logon as a user with with administrator privileges. 2. If you are doing an upgrade of an earlier MySQL installation, it is necessary to stop the server. If you are running the server as a service, use: C:\> NET STOP MySQL Otherwise, use: C:\mysql\bin> mysqladmin -u root shutdown 3. On NT/2000/XP machines, if you want to change the server executable (e.g., -max or -nt), it is also necessary to remove the service: C:\mysql\bin> mysqld-max-nt --remove 4. Unzip the distribution le to a temporary directory. 5. Run the `setup.exe' le to begin the installation process. If you want to install into another directory than the default `c:\mysql', use the Browse button to specify your preferred directory. 6. Finish the install process. 2.1.2.2 Preparing the Windows MySQL Environment Starting with MySQL 3.23.38, the Windows distribution includes both the normal and the MySQL-Max server binaries. Here is a list of the dierent MySQL servers you can use: Binary Description mysqld Compiled with full debugging and automatic memory allocation check- ing, symbolic links, InnoDB, and BDB tables. mysqld-opt Optimised binary with no support for transactional tables. mysqld-nt Optimised binary for NT/2000/XP with support for named pipes. You can run this version on Windows 9x/Me, but in this case no named pipes are created and you must have TCP/IP installed. mysqld-max Optimised binary with support for symbolic links, InnoDB and BDB tables. mysqld-max-nt Like mysqld-max, but compiled with support for named pipes. Starting from 3.23.50, named pipes are only enabled if one starts mysqld with --enable- named-pipe. All of the preceding binaries are optimised for the Pentium Pro processor but should work on any Intel processor >= i386.

MySQL Reference Manual

Home
Hosting Plans \| Domain Registration \| About Us \| Contact Us \| Site Map Terms of Use \| Privacy Policy \| Guarantees Merchant Accounts

SpiritHost - web hosting for spiritual and education sites SpiritHit.com - Religious and Spiritual Portal Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide