- 4.2.3 Specifying Program Options
- 4.2.3.1 Using Options on the Command Line
- 4.2.3.2 Program Option Modifiers
- 4.2.3.3 Using Option Files
- 4.2.3.4 Command-Line Options that Affect Option-File Handling
- 4.2.3.5 Using Options to Set Program Variables
- 4.2.3.6 Option Defaults, Options Expecting Values, and the = Sign
Most MySQL programs that support option files handle the following options. They affect option-file handling, so they must be given on the command line and not in an option file. To work properly, each of these options must be given before other options, with these exceptions:
--print-defaultsmay be used immediately after--defaults-fileor--defaults-extra-file.On Windows, if the server is started with the
--defaults-fileand--installoptions,--installmust be first. See Section 2.3.7.7, “Starting MySQL as a Windows Service”.
When specifying file names, you should avoid the use of the
“~” shell metacharacter because
it might not be interpreted as you expect.
--defaults-extra-file=file_nameRead this option file after the global option file but (on Unix) before the user option file. If the file does not exist or is otherwise inaccessible, the program exits with an error. Before MySQL 5.5.8,
file_namemust be the full path name to the file. As of MySQL 5.5.8, the name is interpreted relative to the current directory if given as a relative path name.Use only the given option file. If the file does not exist or is otherwise inaccessible, the program exits with an error. Before MySQL 5.5.8,
file_namemust be the full path name to the file. As of MySQL 5.5.8, the name is interpreted relative to the current directory if given as a relative path name.If this option is given, the program reads not only its usual option groups, but also groups with the usual names and a suffix of
str. For example, the mysql client normally reads the[client]and[mysql]groups. If the--defaults-group-suffix=_otheroption is given, mysql also reads the[client_other]and[mysql_other]groups.Do not read any option files. If a program does not start because it is reading unknown options from an option file,
--no-defaultscan be used to prevent the program from reading them.Print the program name and all options that it gets from option files.
User Comments
Add your own comment.