You are here

MySQL Error codes and messages

Just a general rule with error messages: Usually they are not as good as they could be. But nevertheless read them carefully. Most of the time they tell you what you need to know...

And an other wisdom: Errors are really errors and they have to be solved. Warnings are warnings and you should investigate if they appear. Do not ignore both of them unless you have clearly understood what you are doing.

With MySQL:

mysql> SHOW WARNINGS

is often your friend! Further sources to find the problems are:

mysql> SHOW SLAVE STATUS\G
shell> perror <error_number>
shell> perror --ndb <error_number>

And the MySQL Error log.

MySQL Server Error Codes and Messages

  1. MySQL Errors 1000 - 1049
  2. MySQL Errors 1050 - 1099
  3. MySQL Errors 1100 - 1149
  4. MySQL Errors 1150 - 1199
  5. MySQL Errors 1200 - 1249
  6. MySQL Errors 1250 - 1299
  7. MySQL Errors 1300 - 1349
  8. MySQL Errors 1350 - 1399
  9. MySQL Errors 1400 - 1449
  10. MySQL Errors 1450 - 1499
  11. MySQL Errors 1500 - 1549
  12. MySQL Errors 1550 - 1599
  13. MySQL Errors 1600 - 1649
  14. MySQL Errors 1650 - 1699
  15. MySQL Errors 1700 - 1749

MySQL Client Error Codes and Messages

  1. MySQL Errors 2000 - 2049
  2. MySQL Errors 2050 - 2099

Literature

  1. [ 1 ] Appendix C. Errors, Error Codes, and Common Problems