PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-invoked.html
You can do this by storing in a separate table the event names from the SELECT statement shown previously, or using ALTER EVENT statements to rename the events with a common prefix such as replicated_ to identify them. If you rename the events, then ... Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
In MySQL version 5.7.5, this variable was added as simplified_binlog_gtid_recovery and in MySQL version 5.7.6 it was renamed to binlog_gtid_simple_recovery. This variable was added in MySQL version 5.7.5 as executed_gtids_compression_period and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
If you have a user created sys schema, this must be renamed for the upgrade to succeed. To upgrade in this case, remove or rename the existing sys schema first. Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for ...
https://dev.mysql.com/doc/refman/5.7/en/reserved-accounts.html
Strictly speaking, this account name is not reserved, in the sense that some installations rename the root account to something else to avoid exposing a highly privileged account with a well-known name. Use of the mysql.sys account avoids problems ... One part of the MySQL installation process is data directory initialization (see Section 2.9.1, “Initializing the Data ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
Alternatively, rename the old files to reflect your host name change. RENAME does not work with TEMPORARY tables or tables used in a MERGE table. This section lists known issues in recent versions of MySQL. For information about platform-specific ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
(It is permissible to rename or move the file, as long as you change the value of keyring_encrypted_file_data to match.) keyring_encrypted_file_password Command-Line Format --keyring-encrypted-file-password=password Introduced 5.7.21 System Variable ...These variables are unavailable unless the appropriate keyring plugin is installed (see Section 6.4.4.1, “Keyring Plugin ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
With respect to the previous examples, the ''@'localhost' and 'user2'@'%.example.com' accounts should be changed not to use wildcards: RENAME USER ''@'localhost' TO 'user1'@'localhost'; RENAME USER 'user2'@'%.example.com' TO ... Applications can use ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
To upgrade in this case, remove or rename the existing sys schema first. Use of the dedicated mysql.sys account avoids problems that occur if a DBA renames or removes the root account. MySQL 5.7 includes the sys schema, a set of objects that helps ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? A.6.4. What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition ...Can you insert into views that are based on joins? ...