comp_err(1) compile MySQL error message file


comp_err [options]



creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error codes. comp_err normally is run automatically when MySQL is built. It compiles the errmsg.sys file from the plaintext file located at sql/share/errmsg.txt in MySQL source distributions.

comp_err also generates mysqld_error.h, mysqld_ername.h, and sql_state.h header files.

For more information about how error messages are defined, see the m[blue]MySQL Internals Manualm[][1].

Invoke comp_err like this:

shell> comp_err [options]

comp_err supports the following options.

--help, -?

Display a help message and exit.

--charset=path, -C path

The character set directory. The default is ../sql/share/charsets.

--debug=debug_options, -# debug_options

Write a debugging log. A typical debug_options string is d:t:O,file_name. The default is d:t:O,/tmp/comp_err.trace.

--debug-info, -T

Print some debugging information when the program exits.

--header_file=file_name, -H file_name

The name of the error header file. The default is mysqld_error.h.

--in_file=file_name, -F file_name

The name of the input file. The default is ../sql/share/errmsg.txt.

--name_file=file_name, -N file_name

The name of the error name file. The default is mysqld_ername.h.

--out_dir=path, -D path

The name of the output base directory. The default is ../sql/share/.

--out_file=file_name, -O file_name

The name of the output file. The default is errmsg.sys.

--statefile=file_name, -S file_name

The name for the SQLSTATE header file. The default is sql_state.h.

--version, -V

Display version information and exit.


Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved.

This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.

This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see


MySQL Internals Manual


Oracle Corporation (