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.