User manual
Table Of Contents
- Web Technologies Administration
- Contents
- Web Technologies Overview
- Managing Web Technologies
- Managing Websites
- Using Server Admin to Manage Websites
- Changing the Access Port for a Website
- Improving Performance of Static Websites (PerformanceCache)
- Enabling Access and Error Logs for a Website
- Setting Up Directory Listing for a Website
- Connecting to Your Website
- Enabling WebDAV on Websites
- Enabling a Common Gateway Interface (CGI) Script
- Enabling Server Side Includes (SSI)
- Viewing Website Settings
- Setting Server Responses to MIME Types and ContentHandlers
- Enabling SSL
- Enabling PHP
- User Content on Websites
- WebMail
- Secure Sockets Layer (SSL)
- Working With Open-Source Applications
- Installing and Viewing WebModules
- Solving Problems
- Where to Find More Information
- Glossary
- Index
60 Chapter 6 Working With Open-Source Applications
Installing MySQL
Mac OS X Server versions 10.3 includes the latest MySQL, version 4.0.14. Since it's
preinstalled, you won't find it in /usr/local/mysql. Instead, its elements are distributed in
the file system according to standard UNIX file layout, with executables in /usr/sbin and
/usr/bin, man pages in /usr/share/man, and other parts in /usr/share/mysql. When
installed, the MySQL database resides in /var/mysql.
At some point a newer version of MySQL will be posted to http://www.mysql.com. At
that time you may consider downloading the source and building it yourself (if you
have the developer packages installed) or downloading the appropriate binary
distribution and installing it yourself, following the instructions posted on that website.
By default, such installations reside in /usr/local/mysql/. So if you install your own
version of MySQL, you'll have two versions of MySQL present on your system. This
should do no harm as long as you don't try to run both the old one and the new one.
Just be sure to prefix any commands intended for the new version with the full path
(starting with /usr/local/mysql), or make sure your shell's path variable is set to search
in your local directory first.
Note that the MySQL Manager application works only with the preinstalled version of
MySQL; it does not work with MySQL installed elsewhere. The paths to the various
preinstalled components of MySQL are stored in the following plist file:
/Applications/Server/MySQL Manager.app/Contents/Resources/tool_strings.
If You Are Updating from Mac OS X Server 10.x and Use MySQL
Mac OS X Server version 10.3 contains a new version of MySQL. Previous versions of the
server contain MySQL 3.23.x; the version now installed is 4.0.14, which is the latest
production version. This version is the one recommended by mysql.com.
Your MySQL 3.23.x databases should work with the new version of MySQL, but it’s a
good idea to back them up before updating.
When using MySQL 4.0.14, there are several commands you can use with your old
databases to remove dependency on the ISAM table format, which has been
deprecated over time.
• Use mysql_fix_privilege_tables to enable new security privilege features.
• Use mysql_convert_table_format (if all existing tables are ISAM or MyISAM) or use
ALTER TABLE table_name TYPE+MyISAM on all ISAM tables to get away from the
degraded ISAM table format.
Refer to the instructions provided on the MySQL website at www.mysql.com/doc/en/
Upgrading-from-3.23.html before using these commands.
For more information about MySQL, see www.mysql.com.
LL2350.book Page 60 Friday, August 22, 2003 2:32 PM