Search Results
https://dev.mysql.com/doc/refman/8.4/en/use.html
The named database remains the default until the end of the session or another USE statement is issued: USE db1; SELECT COUNT(*) FROM mytable; # selects from db1.mytable USE db2; SELECT COUNT(*) FROM mytable; # selects from db2.mytable The database ... USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent ...
https://dev.mysql.com/doc/refman/8.4/en/windows-symbolic-links.html
After this, all tables created in the database mydb are created in D:\data\mydb. After this, all tables created in the database mydb are created in D:\data\mydb. On Windows, symbolic links can be used for database directories. This enables you to ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-metadata-options.html
Some metadata is stored in the backup directory, other metadata is stored in tables within the mysql database of the backed-up instance. --no-history-logging Turns off the recording of backup progress and history in logging tables inside the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-group-replication.html
When working with a Group Replication setup, mysqlbackup makes the backup information available to all members of the server group by making sure that the backup_history, backup_sbt_history (when using the SBT API), and backup_progress tables are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-troubleshooting.html
As mysqlbackup proceeds, it writes progress information into the mysql.backup_progress table. When the command finishes the backup operation, it records status information in the mysql.backup_history table. You can query those tables to monitor ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.backup.html
The unique ID for this backup job is recorded in special tables that mysqlbackup creates inside the MySQL instance, allowing you to monitor long-running backups and view information on previous backups. In the following illustration, we back up an ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore.html
The restored data includes the backup_history table, where MySQL Enterprise Backup records details of each backup. The table allows you to perform future incremental backups using the --incremental-base=history:{last_backup | last_full_backup} ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-multiple-queries.html
After the connection to the server has been established, you can use the mysql_set_server_option() function to enable or disable multiple-statement execution by passing it an argument of MYSQL_OPTION_MULTI_STATEMENTS_ON or ... By default, ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-connect.html
mysql_real_connect() attempts to establish a connection to a MySQL server running on host. If passwd is NULL, only entries in the user table for the user that have a blank (empty) password field are checked for a match. See the note following this ... MYSQL * mysql_real_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned long client_flag) Description Note mysql_real_connect() is a synchronous ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-use-result.html
MYSQL_RES * mysql_use_result(MYSQL *mysql) Description After invoking mysql_real_query() or mysql_query(), you must call mysql_store_result() or mysql_use_result() for every statement that successfully produces a result set (SELECT, SHOW, DESCRIBE, ...You must also call mysql_free_result() after you are done with the result ...