PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/using-mysqldump.html
As a source of data for experimentation: To make a copy of a database that you can use without changing the original data. This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and ...
https://dev.mysql.com/doc/refman/8.0/en/windows-choosing-package.html
The package formats described in this section are: MySQL Installer MySQL noinstall ZIP Archives MySQL Docker Images Program Database (PDB) files (with file name extension pdb) provide information for debugging your MySQL installation in the event of ... For MySQL 8.0, there are multiple installation package formats to choose from when installing MySQL on ...
https://dev.mysql.com/doc/refman/8.0/en/windows-installation-layout.html
Table 2.4 Default MySQL Installation Layout for Microsoft Windows Directory Contents of Directory Notes bin mysqld server, client and utility programs %PROGRAMDATA%\MySQL\MySQL Server 8.0\ Log files, databases The Windows system variable ... For ...
https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html
ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. An ALTER LOGFILE GROUP statement has ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html
This is done because InnoDB and these operating systems cannot drop a table that is in use. If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new ...
https://dev.mysql.com/doc/refman/8.0/en/alter-view.html
This statement requires the CREATE VIEW and DROP privileges for the view, and some privilege for each column referred to in the SELECT statement. ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER ...
https://dev.mysql.com/doc/refman/8.0/en/audit-api-message-emit.html
Because installing and uninstalling the audit_api_message_emit component installs and uninstalls the audit_api_message_emit_udf() function that the component implements, it is not necessary to use CREATE FUNCTION or DROP FUNCTION to do so. As of ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
A disadvantage of PERFORMANCE strategy is that it drops events when the buffer is full. This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature-windows.html
Either drag and drop the signature (.asc) file into Kleopatra, or load the dialog from File, Decrypt/Verify Files..., and then choose either the .msi or .asc file. The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html
To view undo tablespace file names on the donor to ensure that they are unique, query INFORMATION_SCHEMA.FILES: mysql> SELECT TABLESPACE_NAME, FILE_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE LIKE 'UNDO LOG'; For information about dropping ...