Some menu items are not available in the MySQL Workbench Community edition of this application, and are available only in the MySQL Workbench commercial editions;. This is indicated where applicable.
mydb. Choosing opens a file dialog box with the default file
type set to MySQL Workbench Models (
extension). To display a list of recently opened MWB files, choose
the menu item. The keyboard
shortcut to create a new project is Control+N and
the command to open an existing project is
To close the currently active
MySQL Model or
EER Diagram tab, use the menu item. You can also do this from the
keyboard by pressing Control+W. To reopen the
MySQL Model tab, see
Section 220.127.116.11.3, “The View Menu”. To reopen an
Diagram tab, double-click the
Diagram icon in the
section of the
MySQL Model page.
Use the mysqldump
--no-data. MySQL Workbench handles the
script as follows:
If the script does not contain a
CREATE DATABASEstatement, the schema objects are copied to the default schema,
If the script creates a database, a new tab bearing the database name is added to the
Physical Schematasection of the
If the script contains data, the data is ignored.
For details about importing a DDL script, see Section 18.104.22.168, “Reverse Engineering Using a Create Script”.
There are variety of items under the Section 22.214.171.124, “Forward Engineering Using an SQL Script”.submenu. You may generate the SQL statements necessary to create a new database or alter an existing one. For more information about these menu items, see
Themenu item enables you to set the paper size, orientation, and margins for printing purposes.
The printing options are enabled only if the EER Diagrams tab is selected. You have the choice of printing your model directly to your printer, printing it as a PDF file, or creating a PostScript file. For more information, see Section 9.2.1, “Printing Diagrams”.
The printing options are available only in commercial versions of MySQL Workbench.
Use themenu item to set the following properties of your project:
Name: The model name (default is
Version: The project version number
Author: The project author
Project: The project name
Created: Not editable; determined by the MWB file attributes
Last Changed: Not editable; determined by the MWB file attributes
Description: A description of your project
Use themenu to make changes to objects. The menu item text descriptions change to reflect the name of the selected object.
This menu has items for cutting, copying, and pasting. These actions can also be performed using the Control+X, Control+C, and Control+V key combinations. Undo a deletion using the item. The Control+Z key combination can also be used to undo an operation. It is also possible to carry out a operation using either the menu item, or the key combination Control+Y.
Also find a Control+Delete. You can also right-click an object and choose the delete option from the pop-up menu.menu item for removing the currently selected object. The keyboard command for this action is
The EER Diagram is active and a table on the canvas is the currently selected object, a dialog box may open asking whether you want to remove the table from the canvas only or from the database as well. For information about setting the default behavior when deleting from an EER Diagram, see Section 3.2.4, “Modeling Preferences”.menu item behaves differently depending upon circumstances. For example, if an
MySQL Model page is active, the
selected object is deleted from the catalog and there will be
no confirmation dialog box.
Choose Control+E and Control+Shift+E, respectively.to edit the currently selected object. You can also perform edits in a new window by selecting . The keyboard shortcuts for and are
Theitem has the following submenus:
Control+A): Selects all the objects on the active EER diagram.(Keyboard shortcut,
These menu items are active only when an EER Diagram tab is selected. The and the menu items are disabled if no object is currently selected on an EER diagram.
When multiple objects have been selected using one of these menu items, you can navigate between selected items by choosing theor menu item.
Selecting objects changes some of themenu items. If only one object is selected, that object's name appears after the , and menu items. If more than one object is selected, these menu items show the number of objects selected.
Each MySQL Workbench window includes search functionality. Thepanel with enabled is shown below:
The Find dialogue options are described below:
And the arrows jump to the discovered search terms, and behave according to theoption.
The MySQL Workbench commercial editions include an advanced Find facility for models:
You can search the following locations:
Entire Model: Searches the entire model.
Current View: Searches the current view only. This may be the
All Views: Searches the
MySQL Model Pageand all EER diagrams.
Database Objects: Searches database objects only.
Selected Figures: Searches the currently selected objects. This feature works only for EER diagrams.
Enter the text you wish to search for in the Find Text list. You may also select any or all of the following check boxes:
Use Regular Expression
Search in Comments
Search in SQL for Views, SPs etc.
Any text you enter into the Find Text list is retained for the duration of your session. Use the or buttons to find occurrences of your search criterion.
Clicking the Find Results window anchored at the bottom of the application. If you wish, you may undock this window as you would any other.button opens a
Use this window to navigate to objects. For example,
Description of an object
located on an EER diagram navigates to the specific diagram and
selects the object. Notice that the properties of the object are
displayed in the
Find dialog window can also be opened
using the Control+F key combination. Use
Control+G to find the next occurrence and
Control+Shift+G to find a previous occurrence.
Find dialog window by clicking the
in the top right corner or by pressing
the Esc key.
This menu item enables you to set global preferences for the MySQL Workbench application.
For further information, see Section 3.2, “Workbench Preferences”.
This context-aware menu features general options for changing the view in MySQL Workbench. These options change depending on the current tab, and here are the availablemenu items:
The ability to zoom in on an EER diagram is also available using the slider tool in the
Model Navigatorpalette. See Section 126.96.36.199, “The Model Navigator Panel”.
Control+Shift and the number of the marker (1 through 9). You may create up to nine markers.: Bookmarks an object. From the keyboard, select the object you wish to bookmark, then use the key combination
Control key and the number of the marker.: Returns to a marker. From the keyboard, use the
Themenu items apply only to objects on an EER diagram canvas and are enabled only if an EER diagram view is active. The menu has these items:
Classic, do not permit expansion or contraction. Indexes will not automatically be expanded unless they were previously expanded and have been collapsed using the menu item.
When a model is opened, this menu features actions to perform against your model, and themenu has these items:
Control+T.: Creates a new EER Diagram. The keyboard shortcut is
Section 188.8.131.52.5.1, “The DBDoc Model Reporting Dialog Window (Commercial Version)”. Commercial version only.: For information about this menu item, see
Section 184.108.40.206.5.2, “The Validation Submenus (Commercial Version)”. Commercial version only.: Checks the validity of the model using ANSI standards. For information about this menu item, see
Section 220.127.116.11.5.2, “The Validation Submenus (Commercial Version)”. Commercial version only.: Checks the validity of the model using MySQL standards. For information about this menu item, see
When you have tables with numerous columns, use this menu item to increase the size of the EER.
For more information about Workbench Preferences, see Section 3.2.4, “Modeling Preferences”.
This dialog window is found by navigating to themenu and choosing the item.
Thefeature is only available in the MySQL Workbench commercial editions.
Use this dialog window to set the options for creating documentation of your database models. For more information, see Section 9.2.2, “DBDoc Model Reporting”.
Themenu has two validation submenus, and . Use these submenus for general validation and MySQL-specific validation of the objects and relationships defined in your model.
These items are only available in the MySQL Workbench commercial editions.
Thesubmenu has these items:
Thesubmenu has these items:
For detailed information about validation, see Section 9.2.3, “Schema Validation Plugins”.
The items under the, submenu apply exclusively to an EER diagram. They are not enabled unless an EER diagram tab is selected.
Thesubmenu has these items:
Workbench (Simplified)style showing only the table's columns
The object notation style that you choose persists for the duration of your MySQL Workbench session and is saved along with your model. When MySQL Workbench is restarted, the object notation reverts to the default.
If you plan to export or print an EER diagram be sure to decide on a notation style first. Changing notation styles after objects have been placed on a diagram can significantly change the appearance of the diagram.
The items under thesubmenu apply exclusively to an EER diagram. They are not enabled unless an EER diagram tab is selected.
Thesubmenu has these items:
To view the different styles, set up a relationship between two or more tables and choose the different menu items.
The relationship notation style that you choose persists for the
duration of your MySQL Workbench session and is saved along with
your model. When MySQL Workbench is restarted, the relationship
notation reverts to the default, the
If you plan to export or print an EER diagram, be sure to decide on a notation style first. Changing notation styles after objects have been placed on a diagram can significantly change the appearance of the diagram.
This menu features actions against the connected MySQL server. Themenu has these items:
Manage Server Connections dialog, which enables you to create and manage multiple connections. For more information, see Section 5.3, “Manage Server Connections”: Launches the
For additional information about this wizard, see MySQL Schema Transfer Wizard.
int8to the target MySQL data type
Themenu lists tools and utilities that related to MySQL Workbench usage.
Section 6.6, “MySQL Audit Inspector Interface”. Commercial only.: Launches a file browser to open a specific audit log file. MySQL Workbench prompts for sudo access if the MySQL Workbench user is unable to read the audit log file. For additional information about the Audit Inspector, see
connections.xmlfile, for additional information about this file, see Section 3.3, “MySQL Workbench Settings and Log Files”.
mysqluc MySQL Utility. For additional information about MySQL Utilities, see Appendix F, MySQL Utilities.: Opens the
This menu features GRT scripting and plugin options. Themenu has these items:
New Script File dialogue, with options to create a , , or .: Opens a
Open GRT Script dialogue, which defaults to the Workbench scripts directory. Files are opened into the Workbench Scripting Shell window.: Opens a
Use themenu when you require support, or when you want to help improve MySQL Workbench. This menu has the following items:
Aboutwindow. This also displays the MySQL Workbench version.
Use the, menu item to display information about your system. This item is especially useful for determining your rendering mode. Sample output follows.
MySQL Workbench Community (GPL) for Windows version 6.1.4 revision 11773 build 1454 Configuration Directory: C:\Users\philip\AppData\Roaming\MySQL\Workbench Data Directory: C:\Users\philip\Desktop\MySQL\MySQL Workbench 6.1.4 CE Cairo Version: 1.8.8 OS: Microsoft Windows 7 Service Pack 1 (build 7601), 64-bit CPU: 4x Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz, 8.0 GiB RAM Active video adapter NVIDIA GeForce GT 610 Installed video RAM: 1024 MB Current video mode: 1920 x 1080 x 4294967296 colors Used bit depth: 32 Driver version: 18.104.22.1689 Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um Current user language: English (United States)