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/rebuilding-tables.html
This can be a more convenient means of repairing tables because you can use the --databases or --all-databases option to repair all tables in specific databases or all databases, respectively: mysqlcheck --repair --databases db_name ... This ...
https://dev.mysql.com/doc/refman/8.0/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html
Suppose that a management application communicates with a set of servers that are queried by clients to access employee and product databases (named emp and prod, respectively). All servers are permitted to process data retrieval statements, but ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-issues.html
(A gap event is a type of “incident event,” which indicates an incident that occurs that affects the contents of the database but that cannot easily be represented as a set of changes. Examples of incidents are server failures, database ... This ...
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
For example, if a view is defined as SELECT * on a table, new columns added to the table later do not become part of the view, and columns dropped from the table result in an error when selecting from the view. If the OR REPLACE clause is present, ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
(Alternatively, let the 8.0 server add those directories to the data dictionary as databases, then remove each of those databases using DROP DATABASE.) If you intend to change the lower_case_table_names setting to 1 at upgrade time, ensure that ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-move-data.html
Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally with the database name. --database=dbname, -d Command-Line Format --database=name Type String Default Value TEST_DB Name ...ndb_move_data options source target Options that can be used with ndb_move_data are shown in the following ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
Data Dictionary Changes caching_sha2_password as the Preferred Authentication Plugin Configuration Changes Server Changes InnoDB Changes SQL Changes Changed Server Defaults Valid Performance Regressions Data Dictionary Changes MySQL Server 8.0 ...
https://dev.mysql.com/doc/refman/8.0/en/function-loading.html
For this reason, DROP FUNCTION requires the DELETE privilege for the mysql system database. For this reason, CREATE FUNCTION requires the INSERT privilege for the mysql system database. Uninstalling Loadable Functions To remove a loadable function, ... Loadable functions, as the name implies, must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
ALTER USER Multifactor Authentication Options As of MySQL 8.0.27, ALTER USER has ADD, MODIFY, and DROP clauses that enable authentication factors to be added, modified, or dropped. When ALTER USER adds, modifies, or drops second and third factors in ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...