Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-using-management-client.html
START BACKUP supports the creation of encrypted backups using ENCRYPT PASSWORD=password. Cluster backups are created by default in the BACKUP subdirectory of the DataDir on each data node. The backup files created for a backup with a given backup_id ... Before starting a backup, make sure that the cluster is properly configured for performing ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables. Review the following examples for different ways to create external tables. These ...To learn more, see Load Structured Data Using Lakehouse Auto Parallel ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
CREATE TABLE permits the core features of table and column CHECK constraints, for all storage engines. CREATE TABLE permits the following CHECK constraint syntax, for both table constraints and column constraints: [CONSTRAINT [symbol]] CHECK (expr) ...If omitted, MySQL generates a name from the table name, a literal _chk_, and an ordinal number (1, 2, 3, ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-secondary-indexes.html
A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns. When a secondary index is created on a virtual generated column, generated column values are ...A ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-sessions-after.html
If you started MySQL Shell without connecting to a MySQL Server instance, you can use MySQL Shell's \connect command or the shell.connect() method to initiate a connection and create the session global object. For example: mysql-js> \connect ...
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html
Forward engineering enables you to create a script of your database model. You may export a script to alter an existing database or create a new database. The script to create a database is similar to the one created using the mysqldump db_name ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
After setting up an external table with the files to load into the table, you run HEATWAVE_LOAD command to automatically create the table and load the data. This topic contains the following sections: Before You Begin Load External Data Using ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-mysql-configuration-details.html
Click Copy Configuration to create a new configuration based on the current configuration. Table 19-2 MySQL Configuration Summary Details Field Description State The state of the configuration: ACTIVE: The configuration was successfully created and ... MySQL Configuration Details 19.3 MySQL Configuration Details Follow these steps to view details of your MySQL configurations: In the MySQL HeatWave Console, select the Resources tab, and then click the Configurations ...
https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html
CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is used. (This does not apply to other operations on temporary tables such as ALTER TABLE and CREATE INDEX, which do cause a commit.) However, although no ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-hashicorp-plugin.html
The following instructions describe how to create the certificate and key files using OpenSSL. (Optional) To check key file content and validity, use the following commands: openssl rsa -in company.key -check openssl rsa -in vault.key -check Create ... Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial ...