Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
Querying data that has been put into a read-only state for security or data integrity reasons, such as archived backup data. The instance must have performed a slow shutdown before being put into the read-only state. You can query InnoDB tables ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory is required in the buffer pool, and less I/O is required to write out updated values. The row format of a table determines how its rows are ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-migration.html
If the running server was using the destination keystore before the migration and should continue to use it after the migration, it should be restarted after the migration to load all keys migrated into the destination keystore. If the running ... A ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-native.html
For Red Hat and similar distributions, the MySQL distribution is divided into a number of separate packages, mysql for the client tools, mysql-server for the server and associated tools, and mysql-libs for the libraries. Many Linux distributions ...
https://dev.mysql.com/doc/refman/8.4/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-pkg.html
When installing using the package installer, the files are installed into a directory within /usr/local matching the name of the installation version and platform. For example, the installer file mysql-8.4.8-macos10.15-x86_64.dmg installs MySQL into ... The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-backups.html
The backup files can be copied into any directory on the computer where the replica's management host resides, as long as the MySQL and NDB binaries have read permissions in that directory. In this case, we assume that these files have been copied ... This section discusses making backups and restoring from them using NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
INTO OUTFILE to write the files, so you must have the FILE privilege to perform this operation, and an error occurs if a given .txt file already exists. INTO OUTFILE.) To enable data files to be written using a different format, mysqldump supports ... This section describes how to use mysqldump to create delimited-text dump ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-sql-format.html
This ensures that when the dump file is reloaded, it creates each database if it does not exist and makes it the default database so database contents are loaded into the same database from which they came. For reloading, you can specify a database ... This section describes how to use mysqldump to create SQL-format dump ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-upgrade-testing.html
Then you can dump the database and database object definitions from the production server and load them into the new server to verify that they are handled properly. After you have verified that the definitions are handled properly, dump the data ...