PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html
A group of MySQL servers can be configured to create a cluster using MySQL Shell. A minimum of three servers are required to create a high availability cluster. It is important to back up your databases so that you can recover your data and be up ...
https://dev.mysql.com/doc/refman/8.0/en/full-text-adding-collation.html
The instructions here add a collation for a simple character set, which as discussed in Section 12.14, “Adding a Collation to a Character Set”, can be created using a configuration file that describes the character set properties. For a complex ... Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-example.html
You may also specify these parameters on the command line when invoking the executables. You may also use a separate [mysql_cluster] section in the cluster my.cnf file for settings to be read and used by all executables: # cluster-specific settings ... To support NDB Cluster, you should update my.cnf as shown in the following ...
https://dev.mysql.com/doc/refman/8.0/en/security-guidelines.html
A passphrase containing multiple words is easy to create, remember, and reproduce, and is much more secure than a typical user-selected password consisting of a single modified word or a predictable sequence of characters. To create a secure ...When ... Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-metadata.html
To obtain metadata about stored routines: Query the ROUTINES table of the INFORMATION_SCHEMA database. Use the SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION statements to see routine definitions. Use the SHOW PROCEDURE STATUS and SHOW FUNCTION ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it ...Important Downgrade from MySQL 8.0 to MySQL 5.7, or from a MySQL 8.0 release to a previous MySQL 8.0 release, is not ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-troubleshooting.html
A schema mismatch in a MySQL 5.7 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 8.0 to fail. To address this issue, dump and restore affected tables before attempting the upgrade again. If you ...If problems occur, such as that the new mysqld server does not start, verify that you do not have an old my.cnf file from your previous ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-file.html
Configuring NDB Cluster requires working with two files: my.cnf: Specifies options for all NDB Cluster executables. This file, with which you should be familiar with from previous work with MySQL, must be accessible by each executable running in ...
https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html
This script assists in creating the error log file only if the log location matches a pattern (/var/log/mysql*.log for RPM platforms, /var/log/mysql/*.log for Debian platforms). In other cases, the error log directory must be writable or the error ...If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake ...
https://dev.mysql.com/doc/refman/8.0/en/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.