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/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.
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
Instead, it causes the binary (_bin) collation for the column character set (or the table default character set if no column character set is specified) to be used, and the column itself stores nonbinary character strings rather than binary byte ...
https://dev.mysql.com/doc/refman/8.0/en/calculating-days.html
CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 VALUES(2000,1,1),(2000,1,20),(2000,1,30),(2000,2,2), (2000,2,23),(2000,2,23); The example table contains year-month-day values representing visits by users to the page. The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web ...