Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-setup-replicas.html
If you are setting up a new replication environment using the data from a different existing database server to create a new source, run the dump file generated from that server on the new source. The process for importing data to the replica ...
https://dev.mysql.com/doc/refman/9.7/en/resignal.html
RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but instead of originating a condition as SIGNAL does, RESIGNAL relays existing condition information, possibly after modifying it. RESIGNAL makes it ...
https://dev.mysql.com/doc/refman/9.7/en/show-table-status.html
Create_options shows the ENCRYPTION clause for file-per-table tablespaces if the table is encrypted or if the specified encryption differs from the schema encryption. The encryption clause is not shown for tables created in general tablespaces. When ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works like SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-type-overview.html
For other examples showing how to use spatial data types in MySQL, see Section 13.4.6, “Creating Spatial Columns”. MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The ...
https://dev.mysql.com/doc/refman/9.7/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.27, “CREATE VIEW Statement”). A view can be created from many kinds of SELECT statements. To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.13, ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-incremental-options.html
This is potentially the fastest way for mysqlbackup to create incremental backups. --incremental-with-redo-log-only Specifies that an incremental backup is to be created using only the redo log. This alternate type of incremental backup has ... For ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-repository-options.html
When the --with-timestamp option is also specified, an additional level of subdirectory, with the timestamp in its name, is created under --backup-dir (see description for the --with-timestamp option for details). When restoring a single-file backup ... These options specify various parameters related to the backup image or directory, or to how the backup will be ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/replicaset-adopting.html
As an alternative to creating a ReplicaSet from scratch, you can adopt an existing replication setup using the adoptFromAR option with dba.createReplicaSet(). The replication setup is scanned, and if it is compatible with the InnoDB ReplicaSet ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/upgrade-mysql-clusterset.html
On a Unix system, if you used the optional --directory bootstrap option, a self-contained installation is created with all generated directories and files at the location you selected when you bootstrapped the router. Navigate to this directory and ... To upgrade the server instances in an InnoDB ClusterSet, complete the following steps: Upgrade MySQL ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates.html
This section provides an overview of creating and modifying DBDoc Model Reporting templates, as used by MySQL Workbench. It is these output files, typically HTML or text, that are then viewed by the user. The MySQL Workbench DBDoc Model Reporting ...