Search Results
https://dev.mysql.com/doc/refman/8.4/en/my-print-defaults.html
For example, the mysqlcheck program reads the [mysqlcheck] and [client] option groups. To see what options are present in those groups in the standard option files, invoke my_print_defaults like this: $> my_print_defaults mysqlcheck client ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-ftdump.html
If your working directory is the test database directory, invoke myisam_ftdump as follows: myisam_ftdump mytexttable 1 If the path name to the test database directory is /usr/local/mysql/data/test, you can also specify the table name argument using ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...
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 ...