1PERROR(1)                    MySQL Database System                   PERROR(1)
2
3
4

NAME

6       perror - display MySQL error message information
7

SYNOPSIS

9       perror [options] errorcode ...
10

DESCRIPTION

12       perror displays the error message for MySQL or operating system error
13       codes. Invoke perror like this:
14
15           shell> perror [options] errorcode ...
16
17       perror attempts to be flexible in understanding its arguments. For
18       example, for the ER_WRONG_VALUE_FOR_VAR error, perror understands any
19       of these arguments: 1231, 001231, MY-1231, or MY-001231, or
20       ER_WRONG_VALUE_FOR_VAR.
21
22           shell> perror 1231
23           MySQL error code MY-001231 (ER_WRONG_VALUE_FOR_VAR): Variable '%-.64s'
24           can't be set to the value of '%-.200s'
25
26       If an error number is in the range where MySQL and operating system
27       errors overlap, perror displays both error messages:
28
29           shell> perror 1 13
30           OS error code   1:  Operation not permitted
31           MySQL error code MY-000001: Can't create/write to file '%s' (OS errno %d - %s)
32           OS error code  13:  Permission denied
33           MySQL error code MY-000013: Can't get stat of '%s' (OS errno %d - %s)
34
35       To obtain the error message for a MySQL Cluster error code, use the
36       ndb_perror utility.
37
38       The meaning of system error messages may be dependent on your operating
39       system. A given error code may mean different things on different
40       operating systems.
41
42       perror supports the following options.
43
44       ·   --help, --info, -I, -?
45
46           Display a help message and exit.
47
48       ·   --ndb
49
50           Print the error message for a MySQL Cluster error code.
51
52           This option was removed in MySQL 8.0.13. Use the ndb_perror utility
53           instead.
54
55       ·   --silent, -s
56
57           Silent mode. Print only the error message.
58
59       ·   --verbose, -v
60
61           Verbose mode. Print error code and message. This is the default
62           behavior.
63
64       ·   --version, -V
65
66           Display version information and exit.
67

69       Copyright © 1997, 2019, Oracle and/or its affiliates. All rights
70       reserved.
71
72       This documentation is free software; you can redistribute it and/or
73       modify it only under the terms of the GNU General Public License as
74       published by the Free Software Foundation; version 2 of the License.
75
76       This documentation is distributed in the hope that it will be useful,
77       but WITHOUT ANY WARRANTY; without even the implied warranty of
78       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
79       General Public License for more details.
80
81       You should have received a copy of the GNU General Public License along
82       with the program; if not, write to the Free Software Foundation, Inc.,
83       51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see
84       http://www.gnu.org/licenses/.
85
86

SEE ALSO

88       For more information, please refer to the MySQL Reference Manual, which
89       may already be installed locally and which is also available online at
90       http://dev.mysql.com/doc/.
91

AUTHOR

93       Oracle Corporation (http://dev.mysql.com/).
94
95
96
97MySQL 8.0                         02/20/2019                         PERROR(1)
Impressum