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/audit-log-reference.html
If instead you modify the contents of those tables directly using statements such as INSERT, UPDATE, and DELETE, the changes do not affect filtering immediately. Unless those objects are installed, the audit_log plugin operates in legacy mode. Audit ...
https://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...
https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html
You should also check for configuration files such as /etc/my.cnf or the /etc/mysql directory and delete them. These include generic binary distributions in the form of compressed tar files (files with a .tar.gz extension) for a number of platforms, ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
However, because the BLACKHOLE table does not actually store any data, UPDATE and DELETE triggers are not activated: The FOR EACH ROW clause in the trigger definition does not apply because there are no rows. The BLACKHOLE storage engine acts as a ...
https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html
Note: Undoing the above should be as simple as deleting the registry entries you've created. A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system ...
https://dev.mysql.com/doc/refman/5.7/en/channels-with-prev-replication.html
Warning Use RESET SLAVE with caution as this statement deletes all existing channels, purges their relay log files, and recreates only the default channel. When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check views for problems, such as tables that are referenced in the view definition that no longer exist. To ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html
For SET, the value is inserted as given except that any invalid substrings are deleted. ENUM and SET columns provide an efficient way to define columns that can contain only a given set of values. See Section 11.3.5, “The ENUM Type”, and ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
MODIFIES SQL DATA indicates that the routine contains statements that may write data (for example, INSERT or DELETE). By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, ...