Appendix G. C API Reference


mysqld_multi

The mysqld_multi script makes it easier to run several mysqld servers on a single host. It enables you to start or stop servers, or determine whether they are running.

Usage

 mysqld_multi [options] command server_list 

command is one of start, stop, or report. The server_list argument indicates which servers you want to manipulate. For further instructions on using mysqld_multi, see "Using mysqld_multi for Server Management," in Chapter 11.

Standard Options Supported by mysqld_multi

 --help        --silent      --verbose --password    --user        --version 

mysqld_multi passes the --user and --password option values to mysqladmin when it needs to stop servers or determine whether they are running.

The --silent and --verbose options are supported as of MySQL 4.1.6.

Options Specific to mysqld_multi

  • --config-file=file_name

    The option file to read to obtain options for the servers that mysqld_multi manipulates. Without --config-file, mysqld_multi reads /etc/my.cnf and the .my.cnf file in your home directory to obtain server options. (mysqld_multi reads the standard option files for its own options. This option does not change that behavior.)

  • --example

    Display a sample option file that demonstrates option file groups suitable for use with mysqld_multi.

  • --log=file_name

    The name of the log file where mysqld_multi should log its actions. Output is appended to the log if it already exists. The default log file is named mysqld_multi.log. As of MySQL 4.1.2, mysqld_multi writes the log in the data directory. Before that, it writes the log in the /tmp directory. To disable logging, use --no-log.

  • --mysqladmin=file_name

    The pathname to the mysqladmin binary you want to use. This can be useful if mysqld_multi cannot find mysqladmin by itself, or if you want to use a particular version.

  • --mysqld=file_name

    The pathname to the mysqld binary you want to use. This can be useful if mysqld_multi cannot find mysqld by itself, or if you want to use a particular version. It is allowable to specify a pathname to mysqld or mysqld_safe as the value of this option.

  • --no-log

    Display log output rather than writing it to a log file. If you want to see output on the screen, you must use this option, because the default is to log to a file.

  • --tcp-ip

    By default, mysqld_multi attempts to connect to a server using a Unix socket file. This option causes the connection attempt to use TCP/IP instead. It can be useful when a server is running but its socket file has been removed, in which case the server will be accessible only via TCP/IP.



MySQL The definitive guide to using, programming, and administering MySQL 4. 1 and 5. 0
Mysql: the Definitive Guide to Using, Programming, and Administering Mysql 4.1 and 5.0
ISBN: B003A1PKHY
EAN: N/A
Year: 2004
Pages: 190
Authors: Paul Dubois

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net