MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 641 to 650 of 651 total results

https://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html

This section describes how to use mysqldump to produce dump files, and how to reload dump files. A dump file can be used in several ways: As a backup to enable data recovery in case of data loss. As a source of data for experimentation: To make a ...

5.8.1.5 Using a Stack Trace

https://dev.mysql.com/doc/refman/5.7/en/using-stack-trace.html

On some operating systems, the error log contains a stack trace if mysqld dies unexpectedly. You can use this to find out where (and maybe why) mysqld died. To get a stack trace, you must not compile mysqld with the -fomit-frame-pointer option to ...

23.9 Restrictions on Views

https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html

The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible to create an index on a view. Indexes can be used for views processed using the merge algorithm. However, a ...

23.5.1 View Syntax

https://dev.mysql.com/doc/refman/5.7/en/view-syntax.html

The CREATE VIEW statement creates a new view (see Section 13.1.21, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 13.1.10, “ALTER VIEW Statement”), or DROP VIEW (see Section 13.1.32, ...

2.3.2 Choosing an Installation Package

https://dev.mysql.com/doc/refman/5.7/en/windows-choosing-package.html

For MySQL 5.7, there are multiple installation package formats to choose from when installing MySQL on Windows. The package formats described in this section are: MySQL Installer MySQL noinstall ZIP Archives MySQL Docker Images Program Database ...

2.3.4.1 Extracting the Install Archive

https://dev.mysql.com/doc/refman/5.7/en/windows-extract-archive.html

To install MySQL manually, do the following: If you are upgrading from a previous version please refer to Section 2.10.8, “Upgrading MySQL on Windows”, before beginning the upgrade process. Make sure that you are logged in as a user with ...

6.4.1.8 Windows Pluggable Authentication

https://dev.mysql.com/doc/refman/5.7/en/windows-pluggable-authentication.html

Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition for Windows supports an authentication method that performs external authentication on Windows, enabling ...

8.12.3.3 Using Symbolic Links for Databases on Windows

https://dev.mysql.com/doc/refman/5.7/en/windows-symbolic-links.html

On Windows, symbolic links can be used for database directories. This enables you to put a database directory at a different location (for example, on a different disk) by setting up a symbolic link to it. Use of database symlinks on Windows is ...

2.10.8 Upgrading MySQL on Windows

https://dev.mysql.com/doc/refman/5.7/en/windows-upgrading.html

There are two approaches for upgrading MySQL on Windows: Using MySQL Installer Using the Windows ZIP archive distribution The approach you select depends on how the existing installation was performed. Before proceeding, review Section 2.10, ...

19.4.2.2 X Plugin Options and System Variables

https://dev.mysql.com/doc/refman/5.7/en/x-plugin-options-system-variables.html

To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Introduced 5.7.12 Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X ...

Displaying 641 to 650 of 651 total results