Mysql System Error Codes
Contents |
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.5 Reference Manual Preface and Legal Notices
Mysql Error Codes List
General Information Installing and Upgrading MySQL Tutorial MySQL Programs mysql sqlstate MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and
Mysql Error Php
Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL Cluster NDB 7.2 Partitioning Stored Programs and mysql codes for creating tables Views INFORMATION_SCHEMA Tables MySQL Performance Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.5 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources of Error Information Types of Error Values Server Error Codes and Messages Client Error Codes and Messages Problems and Common Errors mysql codes list How to Determine What Is Causing a Problem Common Errors When Using MySQL Programs Access denied Can't connect to [local] MySQL server Lost connection to MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections Out of memory MySQL server has gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problems Using DATE C
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General
Mysql Errors And Solutions
Information Installing and Upgrading MySQL Using MySQL as a Document mysql error code 1062 Store Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization
Mysql Sqlstate 45000
Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL Cluster NDB 7.5 https://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema MySQL sys Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.7 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources of Error Information Types of Error Values Server Error Codes and Messages Client Error Codes http://dev.mysql.com/doc/en/error-messages-server.html and Messages Problems and Common Errors How to Determine What Is Causing a Problem Common Errors When Using MySQL Programs Access denied Can't connect to [local] MySQL server Lost connection to MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections Out of memory MySQL server has gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problem
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a Document Store Tutorial MySQL Programs Overview http://dev.mysql.com/doc/en/perror.html of MySQL Programs Using MySQL Programs Invoking MySQL Programs Connecting to the https://docs.oracle.com/cd/E17952_01/mysql-enterprise-backup-3.7-en/errorcodes.html MySQL Server Specifying Program Options Using Options on the Command Line Program Option Modifiers Using Option Files Command-Line Options that Affect Option-File Handling Using Options to Set Program Variables Option Defaults, Options Expecting Values, and the = Sign Setting Environment Variables MySQL Server and Server-Startup Programs mysqld — The MySQL Server mysqld_safe mysql error — MySQL Server Startup Script mysql.server — MySQL Server Startup Script mysqld_multi — Manage Multiple MySQL Servers MySQL Installation-Related Programs comp_err — Compile MySQL Error Message File mysql_install_db — Initialize MySQL Data Directory mysql_plugin — Configure MySQL Server Plugins mysql_secure_installation — Improve MySQL Installation Security mysql_ssl_rsa_setup — Create SSL/RSA Files mysql_tzinfo_to_sql — Load the Time Zone Tables mysql_upgrade — Check and Upgrade MySQL Tables MySQL mysql error code Client Programs mysql — The MySQL Command-Line Tool mysql Options mysql Commands mysql Logging mysql Server-Side Help Executing SQL Statements from a Text File mysql Tips mysqladmin — Client for Administering a MySQL Server mysqlcheck — A Table Maintenance Program mysqldump — A Database Backup Program mysqlimport — A Data Import Program mysqlpump — A Database Backup Program mysqlsh — The MySQL Shell mysqlshow — Display Database, Table, and Column Information mysqlslap — Load Emulation Client MySQL Administrative and Utility Programs innochecksum — Offline InnoDB File Checksum Utility myisam_ftdump — Display Full-Text Index information myisamchk — MyISAM Table-Maintenance Utility myisamchk General Options myisamchk Check Options myisamchk Repair Options Other myisamchk Options Obtaining Table Information with myisamchk myisamchk Memory Usage myisamlog — Display MyISAM Log File Contents myisampack — Generate Compressed, Read-Only MyISAM Tables mysql_config_editor — MySQL Configuration Utility mysqlbinlog — Utility for Processing Binary Log Files mysqlbinlog Hex Dump Format mysqlbinlog Row Event Display Using mysqlbinlog to Back Up Binary Log Files Specifying the mysqlbinlog Server ID mysqldumpslow — Summarize Slow Query Log Files MySQL Program Development Utilities mysql_config — Display Options for Compiling Clients my_print_defaults — Display Options from Option Fil
backup or restore run succeeds. If the run fails for any reason, the return code is set to the OS error code. If mysqlbackup fails, because an operating system call fails, mysqlbackup usually displays the operating systems error code along with a detailed error message. On Linux and other Unix-like systems, the operating system error codes are POSIX error codes. Those POSIX error codes that are possible with mysqlbackup are shown in Table 7.1, “OS Errors for Linux and Other Unix-Like Systems”. A complete list of all POSIX errors is available in the file /usr/include/errno.h on your system. Table 7.1 OS Errors for Linux and Other Unix-Like Systems Error code Value Description EPERM 1 Operation not permitted ENOENT 2 No such file or directory ESRCH 3 No such process EINTR 4 Interrupted system call EIO 5 I/O error ENXIO 6 No such device or address EBADF 9 Bad file number EAGAIN 11 Try again ENOMEM 12 Out of memory EACCES 13 Permission denied EBUSY 16 Device or resource busy EEXIST 17 File exists ENODEV 19 No such device ENOTDIR 20 Not a directory EMFILE 24 Too many open files EFBIG 27 File too large ENOSPC 28 No space left on device EROFS 30 Read-only file system ENAMETOOLONG 36 File name too long ENODATA 61 No data available ETIME 62 Timer expired EBADFD 77 File descriptor in bad state EDQUOT 122 Quota exceeded On Microsoft Windows, mysqlbackup uses Win32 API calls. The Windows System Error codes possible with mysqlbackup are listed in Table 7.2, “OS Errors for Windows Systems”. A complete list of all Windows System errors is available at http://msdn2.microsoft.com/en-us/library/ms681381(VS.85).aspx. Table 7.2 OS Errors for Windows Systems Error code Value Description ERROR_SUCCESS 0 The operation completed successfully. ERROR_FILE_NOT_FOUND 2 The system cannot find the file specified. ERROR_PATH_NOT_FOUND 3 The system cannot find the path specified. ERROR_TOO_MANY_OPEN_FILES 4 The system cannot open the file. ERROR_ACCESS_DENIED 5 Access is denied. ERROR_NOT_ENOUGH_MEMORY 8 Not enough storage is available to process this command. ERROR_OUTOFMEMORY 14 Not enough storage is available to complete this operation