Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-copying-database.html
$> mysqldump db1 > dump.sql $> mysqladmin create db2 $> mysql db2 < dump.sql Do not use --databases on the mysqldump command line because that causes USE db1 to be included in the dump file, which overrides the effect of naming db2 on the mysql ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-copying-to-other-server.html
On Server 1: $> mysqldump --databases db1 > dump.sql Copy the dump file from Server 1 to Server 2. On Server 2: $> mysql < dump.sql Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE ...Then ...
https://dev.mysql.com/doc/refman/8.4/en/number-literals.html
In MySQL, the DECIMAL type has several synonyms: NUMERIC, DEC, FIXED. In MySQL, types that are synonymous with FLOAT or DOUBLE are DOUBLE PRECISION and REAL. Number literals include exact-value (integer and DECIMAL) literals and approximate-value ...
https://dev.mysql.com/doc/refman/8.4/en/obtaining-loadable-function-information.html
The Performance Schema user_defined_functions table contains information about the currently installed loadable functions: SELECT * FROM performance_schema.user_defined_functions; The mysql.func system table also lists installed loadable functions, ...The user_defined_functions table lists loadable functions installed using CREATE FUNCTION as well as loadable functions installed automatically by components or ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb.html
InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important. This section explains how to optimize database operations for InnoDB tables.
https://dev.mysql.com/doc/refman/8.4/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Database administrators should use the following guidelines to keep passwords secure. Access to this table should never be granted to any nonadministrative accounts. Account ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-clone-status-table.html
The clone_status table has these columns: ID A unique cloning operation identifier in the current MySQL server instance. BEGIN_TIME A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the cloning operation started. END_TIME A ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-tables.html
The following sections describe the Performance Schema tables associated with MySQL Enterprise Firewall (see Section 8.4.7, “MySQL Enterprise Firewall”). They provide information about firewall operation: firewall_groups: Information about ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-keyring-component-status-table.html
The keyring_component_status table provides status information about the properties of the keyring component in use, if one is installed. The table is empty if no keyring component is installed (for example, if the keyring is not being used, or is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-keyring-keys-table.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. Key metadata includes key IDs, key owners, and backend key IDs. The keyring_keys table does not expose ...