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/mysqldump-copying-to-other-server.html
On Server 1: $> mysqldump --databases db1 > dump.sql Copy the dump file from Server 1 to Server 2. On Server 2: $> mysql < dump.sql Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-partitioning.html
There may be situations where you have a single source server and want to replicate different databases to different replicas. A sample of this layout is shown in Figure 19.2, “Replicating Databases to Separate Replicas”. Figure 19.2 ...For ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-sql-format.html
If you want to cause the dump file to force a drop of each database before recreating it, use the --add-drop-database option as well. In this case, mysqldump writes a DROP DATABASE statement preceding each CREATE DATABASE statement. Because the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
Disabling foreign_key_checks has these additional implications: It is permitted to drop a database that contains tables with foreign keys that are referenced by tables outside the database. The CONSTRAINT symbol value, if defined, must be unique in ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
There is an exception for CREATE DATABASE, ALTER DATABASE, and DROP DATABASE. The database being created, altered, or dropped is considered to be the default database when determining whether to output the statement. The server's binary log ...To ...
https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html
Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or both. Backing up the physical database ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage-common-layer.html
A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature sets that target a specific ...From a ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlshow.html
The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. Invoke mysqlshow like this: mysqlshow [options] [db_name [tbl_name [col_name]]] If no database is given, a list of database names ...The same information can be obtained by using those statements ...
https://dev.mysql.com/doc/refman/8.0/en/roles.html
Creating Roles and Granting Privileges to Them Defining Mandatory Roles Checking Role Privileges Activating Roles Revoking Roles or Role Privileges Dropping Roles User and Role Interchangeability Creating Roles and Granting Privileges to Them ...The ...Like user accounts, roles can have privileges granted to and revoked from ...
https://dev.mysql.com/doc/refman/8.0/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...