PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--recover, -r Command-Line Format --recover Do a repair that can fix almost any problem except unique keys that are not unique (which is an extremely unlikely error with MyISAM tables). --correct-checksum Command-Line Format --correct-checksum ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-troubleshooting.html
If an error code is returned when issuing a backup request, the most likely cause is insufficient memory or disk space. You should check that there is enough memory allocated for the backup. Important If you have set BackupDataBufferSize and ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-row-events.html
These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type codes. The --base64-output=DECODE-ROWS and --verbose options may be used to affect row event output. This is similar to --base64-output=NEVER but ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-server.html
This setting modifies certain aspects of SQL syntax and semantics, for example for compatibility with code from other database systems, or to control the error handling for particular situations. The following discussion covers these MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-rounding.html
Such truncation is not an error, even in strict SQL mode (see Section 14.24.3, “Expression Handling”). This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and ...
https://dev.mysql.com/doc/refman/8.0/en/show-profile.html
For example, SHOW PROFILING is an illegal statement, and a syntax error occurs if you try to execute it, but it shows up in the profiling list. Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
The source code for this plugin can be examined as a relatively simple example demonstrating how to write a loadable authentication plugin. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE ... The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket ...
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
The error (2003) Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. Here are some reasons the Can't connect to local MySQL server error might occur: mysqld is not running on the local host. If ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port ...
https://dev.mysql.com/doc/refman/8.0/en/compilation-problems.html
This mode causes compiler warnings to become errors, so disabling it may enable compilation to proceed. However, if you do need to re-create it, you might encounter this error: "sql_yacc.yy", line xxx fatal: default action causes potential... If you ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: 2013-09-24T12:41:31.261992Z 25 [ERROR] Event Scheduler: [jon@ghidora][cookbook.e_store_ts] INSERT command ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...