Search Results
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-local.html
Attempting to clone such tables or tablespaces causes the following error: ERROR 1086 (HY000): File '/path/to/tablespace_name.ibd' already exists. The BACKUP_ADMIN privilege is required to execute CLONE LOCAL DATA DIRECTORY statements. The following ...mysql> GRANT BACKUP_ADMIN ON *.* TO 'clone_user'; where clone_user is the MySQL user that performs the cloning ...For ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.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. Because the ...To reload a dump file, you must have the privileges required to execute the statements that it contains, such as the appropriate CREATE privileges for objects created by those ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-types.html
MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for representing spatial values Functions for manipulating spatial values Spatial indexing for improved access times to spatial columns The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-locks-table.html
If there is no primary key, LOCK_DATA shows either the key values of a selected unique index or the unique InnoDB internal row ID number, according to the rules governing InnoDB clustered index use (see Section 17.6.2.1, “Clustered and Secondary ...For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling-prepare.html
This topic describes how to prepare the data to use for topic modeling. To prepare the data for this use case, you set up a dataset to use for both training and testing. You have the option to automatically Prepare Training and Testing Datasets ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-topic-modeling-prepare.html
This topic describes how to prepare the data to use for topic modeling. To prepare the data for this use case, you set up a dataset to use for both training and testing. You have the option to automatically Prepare Training and Testing Datasets ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. Column definitions for character string data types CHAR, VARCHAR, the TEXT types, ENUM, SET, and any synonyms) can specify the column character set and ...For ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-syntax.html
For integer data types, M indicates the minimum display width. For floating-point and fixed-point data types, M is the total number of digits that can be stored. The display width attribute is deprecated for integer data types; you should expect ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-streaming.html
Example 4.14 Single-file Backup to a Remote MySQL Server The following command streams the backup as a single backup file to be restored on a remote MySQL server: mysqlbackup --backup-dir=backup --backup-image=- --compress backup-to-image | \ ssh ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
Load Data Using Auto Parallel Load First, run Auto Parallel Load in dryrun mode to check for errors and warnings and to inspect the generated load script. You can load data into a MySQL HeatWave Cluster by using the Auto Parallel Load feature. If ...Auto Parallel Load, which can be run manually from any MySQL client or connector, is implemented as a stored procedure named heatwave_load, which resides in the MySQL sys ...