mysqld_safe
mysqld_safe [options
]
Use this to start the MySQL server and to restart automatically it if
it dies unexpectedly. By default, the script will first attempt to
start mysqld-max. If
mysqld-max is not installed on the server, it
will then start mysqld instead. Although options
may be entered from the command line, to ensure that any options that
are to be passed to the daemon are used when it’s
reloaded after a crash, they should be included in a configuration
file (e.g., my.cnf). There are just a few
options (listed here) relative to the mysqld_safe
script. They should be included in the configuration file
under the heading [mysqld_safe]
but without the
leading double dashes. In previous distributions of MySQL, this
script was named safe_mysqld
.
--basedir=
path
Specifies the path to the MySQL installations.
--core-file-size=
size
Specifies the maximum size of the core file to create if the daemon dies.
--datadir=
path
Specifies the directory which contains datafiles (i.e, table files).
--defaults-extra-file=
path
Specifies an additional configuration file to use after the default file is read.
--defaults-file=
path
Specifies the path to the default configuration file for the server.
--err-log=
path
Specifies the path to the error log for error messages outside of the daemon, such as errors when starting.
--ledir=
path
Specifies the path where the daemons may be found.
--log-error=
filename
Enables logging of error messages and server startup messages to the path and filename given.
--mysqld=
daemon
Specifies which daemon to start (i.e., mysqld-max or mysqld).
--mysqld-version=
suffix
Specifies which daemon to use by providing the suffix of the
daemon’s name (i.e.,
mysqld-
suffix
). A value
of max
ensures mysqld-max is
started. A blank value ensures mysqld is
started.
--nice=
number
Employs the nice utility to set scheduling priority to the value given.
--no-defaults
Instructs the script not to refer to configuration files for options.
--open-files-limit=
number
Limits the number of files the daemon may open. Only root may use this option.
--pid-file=
filename
Specifies the path and the name of the file containing the process identifier.
--port=
port
Specifies the port number to use for connecting to the server.
--socket=
filename
Provides the path and name of the server’s socket file.
--timezone=
zone
Sets the environment variable for the time zone of the server.
--user=
user
13.58.190.38