PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
mysqldump performs a full table scan, which means its queries can often exceed a long_query_time setting that is useful for regular queries. From MySQL 8.0.30, if you want to exclude most or all of mysqldump’s queries from the slow query log, you ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
-DWITH_DEVELOPER_ENTITLEMENTS=bool Whether to add the get-task-allow entitlement to all executables to generate a core dump in the event of an unexpected server halt. On macOS 11+, core dumps are limited to processes with the ... The CMake program ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
For object definitions that refer to the utf8mb4 character set, you can dump them with mysqldump prior to downgrading, edit the dump file to change instances of utf8mb4 to utf8, and reload the file in the older server, as long as there are no 4-byte ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
row *************************** Table: t1 Create Table: CREATE TABLE `t1` ( `i` int DEFAULT NULL, `j` int DEFAULT NULL, `k` int DEFAULT NULL /*!80023 INVISIBLE */ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci mysqldump and ...An ...
https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
A mysqldump dump includes statements to recreate those tables so that they are not missing after reloading the dump file. MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, ...
https://dev.mysql.com/doc/refman/8.0/en/lz4-decompress.html
Invoke lz4_decompress like this: lz4_decompress input_file output_file Example: mysqlpump --compress-output=LZ4 > dump.lz4 lz4_decompress dump.lz4 dump.txt To see a help message, invoke lz4_decompress with no arguments. The lz4_decompress utility ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-server-id.html
You can use mysqlbinlog to request log files from a server in several ways: Specify an explicitly named set of files: For each file, mysqlbinlog connects and issues a Binlog dump command. Specify the beginning file and --to-last-log: mysqlbinlog ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/replication-options-gtids.html
If you are restoring a backup that is disjoint from the transactions that are already on the server, for example provisioning a multi-source replica using dumps from two different servers, use the second method of adding to the value of gtid_purged.
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-partitioning.html
Use mysqldump to create a separate dump file for each database and load the appropriate dump file on each replica. Use a raw data file dump and include only the specific files and databases that you need for each replica. There may be situations ...