COMP_ERR(1)

📦
version 9.7.2_2 · 4 versions
, in arch rolling

💖 comp_err(1) — MySQL Database System 💖

okay so bestie, welcome to comp_err(1) from the MySQL Database System. This is the little tool that does some very important behind-the-scenes error-message magic, and we’re gonna get into all of it. no cap. ✨

🌸 NAME 🌸

comp_err — compile MySQL error message file

🦋 SYNOPSIS 🦋

comp_err [options]

🎀 DESCRIPTION 🎀

comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error codes. She normally gets run automatically when MySQL is built, like she’s on the build’s main character energy. 💅

It compiles the errmsg.sys file from text-format error information in MySQL source distributions.

The error information comes from the messages_to_error_log.txt and messages_to_clients.txt files in the share directory.

For more information about defining error messages, see the comments within those files, along with the errmsg_readme.txt file. iykyk. 🫶

comp_err also generates the mysqld_error.h, mysqld_ername.h, and mysqld_errmsg.h header files.

Invoke comp_err like this:

comp_err [options]

comp_err supports the following options.

✨ OPTIONS ✨

  • --help, -? — Display a help message and exit.
    • Command-Line Format: --help
    • Type: Boolean
    • Default Value: false
  • --charset=dir_name, -C dir_name — The character set directory. The default is ../sql/share/charsets.
    • Command-Line Format: --charset
    • Type: String
    • Default Value: (empty)
  • --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.
    • Command-Line Format: --debug=options
    • Type: String
    • Default Value: d:t:O,/tmp/comp_err.trace
  • --debug-info, -T — Print some debugging information when the program exits.
    • Command-Line Format: --debug-info
    • Type: Boolean
    • Default Value: false
  • --errmsg-file=file_name, -H file_name — The name of the error message file. The default is mysqld_errmsg.h.
    • Command-Line Format: --errmsg-file=name
    • Type: File name
    • Default Value: mysqld_errmsg.h
  • --header-file=file_name, -H file_name — The name of the error header file. The default is mysqld_error.h.
    • Command-Line Format: --header-file=name
    • Type: File name
    • Default Value: mysqld_error.h
  • --in-file-errlog=file_name, -e file_name — The name of the input file that defines error messages intended to be written to the error log. The default is ../share/messages_to_error_log.txt.
    • Command-Line Format: --in-file-errlog
    • Type: File name
    • Default Value: (empty)
  • --in-file-toclient=file_name, -c file_name — The name of the input file that defines error messages intended to be written to clients. The default is ../share/messages_to_clients.txt.
    • Command-Line Format: --in-file-toclient=path
    • Type: File name
    • Default Value: (empty)
  • --name-file=file_name, -N file_name — The name of the error name file. The default is mysqld_ername.h.
    • Command-Line Format: --name-file=name
    • Type: File name
    • Default Value: mysqld_ername.h
  • --out-dir=dir_name, -D dir_name — The name of the output base directory. The default is ../sql/share/.
    • Command-Line Format: --out-dir=path
    • Type: String
    • Default Value: (empty)
  • --out-file=file_name, -O file_name — The name of the output file. The default is errmsg.sys.
    • Command-Line Format: --out-file=name
    • Type: File name
    • Default Value: errmsg.sys
  • --version, -V — Display version information and exit.
    • Command-Line Format: --version
    • Type: Boolean
    • Default Value: false

Okay bestie, legal era 💅 but fr fr this one actually matters, so pay attention.

Copyright © 1997, 2026, Oracle and/or its affiliates.

This documentation is free software — iconic, we love a generous queen 👑 — but here's the catch: 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. Not "v2 or later," not "v3 because it's newer," just version 2. Periodt.

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. 😭 So like, if it breaks, that's genuinely not their problem — go read 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 http://www.gnu.org/licenses/. Snail mail or website, your choice, both slay 🫶

No cap, that address and that URL are literal — copy them exactly, don't get creative with the street number 💀

🦋 SEE ALSO 🦋

For more information, please refer to the MySQL Reference Manual, which may already be installed locally (check your own machine first, bestie, it might literally be right there 👀) and which is also available online at http://dev.mysql.com/doc/.

That's the whole cross-reference list. One entry. She's lowkey efficient like that ✨

🌸 AUTHOR 🌸

Oracle Corporation (http://dev.mysql.com/).

Main character energy, honestly 🌈

And that's a wrap on COMP_ERR(1)! This gorgeous little page ships with MySQL 9.7, dated 06/25/2026 — yes, 2026, we're manifesting the future 🔥💜 Go forth and read your error codes, bestie. Mwah 🎀

📦 where this page comes from