Search Results
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-manual-editing.html
Figure 10.58 MySQL Workbench Migration: Manual Editing (All Objects) Column Mappings: Shows all of the table column mappings and enables you to individually review and fix the mapping for all column types, default values, and other attributes. Use ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-schema-creation.html
Table data will be migrated in a later step as well. The SQL scripts generated for the migrated schema objects will now be executed in the target database. You can monitor execution in the logs, if errors exist then they will be fixed in the next ...
https://dev.mysql.com/doc/workbench/en/wb-model-overview-privileges.html
The following figure shows the film table object from the sakila schema with INDEX, INSERT, SELECT, and TRIGGER selected for the role1 role. The Schema Privileges panel has the following sections, used to create users for your schemas and to define ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-client-connections.html
Figure 5.29 Client Connections Details Locks: MySQL uses metadata locking to manage access to objects such as tables and triggers. The client connection browser lists the active and sleeping MySQL client connections, and adds the ability to kill ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-users-and-privileges.html
To open the Administration - Users and Privileges tab: Establish a connection to an active MySQL server instance. For example, if you select the role BackupAdmin, the privileges granted include EVENT, LOCK TABLES, SELECT, SHOW DATABASES. The ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup-general-requirements.html
Setting an encryption password is required to perform backup and restore operations on encrypted tables (see Options Tab). MySQL Workbench attempts to locate the MySQL Enterprise Backup executable based on the version MySQL server in use, so check ... MySQL Enterprise Backup (MEB) is a MySQL Enterprise feature that is separate from MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-firewall.html
You can modify the plugin controls as follows: Install: Executes queries to install the new MySQL Enterprise Firewall tables and stored procedure needed to switch the state. MySQL Workbench provides a graphical interface to MySQL Enterprise ...
https://dev.mysql.com/doc/workbench/en/wb-performance-dashboard.html
Data points include the Table Open Cache efficiency, SQL Statements Executed, and counts (per second) for SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP statements. To display the dashboard, open a query tab and then click Dashboard from ...
https://dev.mysql.com/doc/workbench/en/wb-performance-query-statistics.html
The Query Stats SQL editor results tab (see the next two figures) uses Performance Schema data to gather key statistics collected for executed query, such as timing, temporary tables, indexes, joins, and more. Figure 7.5 SQL Editor: Query Stats ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-create-script.html
Tables, views, routines, routine groups, indexes, keys, and constraints can be imported from an SQL script file. To reverse-engineer a database using a create script, do one of the following: On the home screen, select the model view from the ...