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/mysqlpump.html
If --add-drop-database is used with --all-databases or with --databases where the list of schemas to be dumped includes mysql, the dump file contains a DROP DATABASE `mysql` statement that causes an error when the dump file is reloaded. To reload a ... mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump 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/import-table.html
Given those file names, the copy commands look like this: $> cd export_basedir/data/hr $> cp employees_125.sdi /tmp/export $> cp managers_238.sdi /tmp/export $> cp employees.{MYD,MYI} /tmp/export $> cp managers.{MYD,MYI} /tmp/export Unlock the ...To ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html
Tables created in the mysql tablespace, the InnoDB system tablespace (innodb_system), or general tablespaces include a TABLESPACE attribute in the table definition, which defines the tablespace where the table resides. LIKE preserves the TABLESPACE ...LIKE does not preserve any DATA DIRECTORY or INDEX DIRECTORY table options that were specified for the original table, or any foreign key ...LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data file. When the innodb_stats_persistent setting is enabled, run the ANALYZE TABLE statement for an InnoDB table after ...Beginning with MySQL 8.0.17, the expr for a key_part specification can take the form (CAST json_expression AS type ARRAY) to create a multi-valued index on a JSON ...
https://dev.mysql.com/doc/refman/8.0/en/create-temporary-table.html
When innodb_strict_mode is enabled (the default), CREATE TEMPORARY TABLE returns an error if ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE is specified. The innodb_file_per-table option does not affect the creation of InnoDB temporary tables. LIKE to ...
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
If the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. SELECT id, data INTO @x, @y FROM test.t1 LIMIT 1; INTO var_list can also be used with a TABLE statement, subject to these ...An ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
If it is desired to compile without particular types of instrumentation, that can be done with the following CMake options: DISABLE_PSI_COND DISABLE_PSI_DATA_LOCK DISABLE_PSI_ERROR DISABLE_PSI_FILE DISABLE_PSI_IDLE DISABLE_PSI_MEMORY ...For example, ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
To change the InnoDB table to use compressed row-storage format: ALTER TABLE t1 ROW_FORMAT = COMPRESSED; The ENCRYPTION clause enables or disables page-level data encryption for an InnoDB table. To add (or change) a table comment: ALTER TABLE t1 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html
The login path file must be readable and writable to the current user, and inaccessible to other users. The file location is the %APPDATA%\MySQL directory on Windows and the current user's home directory on non-Windows systems. The ...Think of a ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-safe.html
Messages are written to the default error log file (host_name.err in the data directory), or to a named file if the --log-error option is given. Note The innodb_buffer_pool_in_core_file variable can be used to reduce the size of core files on ...