Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica-backup-restore.html
To backup a replica database, add the --replica-info option to your backup command. To restore the backup on a replica server, follow the same steps outlined in Section 8.1, “Setting Up a New replica”. MySQL Enterprise Backup does not include ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-agent-user-password.html
Execute the following statement, where newuser is the new user name, and newpass is the new password: SET PASSWORD FOR 'newuser'@'127.0.0.1' = PASSWORD('newpass'); Use mcmd for the user name if you have not changed it—that is, if mcmd-user has ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-set.html
To set an attribute on the process level, use a set statement that contains an attribute assignment having the form attribute_name:process_name=value. The set statement does not contain any additional parameters that only affect a ndb_mgmd or mysqld ...Attributes can be set on either the process level or instance ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-bind-param.html
Attributes defined with mysql_bind_param() apply to nonprepared statements executed in blocking fashion with mysql_real_query() or mysql_query(), or in nonblocking fashion with mysql_real_query_nonblocking(). For a description of the members of the ... bool mysql_bind_param(MYSQL *mysql, unsigned n_params, MYSQL_BIND *bind, const char **name) Description mysql_bind_param(), available as of MySQL 8.0.23, enables defining attributes that apply to the next query sent to the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string.html
unsigned long mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL statement. If you must change the character set of the connection, use the ...Note mysql_real_escape_string() fails and produces an CR_INSECURE_API_ERR error if the NO_BACKSLASH_ESCAPES SQL mode is ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-bind-param.html
bool mysql_stmt_bind_param(MYSQL_STMT *stmt, MYSQL_BIND *bind) Description mysql_stmt_bind_param() is used to bind input data for the parameter markers in the SQL statement that was passed to mysql_stmt_prepare(). The client library expects the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-num-rows.html
The use of mysql_stmt_num_rows() depends on whether you used mysql_stmt_store_result() to buffer the entire result set in the statement handler. mysql_stmt_num_rows() is intended for use with statements that return a result set, such as SELECT. For ... uint64_t mysql_stmt_num_rows(MYSQL_STMT *stmt) Description Returns the number of rows in the result ...
https://dev.mysql.com/doc/c-api/8.4/en/null-mysql-store-result.html
You can always check whether the statement should have produced a nonempty result by calling mysql_field_count(). If mysql_field_count() returns zero, the result is empty and the last query was a statement that does not return values (for example, ... It is possible for mysql_store_result() to return NULL following a successful call to the server using mysql_real_query() or ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-native-function.html
If the native function will be referred to in statements that will be replicated to replicas, you must ensure that every replica also has the function available. To provide a name by which the function can be referred to in SQL statements, register ... To add a native MySQL function, use the procedure described here, which requires that you use a source ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-api-characteristics.html
Each plugin has a name that it can be referred to in SQL statements, as well as other metadata such as an author and a description that provide other information. This information can be examined in the INFORMATION_SCHEMA.PLUGINS table or using the ... The server plugin API has these characteristics: All plugins have several things in ...