- 4.8 Miscellaneous Programs
- 4.8.1 perror — Explain Error Codes
- 4.8.2 replace — A String-Replacement Utility
- 4.8.3 resolveip — Resolve Host name to IP Address or Vice Versa
For most system errors, MySQL displays, in addition to an internal text message, the system error code in one of the following styles:
message ... (errno: #) message ... (Errcode: #)
You can find out what the error code means by examining the documentation for your system or by using the perror utility.
perror prints a description for a system error code or for a storage engine (table handler) error code.
Invoke perror like this:
shell> perror [options] errorcode ...
Example:
shell> perror 13 64
OS error code 13: Permission denied
OS error code 64: Machine is not on the network
To obtain the error message for a MySQL Cluster error code,
invoke perror with the
--ndb option:
shell> perror --ndb errorcode
Note that 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.
User Comments
Regarding list of MySQL errors.
If you use unix, you can generate the list with the command:
perror `seq a b`
where a is the first error code and b is the last error code you want to list.
For example,
perror `seq 0 10`
shows codes 0 through 10.
In Windows you will find perror in 'mysql\bin'
from the command line in this directory run the program with your error code;
perror.exe 2
This will return the results;
Error Code 2: No such file or directory
To generate an error list if you don't have the seq command on your system, and you do have perl:
perror `perl -e "print join ' ',1..100"`
Where 1 is the first error number, and 100 is the last error number you want to see (similar to seq).
The error return codes are listed here:
* http://www.mysql.com/doc/en/Error-returns.html
Although the messages aren't listed (yet?). See also the following bug report (and don't hesitate to vote!):
* http://bugs.mysql.com/bug.php?id=531
if you are mysql user from Bulgaria read this tutorial "What is perror? Howto use perror"- http://mpetrov.net/perror-i-kak-toj-sche-ni-pomogne-da-razreshavame-problemite-v-mysql . For more info check my tech blog: http://www.mpetrov.net . Freedom of Mysql
Add your own comment.