Search Results
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-create-target.html
The generated objects are listed here, along with the error messages if any exist. The migration code may also be viewed and edited here (see the figure that follows). To make changes, select an object, edit the query code, and click Apply. Note ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-data-migration-setup.html
Options: Truncate target tables before copying data: In case the target database already exists, this will delete said data. Transfers data from the source RDBMS to the target MySQL database (see the figure that follows). The setup screen includes ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-schema-creation.html
You can monitor execution in the logs, if errors exist then they will be fixed in the next step. The SQL scripts generated for the migrated schema objects will now be executed in the target database. Table data will be migrated in a later step as ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-methods-ssh.html
You can convert an existing PuTTY Private Key (ppk) file to OpenSSH format by using the PuTTY Key Generator (PuTTYGen) utility. This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP over an SSH connection.
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-status-variables.html
The Administration - Status and System Variables secondary tab lists the full set of server variables for the active MySQL connection. You may also copy all or selected variables to your clipboard. You can open this secondary tab from either the ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-secure-auth.html
However, upgrading MySQL does not automatically update the old password passwords, so existing passwords continue to be stored in the deprecated format. MySQL 4.1 extended password hashes from 16 to 41 bytes. This is because MySQL does not store ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-ssl-wizard.html
Generate new certificates and self-signed keys: Check this to generate new files, otherwise the existing files are used. This wizard helps create SSL certificates for both MySQL clients and MySQL servers. Connections in MySQL Workbench are updated ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup-online-backup.html
This section describes how to configure a backup profile that defines what should be backed up, where the backup should be stored, and when (the frequency) it should be backed up. With an active MySQL connection tab open, select MySQL Enterprise ...
https://dev.mysql.com/doc/workbench/en/wb-notes-physical-schemata.html
If a note with this name already exists, the new note is named note2. Double-clicking the Add Note icon in the Model Notes section of the MySQL Model page adds a note with the default name of note1. Adding a new note automatically opens the note ...
https://dev.mysql.com/doc/workbench/en/wb-relationship-tools.html
Typically this occurs where an intermediary table is created to resolve a many-to-many relationship. In such cases, the primary key is usually a composite key made up of the primary keys from the two original tables. A non-identifying relationship: ...