Search Results
https://dev.mysql.com/doc/relnotes/mysql-cluster-manager/8.4/en/news-8-4-5.html
(Bug #37475574) A new client command, list certs, lists the files created by the create certs command for a cluster. (Bug #37691818) Agent: The create certs command failed after an mcmd agent queried another agent for the certificate authority and ... Version 8.4.5 is the latest General Availability release of the 8.4 LTS series of MySQL Cluster ...
https://dev.mysql.com/doc/refman/9.7/en/alter-logfile-group.html
You can verify that the undo files were created and obtain information about them by querying the Information Schema FILES table. ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This ...
https://dev.mysql.com/doc/refman/9.7/en/backup-methods.html
You can also create a binary backup simply by copying the table files, as long as the server is not updating anything. Making Delimited-Text File Backups To create a text file containing a table's data, you can use SELECT * INTO OUTFILE 'file_name' ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/backup-types.html
Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content (INSERT statements or delimited-text files). This type of backup is suitable for smaller amounts of data where you ...
https://dev.mysql.com/doc/refman/9.7/en/cache-index.html
The key cache referred to in a CACHE INDEX statement can be created by setting its size with a parameter setting statement or in the server parameter settings. A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE ...| tbl_name PARTITION (partition_list) } IN key_cache_name tbl_index_list: tbl_name [{INDEX|KEY} (index_name[, index_name] ...)] partition_list: { partition_name[, partition_name] ...
https://dev.mysql.com/doc/refman/9.7/en/charset-database.html
The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET charset_name] [[DEFAULT] COLLATE collation_name] ALTER DATABASE db_name ... Every database has a database character set and a database ...
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-utf16.html
The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same length. For a ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-triggers.html
How are triggers managed in MySQL? Triggers can be created using the CREATE TRIGGER statement, and dropped using DROP TRIGGER. See Section 15.1.26, “CREATE TRIGGER Statement”, and Section 15.1.39, “DROP TRIGGER Statement”, for more about ...
https://dev.mysql.com/doc/refman/9.7/en/file-permissions.html
For example, mysqld might issue the following error message when you create a table: ERROR: Can't find file: 'path/with/file_name' (Errcode: 13) The default UMASK and UMASK_DIR values are 0640 and 0750, respectively. If this is unsuitable, create ...