MySQL中操作系统级别错误代码与其含义

经常见到网友在发一些关于mysql操作出错的解决方法，现在整理一下。mysqlperformanceblog上明确说了，mysql里面出现的errno(操作

Number Macro Description

1 ERROR_INVALID_FUNCTION Incorrect function.

2 ERROR_FILE_NOT_FOUND The system cannot find the file specified.

3 ERROR_PATH_NOT_FOUND The system cannot find the path specified.

4 ERROR_TOO_MANY_OPEN_FILES The system cannot open the file.

5 ERROR_ACCESS_DENIED Access is denied.

6 ERROR_INVALID_HANDLE The handle is invalid.

7 ERROR_ARENA_TRASHED The storage control blocks were destroyed.

8 ERROR_NOT_ENOUGH_MEMORY Not enough storage is available to process this command.

9 ERROR_INVALID_BLOCK The storage control block address is invalid.

10 ERROR_BAD_ENVIRONMENT The environment is incorrect.

11 ERROR_BAD_FORMAT An attempt was made to load a program with an incorrect format.

12 ERROR_INVALID_ACCESS The access code is invalid.

13 ERROR_INVALID_DATA The data is invalid.

14 ERROR_OUTOFMEMORY Not enough storage is available to complete this operation.

15 ERROR_INVALID_DRIVE The system cannot find the drive specified.

16 ERROR_CURRENT_DIRECTORY The directory cannot be removed.

17 ERROR_NOT_SAME_DEVICE The system cannot move the file to a different disk drive.

18 ERROR_NO_MORE_FILES There are no more files.

19 ERROR_WRITE_PROTECT The media is write protected.

20 ERROR_BAD_UNIT The system cannot find the device specified.

21 ERROR_NOT_READY The device is not ready.

22 ERROR_BAD_COMMAND The device does not recognize the command.

23 ERROR_CRC Data error (cyclic redundancy check).

24 ERROR_BAD_LENGTH The program issued a command but the command length is incorrect.

25 ERROR_SEEK The drive cannot locate a specific area or track on the disk.

26 ERROR_NOT_DOS_DISK The specified disk or diskette cannot be accessed.

27 ERROR_SECTOR_NOT_FOUND The drive cannot find the sector requested.

28 ERROR_OUT_OF_PAPER The printer is out of paper.

29 ERROR_WRITE_FAULT The system cannot write to the specified device.

30 ERROR_READ_FAULT The system cannot read from the specified device.

31 ERROR_GEN_FAILURE A device attached to the system is not functioning.

32 ERROR_SHARING_VIOLATION The process cannot access the file because it is being used by another process.

33 ERROR_LOCK_VIOLATION The process cannot access the file because another process has locked a portion of the file.

34 ERROR_WRONG_DISK The wrong diskette is in the drive. Insert %2 (Volume Serial Number: %3) into drive %1.

36 ERROR_SHARING_BUFFER_EXCEEDED Too many files opened for sharing.

38 ERROR_HANDLE_EOF Reached the end of the file.

39 ERROR_HANDLE_DISK_FULL The disk is full.

87 ERROR_INVALID_PARAMETER The parameter is incorrect.

112 ERROR_DISK_FULL The disk is full.

123 ERROR_INVALID_NAME The file name, directory name, or volume label syntax is incorrect.

1450 ERROR_NO_SYSTEM_RESOURCES Insufficient system resources exist to complete the requested service.

有了这些错误代码，我想解决很多问题就简单多了,，，另外需要注意，os级别的错误指的是errno，而不是ERROR xxx(HY000)这个错误代码，后者是mysql自身的。