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/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. In such cases, you must drop and re-create the foreign keys for them to function properly. row *************************** Table: t3 ... RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...
https://dev.mysql.com/doc/refman/8.0/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. Trailing spaces are automatically deleted from ENUM and SET member values when the table is created. Specifying the CHARACTER ...These might be changes to a data type, to attributes associated with a data type, or to an index ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
The authentication_string value can be specified using an IDENTIFIED ...AS clause with CREATE USER or ALTER USER. The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket file.
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-installation.html
To avoid this overhead, do not install it unless you plan to use it. This section describes how to install or uninstall Version Tokens, which is implemented in a plugin library file containing a plugin and loadable functions. For general information ...
https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. They must not be expressions, such as these: 3.14159 col1 + 3 UPPER(col2) col3 / col4 (subquery) MySQL sets a flag, called the view ... Some ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
If binary logging is enabled, the sequence number of the binary log file is incremented by one relative to the previous file. Frees memory cached by the server as a result of GRANT, CREATE USER, CREATE SERVER, and INSTALL PLUGIN statements. If relay ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html
If you are using tablespaces with InnoDB, then the specific tablespace files you create are used instead. MySQL encodes any characters that are problematic in the corresponding file system objects when it creates database directories or table files: ... There is a correspondence between database and table identifiers and names in the file ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
This client transaction is assigned a GTID composed of the source's UUID and the smallest nonzero transaction sequence number not yet used on this server. A GTID is also assigned to the creation, alteration, or deletion of a database, and of a ...
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
Full backups are necessary, but it is not always convenient to create them. If you make sure to flush the logs when you make your full backup, the binary log files created afterward contain all the data changes made since the backup. On Monday at 1 ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...