mysqld_safe

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

Specifies the username for connecting to the server.