PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
In-Place Upgrade Logical Upgrade In-Place Upgrade An in-place upgrade involves shutting down the old MySQL server, replacing the old MySQL binaries or packages with the new ones, restarting MySQL on the existing data directory, and upgrading any ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html
For example: docker run --name mysql1 -d mysql/mysql-server:tag --character-set-server=utf8mb4 --collation-server=utf8mb4_col The command starts your MySQL Server with utf8mb4 as the default character set and utf8mb4_col as the default collation for ...A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Included binaries are limited to: /usr/bin/my_print_defaults /usr/bin/mysql /usr/bin/mysql_config /usr/bin/mysql_install_db /usr/bin/mysql_tzinfo_to_sql /usr/bin/mysql_upgrade /usr/bin/mysqladmin /usr/bin/mysqlcheck /usr/bin/mysqldump /usr/bin/mysqlpump /usr/sbin/mysqld All binaries are stripped; they contain no debug ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, you must perform the recovery using a backup. In some cases of database corruption, it is enough to dump, drop, and re-create one or a few ...To ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
It is possible to write a plugin that replaces the built-in full-text parser. By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. A collection is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-setup-replicas.html
To do this, execute the following statement on the replica, replacing the option values with the actual values relevant to your system: mysql> CHANGE MASTER TO -> MASTER_HOST='source_host_name', -> MASTER_USER='replication_user_name', -> ...Before ...
https://dev.mysql.com/doc/refman/5.7/en/workbench.html
MySQL Workbench provides a graphical tool for working with MySQL servers and databases. MySQL Workbench provides five main areas of functionality: SQL Development: Enables you to create and manage connections to database servers. As well as ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ... To ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-provision-replica.html
In a multi-source replication topology, copying the data directory cannot be used to provision the replica with data from all of the sources, and you might also want to replicate only specific databases from each source. In MySQL 5.6 and 5.7, the ...
https://dev.mysql.com/doc/refman/5.7/en/apis-perl.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. Optionally, the DBD module for any other type of database server you want to access. It ...To use DBI with MySQL, install the following: The DBI ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
The cache_policies table, config_options table, and containers table are created by the innodb_memcached_config.sql configuration script in the innodb_memcache database. mysql> USE innodb_memcache; Database changed mysql> SHOW TABLES; ... InnoDB API ...