What Are the "mysqld" Command Line Options

Home > MySQL > Admin

Q

What Are the "mysqld" Command Line Options? - MySQL FAQs - Server Daemon mysqld Administration

✍: FYIcenter.com

A

"mysqld" offers a big list of command line options. Here are some commonly used options:

"--help" - Displays a short help message on how to use "mysqld".
"--verbose --help" - Displays a long help messages on how to use "mysqld".
"--console" - Specifies that the server to send error messages to launching window.
"--datadir=dirName" - Specifies that server data goes to the specified director.
"--init-file=fileName" - Specifies that server to execute all commands in the specified file at startup time.
"--log=fileName" - Specifies that server to write query logs to the specified file.
"--log-bin=fileBaseName" - Specifies that server to write binary logs to a file with the specified file base name.
"--log-error=fileName" - Specifies that server to write error logs to the specified file.
"--port=portNumber" - Specifies that server to listen client connections at the specified port number.
"--version" - Returns the version information of the server.

2007-05-11, 4641👍, 0💬

How To Properly Shutdown MySQL Server Daemon mysqld
How To Properly Shutdown MySQL Server Daemon mysqld? - MySQL FAQs - Server Daemon mysqld Administration The proper way to shutdown your MySQL server is to the use "mysqladmin shutdown" command. Other ways to shutdown your server include: Enter "mysqladmin -u root -ppassowrd shutdown" command with op... 2007-05-11, 4828👍, 0💬

What Is "mysqldump"
What Is "mysqldump"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqldump" - A command-line interface for administrators or end users to export data from the server to files. Here are some sample commands supported by "mysqldump": "mysqldump databaseName tableName" - Dumps the spe... 2007-05-11, 4785👍, 0💬

How To Turn on Query Logs
How To Turn on Query Logs? - MySQL FAQs - Server Daemon mysqld Administration If you want MySQL to write query logs to a file, you can use the "--log=fileName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option and view the query log f... 2007-05-11, 4759👍, 0💬

How To Turn on Error Logs
How To Turn on Error Logs? - MySQL FAQs - Server Daemon mysqld Administration If you want MySQL to write critical errors into a log file, you can use the "--log-error=fileName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option: >cd \m... 2007-05-11, 4749👍, 0💬

How To Start MySQL Server Daemon mysqld
How To Start MySQL Server Daemon mysqld? - MySQL FAQs - Server Daemon mysqld Administration There are a number of ways to start MySQL server daemon, mysqld: Double click on the file name, mysqld.exe, in a file explorer window. This is an easy way to start the server. But you will not be able to spec... 2007-05-11, 4714👍, 0💬

How To Dump a Table to a File with "mysqldump"
How To Dump a Table to a File with "mysqldump"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to dump all rows in a table from the server to a file, you can use "mysqldump" with the "-f fileName" option as show in the following tutorial exercise: >cd \mysql\bin >mysqldump ... 2007-05-11, 4661👍, 0💬

What Are the "mysqld" Command Line Options
What Are the "mysqld" Command Line Options? - MySQL FAQs - Server Daemon mysqld Administration "mysqld" offers a big list of command line options. Here are some commonly used options: "--help" - Displays a short help message on how to use "mysqld". "--verbose --help" - Displays a long help messages ... 2007-05-11, 4642👍, 0💬

How To Load Data Files into Tables with "mysqlimport"
How To Load Data Files into Tables with "mysqlimport"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to load a data file directly into a table, you need to prepare the data file as one line per data row, and use tab character as the column delimiter. The data file name sho... 2007-05-11, 4632👍, 0💬

What Is the MySQL Server Daemon - mysqld
What Is the MySQL Server Daemon - mysqld? - MySQL FAQs - Server Daemon mysqld Administration "mysqld" is MySQL server daemon program which runs quietly in background on your computer system. Invoking "mysqld" will start the MySQL server on your system. Terminating "mysqld" will shutdown the MySQL se... 2007-05-11, 4627👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.