Search Results
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
The server interprets the file name using the character set indicated by the character_set_filesystem system variable. By default, the server interprets the file contents using the character set indicated by the character_set_database system ...For ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.restore.html
To restore a MySQL instance from a backup to a database server: Shut down the database server. Use, for example, the copy-back-and-apply-log command, which converts the raw backup into a prepared backup by updating it to a consistent state, and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
mysql sends each SQL statement that you issue to the server to be executed. For server side help, type 'help contents' If mysql is invoked with the --binary-mode option, all mysql commands are disabled except charset and delimiter in noninteractive ...There is also a set of commands that mysql itself ...
https://dev.mysql.com/doc/refman/8.4/en/charset-applications.html
This causes the server to use the given settings for all applications that do not make other arrangements. This causes the server to use the given settings as the defaults for all applications, without having to specify them at server startup. If ...
https://dev.mysql.com/doc/refman/8.4/en/reusing-ssl-sessions.html
Server-Side Runtime Configuration and Monitoring for SSL Session Reuse To create the initial TLS context, the server uses the values that the context-related system variables have at startup. The following table shows the system variables that ...By ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
If the value is NULL (the default), the global expiration policy applies, as defined by the default_password_lifetime system variable. The mysql system database includes several grant tables that contain information about user accounts and the ...
https://dev.mysql.com/doc/internals/en/capability-flags.html
The capability flags are used by the client and server to indicate which features they support and want to use. Value 0x00000080 Server Enables the LOCAL INFILE request of LOAD DATA|XML. See mysql_real_connect() CLIENT_TRANSACTIONS Value 0x00002000 ...Value 0x00000001 CLIENT_FOUND_ROWS Send found rows instead of affected rows in ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/services-for-plugins.html
Available services include the following: get_sysvar_source: A service that enables plugins to retrieve the source of system variable settings. This service provides setter and getter routines to access attributes of the server Security_context ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.incremental.html
A system variable, innodb_redo_log_capacity, controls the amount of disk space occupied by redo log files. For convenience, you can use the --incremental-base option to automatically derive the necessary log sequence number (LSN) from the metadata ...In order to that, after making first a full backup that contains all data, you can do one of the following: Performing a series of differential ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
(See Section 7.1.8, “Server System Variables”.) If you want all your tables to be able to grow above the default limit and are willing to have your tables slightly slower and larger than necessary, you can increase the default pointer size by ...