diff options
Diffstat (limited to 'Docs/manual.texi')
| -rw-r--r-- | Docs/manual.texi | 41 |
1 files changed, 37 insertions, 4 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi index 8ad5a5dec39..3e96570809f 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -27761,6 +27761,7 @@ How big a @code{VARCHAR} column can be * mysqldump:: Dumping the structure and data from @strong{MySQL} databases and tables * mysqlimport:: Importing data from text files * mysqlshow:: Showing databases, tables and columns +* perror:: Displaying error messages * myisampack:: The @strong{MySQL} compressed read-only table generator @end menu @@ -28559,7 +28560,7 @@ mysqldump --all-databases > all_databases.sql @cindex files, text @cindex text files, importing @cindex @code{mysqlimport} -@node mysqlimport, mysqlshow, mysqldump, Tools +@node mysqlimport, perror, mysqldump, Tools @section Importing Data from Text Files @code{mysqlimport} provides a command-line interface to the @code{LOAD DATA @@ -28696,12 +28697,34 @@ $ mysql -e 'SELECT * FROM imptest' test +------+---------------+ @end example +@cindex error messages, displaying +@cindex perror +@node perror, mysqlshow, mysqlimport, Tools +@section Converting an error code to the corresponding error message + +@code{perror} can be used to print error message(s). @code{perror} can +be invoked like this: + +@example +shell> perror [OPTIONS] [ERRORCODE [ERRORCODE...]] + +For example: + +shell> perror 64 79 +Error code 64: Machine is not on the network +Error code 79: Can not access a needed shared library +@end example + +@code{perror} can be used to display a description for a system error +code, or an MyISAM/ISAM table handler error code. The error messages +are mostly system dependent. + @cindex databases, displaying @cindex displaying, database information @cindex tables, displaying @cindex columns, displaying @cindex showing, database information -@node mysqlshow, myisampack, mysqlimport, Tools +@node mysqlshow, myisampack, perror, Tools @section Showing Databases, Tables, and Columns @code{mysqlshow} can be used to quickly look at which databases exist, @@ -32091,6 +32114,14 @@ tmpdir=C:/temp assuming that the @file{c:\\temp} directory exists. @xref{Option files}. +Check also the error code that you get with @code{perror}. One reason +may also be a disk full error; + +@example +shell >perror 28 +Error code 28: No space left on device +@end example + @cindex commands out of sync @node Commands out of sync, Ignoring user, Cannot create, Common errors @subsection @code{Commands out of sync} error in client @@ -38932,10 +38963,12 @@ though, so Version 3.23 is not released as a stable version yet. Automatically remove Berkeley DB transaction logs that are no longer in use. @item +Added a warning if number of rows changes on @code{REPAIR}/@code{OPTIMIZE}. +@item Applied patches for OS2 by @code{Yuri Dario}. @item -@code{FLUSH TABLES table_name} didn't always flush table properly to -disk; One some cases the index tree wasn't completely written to disk. +@code{FLUSH TABLES table_name} didn't always flush the index tree +properly to disk. @item @code{--bootstrap} is now run in a separate thread. This fixes the problem that @code{mysql_install_db} core dumped on some Linux machines. |