Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica-backup-restore.html
To restore the backup on a replica server, follow the same steps outlined in Section 8.1, “Setting Up a New replica”. mysqlbackup tells if that is the case by checking if the variable Replica_open_temp_tables is 0. mysqlbackup then restarts the ... To backup a replica database, add the --replica-info option to your backup ...
https://dev.mysql.com/doc/refman/8.4/en/source-ssl-library-configuration.html
To check whether a mysqld server supports encrypted connections, examine the value of the tls_version system variable: mysql> SHOW VARIABLES LIKE 'tls_version'; +---------------+-----------------+ | Variable_name | Value | ...To compile using ... An ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
MySQL Server 5.6 and higher can have CHAR columns with a length up to 255 characters. MySQL Server 5.6 and higher can have VARCHAR columns with a length up to 65535 characters. MySQL Server 5.6 and higher can have VARCHAR columns with a length up to ... The following table shows the mapping between PostgreSQL (source) data types and MySQL data ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-supported.html
When a supported RDBMS product is being migrated, the MySQL Workbench Migration Wizard will automatically convert as much information as it can, but you may still be required to manually edit the automatically migrated schema for difficult cases, ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup.html
With an active MySQL connection tab open, select MySQL Enterprise Backup from the Server menu to view the Online Backup page in the current tab. Restores the MySQL server to a specific point in time, typically by restoring a backup that was created ... Commercial releases of MySQL Workbench include a graphical interface that enables you to use MySQL Enterprise Backup (MEB) functionality to safeguard your MySQL data from unexpected ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
Determines whether to automatically reformat the View DDL that is returned by the MySQL server. Note MySQL server instances do not store the formatting information for View definitions. If this option is deselected, the changes are applied to the ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-62.html
Note GIS support for InnoDB tables was added in MySQL server 5.7. They are stored in a schema named .mysqlworkbench on the connected MySQL server. Figure 1.16 Metadata Locks Browser Note The metadata lock information is provided in the performance ... This section summarizes many of the new features added to MySQL Workbench 6.2, in relation to the MySQL Workbench 6.1 ...
https://dev.mysql.com/doc/connectors/en/connector-j-2-way-authentication.html
Apply the steps outlined in both Section 3.5.9.1, “Setting up Server Authentication” and Section 3.5.9.2, “Setting up Client Authentication” to set up a mutual, two-way authentication process in which the server and the client authenticate ...Although the typical setup described above uses the same CA certificate in both ends for mutual authentication, it does not have to be the ...
https://dev.mysql.com/doc/connectors/en/connector-j-using-openID.html
Connector/J supports authentication for users created on a MySQL server using the authentication_openid_connect plugin. The authentication requires: The connection to the server must be secure by SSL encryption. If no server user name is specified ... OpenID Connect is an authentication protocol based on the OAuth 2.0 framework, providing a simplified and interoperable ways of authentication for enhanced ...
https://dev.mysql.com/doc/connectors/en/connector-j-using-pam.html
Java applications using Connector/J can connect to MySQL servers that use the pluggable authentication module (PAM) authentication scheme. For PAM authentication to work, you must have the following: A MySQL server that supports PAM authentication.