www.LinuxHowtos.org howtos, tips&tricks and tutorials for linux

from small one page howto to huge articles all in one place

Other .linuxhowtos.org sites:gentoo.linuxhowtos.org

Last additions:

using iotop to find disk usage hogs

words:

887

views:

210218

userrating:

May 25th. 2007:

Words

486

Views

259179

why adblockers are bad

Workaround and fixes for the current Core Dump Handling vulnerability affected kernels

words:

161

views:

150551

userrating:

April, 26th. 2006:

Words

Views

107903

New subdomain: toolsntoys.linuxhowtos.org

You are here: manpages

PERROR

Section: MySQL Database System (1)
Updated: 12/13/2024
Index Return to Main Contents

NAME

perror - display MySQL error message information

SYNOPSIS

perror [options] errorcode ...

DESCRIPTION

perror

displays the error message for MySQL or operating system error codes. Invoke perror like this:

perror [options] errorcode ...

perror attempts to be flexible in understanding its arguments. For example, for the ER_WRONG_VALUE_FOR_VAR error, perror understands any of these arguments: 1231, 001231, MY-1231, or MY-001231, or ER_WRONG_VALUE_FOR_VAR.

$> perror 1231
MySQL error code MY-001231 (ER_WRONG_VALUE_FOR_VAR): Variable '%-.64s'
can't be set to the value of '%-.200s'

If an error number is in the range where MySQL and operating system errors overlap, perror displays both error messages:

$> perror 1 13
OS error code   1:  Operation not permitted
MySQL error code MY-000001: Can't create/write to file '%s' (OS errno %d - %s)
OS error code  13:  Permission denied
MySQL error code MY-000013: Can't get stat of '%s' (OS errno %d - %s)

To obtain the error message for a MySQL Cluster error code, use the ndb_perror utility.

The meaning of system error messages may be dependent on your operating system. A given error code may mean different things on different operating systems.

perror supports the following options.

: * --help, --info, -I, -? Display a help message and exit.

: * --ndb Print the error message for a MySQL Cluster error code.
This option was removed in MySQL 8.0.13. Use the ndb_perror utility instead.

: * --silent, -s Silent mode. Print only the error message.

: * --verbose, -v Verbose mode. Print error code and message. This is the default behavior.

: * --version, -V Display version information and exit.

COPYRIGHT

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 0211-1301 USA or see http://www.gnu.org/licenses/.