SpirirHost Support Centre: MySQL Reference Manual p.275

<< 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 4: Database Administration 275 --mysqld-version=version Similar to --mysqld= but here you only give the sux for mysqld. For example if you use --mysqld-version=max, safe_mysqld will start the ledir/mysqld- max version. If the argument to --mysqld-version is empty, ledir/mysqld will be used. --no-defaults --open-files-limit=# Number of les mysqld should be able to open. Passed to ulimit -n. Note that you need to start safe_mysqld as root for this to work properly! --pid-file=path --port=# --socket=path --timezone=# Set the timezone (the TZ) variable to the value of this parameter. --user=# The safe_mysqld script is written so that it normally is able to start a server that was installed from either a source or a binary version of MySQL, even if these install the server in slightly dierent locations. safe_mysqld expects one of these conditions to be true: The server and databases can be found relative to the directory from which safe_ mysqld is invoked. safe_mysqld looks under its working directory for `bin' and `data' directories (for binary distributions) or for `libexec' and `var' directories (for source distributions). This condition should be met if you execute safe_mysqld from your MySQL installation directory (for example, `/usr/local/mysql' for a binary distribu- tion). If the server and databases cannot be found relative to the working directory, safe_ mysqld attempts to locate them by absolute pathnames. Typical locations are `/usr/local/libexec' and `/usr/local/var'. The actual locations are determined when the distribution was built from which safe_mysqld comes. They should be correct if MySQL was installed in a standard location. Because safe_mysqld will try to nd the server and databases relative to its own working directory, you can install a binary distribution of MySQL anywhere, as long as you start safe_mysqld from the MySQL installation directory: shell> cd mysql_installation_directory shell> bin/safe_mysqld & If safe_mysqld fails, even when invoked from the MySQL installation directory, you can modify it to use the path to mysqld and the pathname options that are correct for your system. Note that if you upgrade MySQL in the future, your modied version of safe_ mysqld will be overwritten, so you should make a copy of your edited version that you can reinstall. 4.7.3 mysqld_multi, Program for Managing Multiple MySQL Servers

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