Search Results
https://dev.mysql.com/doc/refman/8.4/en/upgrade-before-you-begin.html
If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it may be useful to create a test instance for assessing the conversions that are required and the work involved to perform ...The backup should include the mysql system database, which contains the MySQL data dictionary tables and system ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-troubleshooting.html
If you have created a loadable function with a given name and upgrade MySQL to a version that implements a new built-in function with the same name, the loadable function becomes inaccessible. To correct this, use DROP FUNCTION to drop the loadable ... A schema mismatch in a MySQL 8.3 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 8.4 to ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html
When upgrading to MySQL 8.4.4 or later, it is recommended that you drop any spatial indexes beforehand, then re-create them after the upgrade is complete. Alternatively, you can drop and re-create such indexes immediately following the upgrade, but ... Before upgrading to MySQL 8.4, review the changes described in the following sections to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/refman/8.4/en/using-mysqldump.html
This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. The output can be saved in a file and reloaded later using mysql to recreate the ... Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and MySQL HeatWave compatibility checks and ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-reference.html
The following functions permit the server's list of version tokens to be created, changed, removed, and inspected. If a token does not exist, it is created with the given value. The following discussion serves as a reference to these Version Tokens ...
https://dev.mysql.com/doc/refman/8.4/en/workbench.html
MySQL Workbench provides five main areas of functionality: SQL Development: Enables you to create and manage connections to database servers. Data Modeling: Enables you to create models of your database schema graphically, reverse and forward ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-status-variables.html
Mysqlx_aborted_clients The number of clients that were disconnected because of an input or output error. Mysqlx_address The network address or addresses for which X Plugin accepts TCP/IP connections. If multiple addresses were specified using the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-encryption-options.html
These options are for creating encrypted single-file backups and for decrypting them. --encrypt Encrypt the data when creating a backup image by a backup-to-image operation, or when packing a backup directory into a single file with the ...See ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-message-logging-options.html
mysqlbackup writes important progress and error information to the stderr stream. The information is often very valuable for tracking down problems that occur during an operation. Starting from MySQL Enterprise Backup 3.9, the output to the stderr ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
See Section 4.3.4, “Making a Compressed Backup” and Section 20.6, “Compression Options” for information about creating compressed backups. (The copying and scanning mechanisms used by mysqlbackup do not rely on indexes to do their work.) For ... This section describes the performance considerations for backing up a database with MySQL Enterprise ...