PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/error-lost-connection.html
Usually it indicates network connectivity trouble and you should check the condition of your network if this error occurs frequently. If the error message includes “during query,” this is probably the case you are experiencing. You may see ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-check.html
To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. It first checks all index entries for errors and then reads through all rows. This causes myisamchk to keep going, up through a maximum of 20 ...What it cannot find is corruption that involves only the data file (which is very ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-errors-or-warnings.html
These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings views have these ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-host-cache-table.html
An authentication plugin can report different error codes to indicate the root cause of a failure. While HOST_VALIDATED is NO, DNS resolution is attempted for each connection attempt, until it eventually completes with either a valid result or a ...
https://dev.mysql.com/doc/refman/8.0/en/using-log-files.html
If you find the text mysqld restarted in the error log (normally a file named host_name.err) you probably have found a query that causes mysqld to fail. If you get a lot of these errors, without mysqld having died unexpectedly just before, then ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
Return value: The masked Canada SIN as a string encoded in the utf8mb4 character set, an error if the argument is not the correct length, or NULL if str is in incorrect format or contains a multibyte character. Return value: The masked International ...Example: mysql> SELECT mask_canada_sin('046-454-286'), mask_canada_sin('abcdefijk'); +--------------------------------+------------------------------+ | mask_canada_sin('046-454-286') | mask_canada_sin('abcdefijk') | +--------------------------------+------------------------------+ | XXX-XXX-XXX | XXXXXXXXX | +--------------------------------+------------------------------+ mysql> SELECT mask_canada_sin('909'); ERROR 1123 (HY000): Can't initialize function 'mask_canada_sin'; Argument 0 is too ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. If --add-drop-database is used with --all-databases or with --databases where the list of schemas to ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/error-creating-innodb.html
Runtime Problems If InnoDB prints an operating system error during a file operation, usually the problem has one of the following solutions: Make sure the InnoDB data file directory and the InnoDB log directory exist. In particular, any MAX value in ... The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a DML or DDL statement fails due to problems at the file system ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
RESIGNAL makes it possible to both handle an error and return the error information. Otherwise, RESIGNAL is illegal and a RESIGNAL when handler not active error occurs. For example, the condition_value can be an SQLSTATE value, and the value can ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-operator-functions.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error ...