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/glossary.html
Although conceptually it has the same result as a DELETE statement with no WHERE clause, it operates differently behind the scenes: InnoDB creates a new empty table, drops the old table, then renames the new table to take the place of the old one.
https://dev.mysql.com/doc/refman/5.7/en/grant.html
CREATE USER Enable use of CREATE USER, DROP USER, RENAME USER, and REVOKE ALL PRIVILEGES. If you do that, the user can try to subvert the privilege system by renaming tables! For additional information about security risks associated with particular ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT OPTION | resource_option} ...] GRANT PROXY ON user TO user [, user] ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
ALTER USER, CREATE USER, DROP USER, GRANT, RENAME USER, REVOKE, SET PASSWORD. The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
For example, a table rename failure could result in a “missing” *.ibd file without an MLOG_FILE_DELETE record. In this case, you could manually rename the tablespace file and restart crash recovery, or you could restart the server in recovery ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
If you delete or rename the table, the files that its symbolic links point to also are deleted or renamed. When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-flush.html
In addition, if you use FLUSH TABLES when renaming a MyISAM table that is part of a MERGE table, you must issue FLUSH TABLES manually on the replicas. Some forms of the FLUSH statement are not logged because they could cause problems if replicated ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...
https://dev.mysql.com/doc/refman/5.7/en/show-open-tables.html
Name locking is used for operations such as dropping or renaming tables. SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table cache. The FROM ...
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
Be sure to delete or rename any old configuration files when upgrading MySQL. When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. This section helps you diagnose and ...