Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.verify.html
You can then execute SHOW statements to verify the database and table structures, and execute queries to verify further details of the database. You can check the integrity of your backup using the validate command. The following is a sample ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore.external-tablespaces.html
When a backup contains external InnoDB tablespaces that resided outside of the backed-up server's data directory, you can restore them to locations different from their original ones by updating their path names in the tablespace_tracker file ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/what-is-new.html
MySQL Enterprise Backup 8.4 marks the start of a new series of LTS (Long Term Support) releases. MySQL Enterprise Backup 8.4 is recommended for use on production systems. The MySQL Enterprise Backup.x LTS releases will focus on security and bug ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-issues-mysql-server.html
The --skip option modifier is supported in some but not all cases, so that commands such as set skip-innodb:mysqld=true mycluster; and set skip-grant-tables:mysqld=true mycluster; can be used with MySQL Cluster Manager, while set ... The limitations ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-start-cluster.html
NDB tables that were previously stored in the cluster are lost. See Section 5.4.1, “The create cluster Command”, and Section 4.5, “Importing MySQL NDB Clusters into MySQL Cluster Manager”, for more information. --initial option The --initial ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-asynchronous-interface-usage.html
CREATE DATABASE db; USE db; CREATE TABLE test_table (id INT NOT NULL); INSERT INTO test_table VALUES (10), (20), (30); CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'testpass'; GRANT ALL ON db.* TO 'testuser'@'localhost'; Create a file named ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-data-structures.html
The MYSQL_TIME structure contains the members listed in the following table. Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer to a ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-bind-param.html
Each attribute type most be one of the MYSQL_TYPE_xxx types listed in Table 6.1, “Permissible Input Data Types for MYSQL_BIND Structures”, except that MYSQL_TYPE_BLOB and MYSQL_TYPE_TEXT are not supported. bool mysql_bind_param(MYSQL *mysql, ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-errno.html
For example, the mysql client program displays errors using the following format, where 1146 is the mysql_errno() value and '42S02' is the corresponding mysql_sqlstate() value: $> SELECT * FROM no_such_table; ERROR 1146 (42S02): Table ... unsigned ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-fetch-field.html
If you've called mysql_real_query() or mysql_query() to perform a SELECT on a table but have not called mysql_store_result(), MySQL returns the default blob length (8KB) if you call mysql_fetch_field() to ask for the length of a BLOB field.