How it Works
Mysql
Loading...
MAESTRO
BROCHURE
353 pgs7.39 Mb0
Table of contents
Loading...

Mysql MAESTRO BROCHURE

Download
MySQL Maestro
User's guide
Copyright © 2002-2009 SQL Maestro Group
MySQL Maestro HelpI
Table of Contents
Foreword 0
I
................................................................................................................................... 31 Installation
................................................................................................................................... 42 Registration
................................................................................................................................... 53 License Agreement
................................................................................................................................... 74 System Requirements
................................................................................................................................... 85 About SQL Maestro Group
................................................................................................................................... 166 What's new
................................................................................................................................... 337 Getting Started
.......................................................................................................................................................... 34Explaining user interface
.......................................................................................................................................................... 35Tabbed MDI
.......................................................................................................................................................... 36First time started
.......................................................................................................................................................... 37Working with databases
.......................................................................................................................................................... 39Switching between windows
Basic principles of working with objects
II
................................................................................................................................... 411 Database Explorer
.......................................................................................................................................................... 44Filtering explorer content
................................................................................................................................... 452 Wizards and Editors
.......................................................................................................................................................... 45Create Object Wizards
......................................................................................................................................................... 46Setting object name
......................................................................................................................................................... 46Viewing commom information
.......................................................................................................................................................... 47Object Editors
......................................................................................................................................................... 48Permissions of the Object
......................................................................................................................................................... 49Object grants
......................................................................................................................................................... 51SQL Definition
......................................................................................................................................................... 52Parameter Editor
......................................................................................................................................................... 53Executing functions and procedures
................................................................................................................................... 553 Object Manager
.......................................................................................................................................................... 56Using popup menu
.......................................................................................................................................................... 56Multiple selecting of objects
................................................................................................................................... 584 Object Browser
.......................................................................................................................................................... 59Sorting database objects
.......................................................................................................................................................... 60Grouping database objects
.......................................................................................................................................................... 60Filtering database objects
................................................................................................................................... 625 Objects Duplicating
.......................................................................................................................................................... 62Duplicate Object Wizard
......................................................................................................................................................... 62Selecting source and destination databases
......................................................................................................................................................... 63Selecting object to duplicate
......................................................................................................................................................... 64Modifying new object definition
.......................................................................................................................................................... 65Duplicate Selected Object
.......................................................................................................................................................... 66Copy, Paste and Drag-n-Drop features
................................................................................................................................... 686 Changing Object Properties
1
40
© 2009 SQL Maestro Group
................................................................................................................................... 697 Describing Object
IIContents
Database Administration
III
................................................................................................................................... 721 Create Database Wizard
.......................................................................................................................................................... 72Setting connection properties
.......................................................................................................................................................... 75Specifying database properties
................................................................................................................................... 772 Database Editor
................................................................................................................................... 793 Creating Database Profiles
.......................................................................................................................................................... 79Setting connection properties
.......................................................................................................................................................... 82Selecting databases
.......................................................................................................................................................... 83Setting profile options
................................................................................................................................... 864 Editing Database Profile
.......................................................................................................................................................... 86Editing connection properties
.......................................................................................................................................................... 89Setting profile options
.......................................................................................................................................................... 90Setting default directories
.......................................................................................................................................................... 91Editing obligatory scripts to execute
.......................................................................................................................................................... 94Setting log options
Database Object Management
IV
................................................................................................................................... 981 Database Object Creation
................................................................................................................................... 992 Tables
.......................................................................................................................................................... 100Create Table Wizard
......................................................................................................................................................... 101Specifying table options
......................................................................................................................................................... 105Adding table subitems
.......................................................................................................................................................... 106Table Editor
......................................................................................................................................................... 107Editing table properties
......................................................................................................................................................... 111Managing table data
.......................................................................................................................................................... 113Fields
......................................................................................................................................................... 115Setting field parameters
.......................................................................................................................................................... 117Indexes
......................................................................................................................................................... 118Index Editor
.......................................................................................................................................................... 119Foreign Keys
......................................................................................................................................................... 120Setting reference options
.......................................................................................................................................................... 121Triggers
......................................................................................................................................................... 123Create Trigger Wizard
......................................................................................................................................... 123Specifying trigger properties
......................................................................................................................................... 124Specifying trigger definition
......................................................................................................................................................... 125Trigger Editor
......................................................................................................................................... 126Editing trigger properties
.......................................................................................................................................................... 127Foreign Key References
.......................................................................................................................................................... 129Partitions
................................................................................................................................... 1303 Views
.......................................................................................................................................................... 131Create View Wizard
......................................................................................................................................................... 132Selecting fields
......................................................................................................................................................... 133Specifing view options
.......................................................................................................................................................... 135View Editor
......................................................................................................................................................... 136Editing view properties
......................................................................................................................................................... 138Viewing data
................................................................................................................................... 1394 Procedures
.......................................................................................................................................................... 140Create Procedure Wizard
70
96
© 2009 SQL Maestro Group
II
MySQL Maestro HelpIII
......................................................................................................................................................... 141Specifying procedure options
......................................................................................................................................................... 143Managing parameters
......................................................................................................................................................... 143Specifying procedure definition
.......................................................................................................................................................... 144Procedure Editor
......................................................................................................................................................... 145Editing properties
......................................................................................................................................................... 146Viewing procedure results
................................................................................................................................... 1485 Functions
.......................................................................................................................................................... 149Create Function Wizard
......................................................................................................................................................... 150Specifying Function properties
......................................................................................................................................................... 152Managing parameters
......................................................................................................................................................... 152Specifying Function Definition
.......................................................................................................................................................... 153Function Editor
......................................................................................................................................................... 154Editing properties
......................................................................................................................................................... 156Viewing Function results
................................................................................................................................... 1586 Events
.......................................................................................................................................................... 159Create Event Wizard
......................................................................................................................................................... 160Setting event properties
......................................................................................................................................................... 161Schedule properties
......................................................................................................................................................... 162Specifying event definition
.......................................................................................................................................................... 163Event Editor
................................................................................................................................... 1667 Remote servers
.......................................................................................................................................................... 167Create Remote Server Wizard
.......................................................................................................................................................... 167Remote Server Editor
Queries
V
................................................................................................................................... 1711 Query Management
................................................................................................................................... 1722 SQL Editor
................................................................................................................................... 1783 Visual Query Builder
................................................................................................................................... 1884 Query Parameters
Server Administration
VI
................................................................................................................................... 1911 Server Editor
................................................................................................................................... 1922 Databases
................................................................................................................................... 1943 Server Variables
................................................................................................................................... 1954 Users
169
.......................................................................................................................................................... 173Working with editor area
.......................................................................................................................................................... 174Using popup menu
.......................................................................................................................................................... 175SQL Formatter
.......................................................................................................................................................... 176Executing query
.......................................................................................................................................................... 178Working with diagram area
.......................................................................................................................................................... 179Joining two objects
.......................................................................................................................................................... 181Setting criteria
.......................................................................................................................................................... 182Setting output fields
.......................................................................................................................................................... 183Setting grouping criteria
.......................................................................................................................................................... 184Setting parameters of sorting
.......................................................................................................................................................... 185Working with editor area
.......................................................................................................................................................... 186Executing query
.......................................................................................................................................................... 188Input Parameters dialog
189
.......................................................................................................................................................... 194Variable Editor
© 2009 SQL Maestro Group
................................................................................................................................... 2035 UDFs
................................................................................................................................... 2086 Character sets
IVContents
.......................................................................................................................................................... 195Create User Wizard
......................................................................................................................................................... 196Specifying user options
......................................................................................................................................................... 198Specifying user permissions
.......................................................................................................................................................... 199User Editor
......................................................................................................................................................... 200Editing user properties
......................................................................................................................................................... 201Managing user objects
.......................................................................................................................................................... 204Create UDF Wizard
......................................................................................................................................................... 204Specifying UDF options
.......................................................................................................................................................... 205UDF Editor
......................................................................................................................................................... 206Editing UDF properties
Working with data in MySQL Maestro
VII
................................................................................................................................... 2101 Data View
.......................................................................................................................................................... 211Working with data grid
.......................................................................................................................................................... 213Grouping data
.......................................................................................................................................................... 213Filtering records
.......................................................................................................................................................... 215Editing grid data
................................................................................................................................... 2172 Filter Builder Dialog
.......................................................................................................................................................... 217Invoking the Filter Builder dialog
.......................................................................................................................................................... 218Adding new condition
.......................................................................................................................................................... 219Setting filter criteria
.......................................................................................................................................................... 220Setting filter operator
.......................................................................................................................................................... 220Setting filter criteria values
.......................................................................................................................................................... 221Adding new group
.......................................................................................................................................................... 222Setting group operator
.......................................................................................................................................................... 223Applying filter conditions
................................................................................................................................... 2243 BLOB Editor
.......................................................................................................................................................... 224Navigating within the BLOB Editor
.......................................................................................................................................................... 225Editing as hexadecimal dump
.......................................................................................................................................................... 226Editing as plain text
.......................................................................................................................................................... 226Editing as HTML
................................................................................................................................... 2284 Export Data Wizard
.......................................................................................................................................................... 228Setting destination file name and format
.......................................................................................................................................................... 229Selecting fields for export
.......................................................................................................................................................... 230Adjusting data formats
.......................................................................................................................................................... 231Setting header and footer
.......................................................................................................................................................... 231Setting format-specific options
......................................................................................................................................................... 231Excel options
......................................................................................................................................................... 232Access options
......................................................................................................................................................... 233Word / RTF options
......................................................................................................................................................... 234HTML options
......................................................................................................................................................... 235PDF options
......................................................................................................................................................... 236TXT options
......................................................................................................................................................... 236CSV options
......................................................................................................................................................... 237XML options
.......................................................................................................................................................... 238Setting common export options
................................................................................................................................... 2395 Get SQL Dump
.......................................................................................................................................................... 240Selecting fields
.......................................................................................................................................................... 240Specifying dump options
209
© 2009 SQL Maestro Group
IV
MySQL Maestro HelpV
................................................................................................................................... 2426 Import Data Wizard
.......................................................................................................................................................... 243Setting source file name and format
.......................................................................................................................................................... 244Selecting data source
.......................................................................................................................................................... 245Setting fields correspondence
......................................................................................................................................................... 245Excel
......................................................................................................................................................... 246Access, DBF, XML
......................................................................................................................................................... 247TXT
......................................................................................................................................................... 248CSV
.......................................................................................................................................................... 249Adjusting data formats
.......................................................................................................................................................... 250Setting advanced field formats
.......................................................................................................................................................... 251Setting import mode
.......................................................................................................................................................... 252Customizing common options
Database Tools
VIII
254
................................................................................................................................... 2551 SQL Script Editor
................................................................................................................................... 2582 Extract Database
.......................................................................................................................................................... 259Selecting the database and the target file name
.......................................................................................................................................................... 259Selecting objects to extract their structure
.......................................................................................................................................................... 260Selecting objects to extract their data
.......................................................................................................................................................... 261Customizing script options
................................................................................................................................... 2633 Generate Database Report
.......................................................................................................................................................... 263Selecting reporting elements and setting other report options
.......................................................................................................................................................... 264Reporting objects and editing styles options
.......................................................................................................................................................... 265Editing database report style
................................................................................................................................... 2664 BLOB Viewer
.......................................................................................................................................................... 266Viewing as hexadecimal dump
.......................................................................................................................................................... 267Viewing as plain text
.......................................................................................................................................................... 268Viewing as image
.......................................................................................................................................................... 269Viewing as HTML
................................................................................................................................... 2715 Diagram Viewer
.......................................................................................................................................................... 271Customizing diagram properties
.......................................................................................................................................................... 273Exporting diagram image
................................................................................................................................... 2756 Data Analysis
.......................................................................................................................................................... 276Input SELECT query
.......................................................................................................................................................... 277Managing report data
................................................................................................................................... 2797 Database Designer
.......................................................................................................................................................... 281Designer Navigation bar
.......................................................................................................................................................... 282Database Designer Toolbox
................................................................................................................................... 2858 Process Browser
................................................................................................................................... 2869 SQL Generator
................................................................................................................................... 28710 Dialogs
.......................................................................................................................................................... 287Find Text dialog
.......................................................................................................................................................... 289Replace Text dialog
MySQL Maestro Options
IX
................................................................................................................................... 2921 Application
.......................................................................................................................................................... 292Preferences
.......................................................................................................................................................... 294Confirmations
.......................................................................................................................................................... 295Tools
291
© 2009 SQL Maestro Group
......................................................................................................................................................... 296Explorer
......................................................................................................................................................... 297Object Manager
......................................................................................................................................................... 297SQL Editor
......................................................................................................................................................... 298SQL Script Editor
......................................................................................................................................................... 299Query Builder
......................................................................................................................................................... 301BLOB Viewer
......................................................................................................................................................... 302Data Export
......................................................................................................................................................... 303Database Designer
.......................................................................................................................................................... 304Object Editors
......................................................................................................................................................... 306Table
.......................................................................................................................................................... 306Data Grid
......................................................................................................................................................... 308Options
......................................................................................................................................................... 309Colors
......................................................................................................................................................... 310Formats
......................................................................................................................................................... 311Filter
................................................................................................................................... 3132 Editors & Viewers
.......................................................................................................................................................... 313General
.......................................................................................................................................................... 315Display
.......................................................................................................................................................... 316SQL highlight
.......................................................................................................................................................... 316XML highlight
.......................................................................................................................................................... 317Code Insight
.......................................................................................................................................................... 318Code Folding
................................................................................................................................... 3203 Appearance
.......................................................................................................................................................... 321Bars and menus
.......................................................................................................................................................... 321Trees and lists
.......................................................................................................................................................... 322Edit controls
.......................................................................................................................................................... 323Check boxes
.......................................................................................................................................................... 324Buttons
.......................................................................................................................................................... 325Page controls
.......................................................................................................................................................... 326Group boxes
.......................................................................................................................................................... 327Splitters
................................................................................................................................... 3294 Export Settings
.......................................................................................................................................................... 329Specifying destination file
.......................................................................................................................................................... 330Selecting setting categories
.......................................................................................................................................................... 331Selecting database profiles
.......................................................................................................................................................... 331Saving settings
VIContents
......................................................................................................................................... 301Colors
Appendix
X
................................................................................................................................... 3341 Specifying WHERE condition
................................................................................................................................... 3392 MySQL identifiers
................................................................................................................................... 3403 Data Formats
© 2009 SQL Maestro Group
333
.......................................................................................................................................................... 334Adding new condition
.......................................................................................................................................................... 334Setting filter criteria
.......................................................................................................................................................... 335Setting filter operator
.......................................................................................................................................................... 336Setting filter criteria values
.......................................................................................................................................................... 336Setting group operator
.......................................................................................................................................................... 337Adding new group
VI
MySQL Maestro HelpVII
Index 341
© 2009 SQL Maestro Group

1 Welcome to MySQL Maestro!

MySQL Maestro is the premier Windows GUI admin tool for MySQL management, control and development. It allows you to make all the database operations easy and fast. Using MySQL Maestro you can create, edit, copy, and drop all the database objects such as tables, views, procedures, functions and queries, build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, manage MySQL users and use a lot of other tools designed for the easiest and most efficient work with MySQL server.
Basic MySQL Maestro features
Easy database management
MySQL Maestro allows you to create and drop databases quickly. Database profiles give you the opportunity to connect to databases in one touch and work with the selected databases only. See the Database Management for details.
Powerful database object management MySQL Maestro provides you with an ability to manage database objects (tables ,
views , procedures and functions ) in various ways. For example, you can
perform operations with a group of objects as well as with a single object in Object
Manager , sort, group and filter the database objects within Object Browser , copy
an object from one database to another by a drag-and-drop operation inside the explorer tree, use Windows clipboard to copy a set of objects and so on. For details turn to the Database Object Management section.
130 139 148
55 58
96
Welcome to MySQL Maestro! 1
70
99
Working with tables and table subobjects
MySQL Maestro wizards and editors allow you to create, edit and drop tables as well as their fields, indexes, triggers and foreign keys in a couple of simple operations. See the
Tables section to learn more.
99
Building and executing queries
MySQL Maestro provides two powerful tools which allow you either to edit query text directly with syntax highlighting and code completion or to build a query diagram visually selecting tables and fields, setting links between tables and so on. You can find the detailed description in the Queries section.
169
Support of the latest MySQL features
Use MySQL Maestro to work with any MySQL server version from 3.23 to 5.2 and higher! Among other features and objects implemented in the latest versions of the server, our software supports stored procedures, functions, triggers, character sets, collations, tables partitioning and so on.
Powerful data management tools With MySQL Maestro you can view and edit table data (including BLOB fields), export and import data to/from MS Excel, MS Access, DBF, XML, TXT, CSV and other formats, get SQL data dump and more. See the Data Management to learn the details.
209
Wide choice of additional tools
MySQL Maestro provides you with a number of tools for working with database metadata and SQL scripts, including code folding. There are such tools are at your disposal as BLOB Viewer, Diagram Viewer, Data Analysis and Database Designer, SQL Generator, and
© 2009 SQL Maestro Group
MySQL Maestro Help2
more. To learn more, see the Database Tools section.
254
Security management
MySQL Maestro provides you with an efficient way to manage access privileges. You can either grant/revoke permissions for a concrete database object such as table or function, or operate with user privileges.
195
Full customization according to your preferences and needs
In MySQL Maestro you can customize the behavior of all its tools, select a user interface scheme and set a lot of other preferences. All the options and their meanings are listed within the Options dialog description.
291
© 2009 SQL Maestro Group

1.1 Installation

If you install MySQL Maestro for the first time on your PC:
· download the MySQL Maestro distribution package from the download page at our
site;
· run setup.exe from the local folder and follow the instructions of the installation
wizard;
· find the MySQL Maestro shortcut in the corresponding program group of the
Windows Start menu after the installation is completed.
If you want to upgrade the installed copy of MySQL Maestro to the latest version:
· download the MySQL Maestro executable file from the download page at our site;
· unzip downloaded file to any local folder, e.g. c:\unzipped;
· exit from MySQL Maestro if it is running;
· replace previous version of MySQL Maestro by copying unzipped files to the MySQL
Maestro folder;
· run MySQL Maestro using its shortcut in the Windows Start menu.
You can also use the full distribution package to upgrade your current version of MySQL Maestro. In this case you should repeat the steps of the first-time installation. Note that the full distribution package is larger than a single executable file.
Welcome to MySQL Maestro! 3
© 2009 SQL Maestro Group
MySQL Maestro Help4

1.2 Registration

Thank you for your interest in purchasing MySQL Maestro!
You can select licensing options and register MySQL Maestro at its on-line order page. It is possible to purchase on-line, by fax, mail, toll-free phone call, or place a purchase order. We send the software activation key by email within 24 hours after completion of the order process. If you have not received the activation key within this period, please contact our sales department.
Being a registered user of any of our products, you are granted to get all the upgrades of the product (minor and major) for free within 12 (twelve) months since the purchase date. After this period you may renew your license for the next 12 months with a 30% discount.
Upon purchasing MySQL Maestro you confirm that you have tested the product and you are completely satisfied with its current version.
To obtain technical support, please visit the appropriate section on our website or contact us by email to support@sqlmaestro.com.
© 2009 SQL Maestro Group

1.3 License Agreement

Notice to users: carefully read the following legal agreement. The use of the software provided with this agreement (the "SOFTWARE") constitutes your acceptance of these terms. If you do not agree to the terms of this agreement, do not install and/or use this software. The use of this software is conditioned upon the user's compliance with the terms of this agreement.
· License grant. SQL Maestro Group grants you a license to use one copy of the
version of this SOFTWARE on any single hardware product for as many licenses as you purchase. "You" means a company, an entity or an individual. "Use" means storing, loading, installing, executing or displaying the SOFTWARE. You may not modify the SOFTWARE or disable any licensing or control features of the SOFTWARE except as an intended part of the SOFTWARE's programming features. This license is not transferable to any other company, entity or individual. You may not publish any registration information (serial numbers, registration keys, etc.) or pass it to any other company, entity or individual.
· Ownership. The SOFTWARE is owned and copyrighted by SQL Maestro Group. Your
license confers no title or ownership of the SOFTWARE and should not be construed as a sale of any rights for the SOFTWARE.
Welcome to MySQL Maestro! 5
· Copyright. The SOFTWARE is protected by the United States copyright law and
international treaty provisions. You acknowledge that no title to the intellectual property in the SOFTWARE is transferred to you. You further acknowledge that title and full ownership rights to the SOFTWARE will remain the exclusive property of SQL
Maestro Group and you will not acquire any rights to the SOFTWARE except as
expressly set forth in this license. You agree that any copies of the SOFTWARE will contain the same proprietary notices which appear on and in the SOFTWARE.
· License and distribution. An unregistered copy of the SOFTWARE ("UNREGISTERED
SOFTWARE") may be used for evaluation purposes. The UNREGISTERED SOFTWARE may be freely copied and distributed to other users for their evaluation. If you offer this UNREGISTERED SOFTWARE installation package for download, then you agree to:
· replace existing version of the UNREGISTERED SOFTWARE installation package with the
new package immediately after a new version of the SOFTWARE is released by SQL Maestro Group, or
· delete an obsolete version of the UNREGISTERED SOFTWARE installation package
immediately upon written email notice by SQL Maestro Group.
A registered copy of the SOFTWARE ("REGISTERED SOFTWARE") allows you to use the SOFTWARE only on a single computer and only by a single user at a time. If you wish to use the SOFTWARE for more than one user, you will need a separate license for each individual user. You are allowed to make one copy of the REGISTERED SOFTWARE for back-up purposes.
· Reverse engineering. You affirm that you will not attempt to reverse compile,
modify, translate, or disassemble the SOFTWARE in whole or in part.
· Unauthorized use. You may not use, copy, rent, lease, sell, modify, decompile,
disassemble, otherwise reverse engineer, or transfer the SOFTWARE except as provided in this agreement. Any such unauthorized use shall result in immediate and
© 2009 SQL Maestro Group
MySQL Maestro Help6
automatic termination of this license.
· No other warranties. SQL Maestro Group does not warrant that the SOFTWARE is
error-free. SQL Maestro Group disclaims all other warranties with respect to the SOFTWARE, either express or implied, including but not limited to implied warranties of merchantability, fitness for a particular purpose and noninfringement of third party rights. Some jurisdictions do not allow the exclusion of implied warranties or limitations on how long an implied warranty may last, or the exclusion or limitation of incidental or consequential damages, so the above given limitations or exclusions may not apply to you. This warranty gives you specific legal rights and you may also have other rights which vary from jurisdiction to jurisdiction.
· Limited warranty. This SOFTWARE is provided on an "AS IS" basis. SQL Maestro
Group disclaims all warranties relating to this SOFTWARE, whether expressed or
implied, including but not limited to any implied warranties of merchantability or fitness for a particular purpose. Neither SQL Maestro Group nor anyone else who has been involved in the creation, production, or delivery of this SOFTWARE shall be liable for any indirect, consequential, or incidental damages arising out of the use or inability to use such SOFTWARE, even if SQL Maestro Group has been advised of the possibility of such damages or claims. The person using the SOFTWARE bears all risk as to the quality and performance of the SOFTWARE.
Some jurisdictions do not allow limitation or exclusion of incidental or consequential damages, so the above given limitations or exclusion may not apply to you to the extent that liability is by law incapable of exclusion or restriction.
· Severability. In the event of invalidity of any provision of this license, the parties
agree that such invalidity shall not affect the validity of the remaining portions of this license.
· No liability for consequential damages. In no event shall SQL Maestro Group or its
suppliers be liable to you for any consequential, special, incidental or indirect damages of any kind arising out of the delivery, performance or use of the SOFTWARE, even if SQL Maestro Group has been advised of the possibility of such damages. In no event will SQL Maestro Group's liability for any claim, whether in contract, tort or any other theory of liability, exceed the license fee paid by you, if any.
· Entire agreement. This is the entire agreement between you and SQL Maestro Group
which supersedes any prior agreement or understanding, whether written or oral, relating to the subject matter of this license.
· Reserved rights. All rights not expressly granted here are reserved to SQL Maestro
Group.
© 2009 SQL Maestro Group

1.4 System Requirements

Client environment
· Pentium PC or higher;
· Windows 9x/ME/NT4/2000/XP/2003;
· 64 MB RAM (128 MB recommended);
· 10 MB of free hard disk space;
· SVGA-compatible video adapter;
· Internet Explorer 4.0 or higher.
Server environment
· MySQL server version from 3.23 to 6.0.
Welcome to MySQL Maestro! 7
© 2009 SQL Maestro Group
MySQL Maestro Help8
MS SQL Maestro is the premier Windows GUI admin tool for Microsoft
SQL Server management, control and development.
MS SQL Maestro gives you wide opportunities to perform all the
necessary database operations such as creating, editing, copying, extracting and dropping database objects; moreover, you can build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/ from most popular file formats, manage Microsoft SQL Server users and their privileges, add jobs and alerts, and use a lot of other tools implemented to make your work with Microsoft SQL Server highly enjoyable and efficient.
Easy installation and intuitive interface in combination with support of all
Microsoft SQL Server latest features make it an irreplaceable tool for Microsoft SQL Server on the web or at your local desktop.
MS SQL Data Wizard is a powerful Windows GUI utility for managing your
Microsoft SQL data.
MS SQL Data Wizard provides you with a number of easy-to-use wizards
for performing the required data manipulation easily and quickly. MS SQL Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your MS SQL

1.5 About SQL Maestro Group

SQL Maestro Group is a privately-held company producing high-quality software for database administrators and developers. The united team of eminently qualified developers is pleased to create new software products for commercial, academic and government customers worldwide. We do our best to design and develop products that remove complexity, improve productivity, compress time frames, and increase database performance and availability. We are glad to realize that our products take usual chores upon themselves, so that our customers could have more time left for their creative work.
The company was founded in 2002 as an essential partner for every business that is trying to harness the explosive growth in corporate data. SQL Maestro Group employs an international team concentrating their efforts on cutting-edge DBA tools development.
The slogan of our company is The Shortest Path to SQL. It is aimed to denote that we set to create easy-to-use products meant for those who appreciate comfort, friendly program interface and support when working with SQL servers.
· We are pleased to facilitate your job.
· We aim at being of considerable assistance to our clients.
· We feel contented doing our beloved work.
At present, our company offers a series of Windows GUI admin tools for SQL management, control and development of the following servers: MySQL , Microsoft
SQL Server , PostgreSQL , Oracle , SQL Anywhere , DB2 , SQLite , Firebird
12 14
, and MaxDB .
8 12 9 10 11 13
10
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 9
database, export data from MS SQL tables and queries to most popular formats, and import data into the tables.
MS SQL Code Factory is a premier SQL Server GUI tool aimed at the SQL
queries and scripts development.
MS SQL Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on MS SQL data, and much more.
Oracle Maestro is the premier Windows GUI admin tool for Oracle
databases management, control and development.
Oracle Maestro provides you with a number of tools allowing to perform
all the necessary database operations such as creating, editing, and duplicating database objects; moreover, you can build queries visually, execute and optimize SQL queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/ from most popular file formats, analyze your data summarized into multidimensional views and hierarchies (OLAP cubes), and use a lot of other tools implemented to make your work with Oracle server comfortable and efficient.
Oracle Data Wizard is a powerful Windows GUI utility for managing your
Oracle data.
Oracle Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. Oracle Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to the Oracle database, export data from Oracle tables and queries to most popular formats, and import data into the tables.
Oracle Code Factory is a premier Oracle GUI tool aimed at the SQL
queries and scripts development.
Oracle Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on Oracle data, and much more.
© 2009 SQL Maestro Group
MySQL Maestro Help10
SQL Maestro for MySQL is the premier Windows GUI admin tool for
MySQL Server management, control and development.
SQL Maestro for MySQL provides you with the ability to perform all the
necessary database operations such as creating, editing, copying, extracting and dropping database objects; moreover, you can build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/ from most popular file formats, manage MySQL users and their privileges, and use a lot of other tools designed for making your work with MySQL server comfortable and efficient.
Data Wizard for MySQL is a powerful Windows GUI utility for managing
your MySQL data.
Data Wizard for MySQL provides you with a number of easy-to-use
wizards for performing the required data manipulation easily and quickly. The wizards allow you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your MySQL database, export data from MySQL tables and queries to most popular formats, and import data into the tables.
Code Factory for MySQL is a premier MySQL GUI tool aimed at the SQL
queries and scripts development.
Code Factory for MySQL allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on MySQL data, and much more.
Service Center for MySQL is a multi-functional Windows GUI utility for
MySQL server maintenance and data reservation.
Service Center for MySQL allows you to create tasks for backing your
data into a script, restoring data from a script, analyzing, checking, repairing and optimizing database tables. In addition to these functions, Service Center for MySQL provides you with a powerful task scheduler, an ability of using scenarios and other useful features.
ASA Maestro is the premier Windows GUI admin tool for Sybase SQL
Anywhere databases management, control and development.
ASA Maestro provides you with a number of tools allowing to perform all
the necessary database operations such as creating, editing, and duplicating database objects; moreover, you can build queries visually, execute and optimize SQL queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/ from most popular file formats, analyze your data summarized into multidimensional views and hierarchies (OLAP cubes), and use a lot of
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 11
other tools implemented to make your work with SQL Anywhere server comfortable and efficient
ASA Data Wizard is a powerful Windows GUI utility for managing your
Sybase SQL Anywhere data.
ASA Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. ASA Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to the SQL Anywhere database, export data from SQL Anywhere tables and queries to most popular formats, and import data into the tables.
ASA Code Factory is a premier Sybase SQL Anywhere GUI tool aimed at
the SQL queries and scripts development.
ASA Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on SQL Anywhere data, and much more.
DB2 Maestro is the premier Windows GUI admin tool for DB2 databases
management, control and development.
DB2 Maestro provides you with a number of tools allowing to perform all
the necessary database operations such as creating, editing, and duplicating database objects; moreover, you can build queries visually, execute and optimize SQL queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/ from most popular file formats, analyze your data summarized into multidimensional views and hierarchies (OLAP cubes), and use a lot of other tools implemented to make your work with DB2 server comfortable and efficient.
DB2 Data Wizard is a powerful Windows GUI utility for managing your
DB2 data.
DB2 Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. DB2 Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to the DB2 database, export data from DB2 tables and queries to most popular formats, and import data into the tables.
DB2 Code Factory is a premier DB2 GUI tool aimed at the SQL queries
and scripts development.
DB2 Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax
© 2009 SQL Maestro Group
MySQL Maestro Help12
highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on DB2 data, and much more.
PostgreSQL Maestro is the premier Windows GUI admin tool for
PostgreSQL server management, control and development.
PostgreSQL Maestro allows you to create, edit, copy, extract and drop all
the database objects such as schemas, tables, views, functions, domains, rules, sequences, languages, operators, etc., build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, manage PostgreSQL roles, users, groups and their privileges, and use a lot of other tools designed for the easiest and most efficient work with PostgreSQL Server.
You are welcome to enjoy the abilities offered by a number of
implemented tools providing excellent performance for all the necessary database operations.
PostgreSQL Data Wizard is a powerful Windows GUI utility for managing
your PostgreSQL PostgreSQL data.
PostgreSQL Data Wizard provides you with a number of easy-to-use
wizards for performing the required data manipulation easily and quickly. PostgreSQL Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your PostgreSQL database, export data from PostgreSQL tables and queries to most popular formats, and import data into the tables.
PostgreSQL Code Factory is a premier PostgreSQL GUI tool aimed at the
SQL queries and scripts development.
PostgreSQL Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on PostgreSQL data, and much more.
Firebird Maestro is the premier Windows GUI admin tool for Firebird
Server management, control and development.
Firebird Maestro allows you to create, edit, copy, extract and drop all the
database objects such as tables, views, procedures, domains, generators, etc., build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 13
and import data to/from most popular file formats, manage Firebird users, and their privileges, and use a lot of other tools designed for the easiest and most efficient work with Firebird Server.
Firebird Data Wizard is a powerful Windows GUI utility for managing your
Firebird data.
Firebird Data Wizard provides you with a number of easy-to-use wizards
for performing the required data manipulation easily and quickly. Firebird Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your Firebird database, export data from Firebird tables and queries to most popular formats, and import data into the tables.
Firebird Code Factory is a premier Firebird GUI tool aimed at the SQL
queries and scripts development.
Firebird Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on Firebird data, and much more.
SQLite Maestro allows you to create, edit, copy, extract and drop all
the database objects such as tables, views, build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, and use a lot of other tools designed for the easiest and most efficient work with SQLite server.
SQLite Maestro is designed to meet the requirements of SQLite users and
to make the work with the server simpler and more comfortable. Friendly user graphical interface, handy realization of the client application and stable running are evident advantages of using SQLite Maestro.
SQLite Data Wizard is a powerful Windows GUI utility for managing your
SQLite data.
It provides you with a number of easy-to-use wizards for performing the
required data manipulation easily and quickly. SQLite Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your SQLite database, export data from SQLite tables and queries to most popular formats, and import data into the tables.
© 2009 SQL Maestro Group
MySQL Maestro Help14
SQLite Code Factory is a premier SQLite GUI tool aimed at the SQL
queries and scripts development.
SQLite Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on SQLite data, and much more.
MaxDB Maestro is the premier Windows GUI admin tool for MaxDB Server
management, control and development.
You are welcome to appreciate the brilliant performance of MaxDB Maestro. It is implemented with a number of tools allowing you to perform all the necessary database operations such as creating, editing, copying, extracting and dropping database objects; moreover, you can build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/ from most popular file formats, and use a lot of other tools implemented to make your work with MaxDB server comfortable and efficient.
MaxDB Data Wizard is a powerful Windows GUI utility for managing your
MaxDB data.
MaxDB Data Wizard provides you with a number of easy-to-use wizards
for performing the required data manipulation easily and quickly. MaxDB Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to the MaxDB database, export data from MaxDB tables and queries to most popular formats, and import data into the tables.
MaxDB Code Factory is a premier MaxDB GUI tool aimed at the SQL
queries and scripts development.
MaxDB Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on MaxDB data, and much more.
Our web-site
www.sqlmaestro.com
The software products are constantly optimized for the latest server versions support.
You can use the following contact information if necessary:
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 15
Postal address:
SQL Maestro Group
140 Broadway, Suite 706 New York City, New York 10005 United States
Thank you for your interest to our company!
© 2009 SQL Maestro Group
MySQL Maestro Help16

1.6 What's new

02/02/2009 - SQL Maestro for MySQL 9.2 released
Server management extensions:
· Starting with this version it is possible to manage (create, edit and drop) remote
servers i.e. servers that can be later used when creating tables with the FEDERATED storage engine (MySQL 5.1.15 and higher). To create a federated table using such a server, set the Connection property to 'server_name/table_name' within the Create Table wizard .
101
· SQL Editor : support for explicit transaction management has been implemented.
172
Now you can execute queries either in autocommit mode (default behavior) or manage transactions manually. In the second case you have to issue the BEGIN statement to start a transaction and explicitly end the transaction by COMMIT or ROLLBACK statements (it is also possible to use the corresponding links at the editor's navigation bar).
· Field Editor : now it is possible to select some predefined default values such as
113
CURRENT_USER for the string columns or CURRENT_TIMESTAMP for TIMESTAMP columns from the list instead of entering them manually.
Interface improvements:
· Visual Query Builder has been dramatically improved. Now it can produce INSERT,
178
UPDATE and DELETE statements as well as the SELECT statements containing subqueries and/or UNIONs.
· Tabbed MDI interface : a popup menu has been added to each tab.
35
· An Italian localization is now included into the installation package.
· Data grid features the following things:
210
o
Starting with this version it is possible to allow displaying row numbers in grids. Of course you can adjust the corresponding column to yours liking.
o
The contents of string columns can now be encrypted using the md5 algorithm.
10/20/2008 - SQL Maestro for MySQL 8.10 released
Server management extensions:
· An ability of using the LOAD DATA INFILE command has been incorporated into the
Import Data wizard . This feature can speed up the import process up to 10 times
242
so it is recommended to use it always if possible. Also we have added the Empty
table before importing option (can be found at the last step of the wizard).
· Get SQL Dump Wizard and Extract Database Wizard now can generate multi-
239 258
row INSERT statements. Also both the wizards have been redesigned to increase
© 2009 SQL Maestro Group
the usability.
Interface improvements:
Welcome to MySQL Maestro! 17
· Data Grid features the following things:
211
o
Starting with this version it is possible to use the lookup editor for a
215
column, which is linked by a foreign key with a (single) column from another table. The editor displays the contents of parent table’s columns within the dropdown window.
o
A possibility of displaying data in the master-detail form has been incorporated into the Table Editor (multiple detail pages can be displayed for a single
106
master row). Use the Show/Hide details link at the editor’s navigation bar to activate/deactivate this view mode.
o
Filtering, grouping, and sorting features become available for TEXT columns. Also it is possible to edit the contents of such columns in a separate window as well as encrypt it using the md5 algorithm.
· Database Designer settings: the Show hints option has been added. Also it is
279
now possible to select the default graphic file format to export diagrams as images.
· Data Export, Data Import, and Get SQL Dump wizards now store their size and
position.
· Database Explorer : the Data management group has been added to table and
41
view nodes popup menus. Use this group items to run Data Export, Data Import, and Get SQL Dump wizards for the selected table or view without opening its editor (the Empty Table command has been moved to this group too). The Go to foreign
table command is now available for all the foreign keys.
03/20/2008 - SQL Maestro for MySQL 8.3 released
Server management extensions:
· The main feature of the new version is a possibility of connecting to remote MySQL
servers with restricted access via HTTP tunneling. The technology works as follows:
o
o
o
· Starting with this version you can set up default character set and collation in
Create Database Wizard .
© 2009 SQL Maestro Group
Upload the connection PHP script to your website. The script is named
mysql_tunnel.php and can be found under the installation folder, usually C: \Program Files\SQL Maestro Group\SQL Maestro for MySQL.
Test the script in your web-browser (optionally).
Enter the script URL in the Create Profiles Wizard , Create Database Wizard
72 86
, or Edit Database Profile dialog. Of course you should select the "I have
79
to use HTTP tunneling" option in any of these windows.
72
MySQL Maestro Help18
· Now you can specify the client encoding in the connection properties. Default value
is UTF-8 (do not change it without necessity).
· SQL Formatter now understands expressions like INTERVAL 600 MINUTES.
· Quick Connect mode has been implemented. Use it to skip metadata refreshing
when connecting to a database (for example, to execute a query or SQL script).
Interface improvements:
· This version of our software is fully compatible with large fonts (120 DPI).
· Extract database wizard: common database properties and program info are now
included into the result scripts.
· SQL Editor: a popup menu has been added to each query tab. Using this menu you
can create a new query, close existing one, save the query to profile, etc even if editor's navigation bar is closed.
· Create Database Wizard, Create Profiles Wizard, and object creation wizards
become resizable.
· Data import wizard: the interface for adding and editing of replacements has been
slightly improved.
· The F11 key is now used to show/hide the Explorer tree.
· Data grid options: it is now possible to restrict maximum column width.
· SQL Script Editor settings: the "Use script runner for large scripts" option has been
added.
Important fixes:
· Data in UTF-8 encoding are now displayed correctly for MySQL 4.1.
· Extract Database Wizard now works fine even if a user has no permissions to obtain
view definitions.
12/14/2007 - SQL Maestro for MySQL 7.12 released
Server management extensions:
· A new editor for values of the set data type has been implemented.
· Values of the enum ('Y','N') data type are now displayed and edited as checkboxes.
· Foreign keys are now extracted corrected for all MySQL versions.
Interface improvements:
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 19
· The SQL Generator tool has been implemented. Use this feature to produce
286
various SQL scripts (CREATE, DROP, SELECT, INSERT, etc) for the selected object. The result script can be saved to a file, copied to clipboard, and opened in SQL
Editor or SQL Script Editor .
· Data Grid has been significantly updated:
172 255
211
o
The notification pane is now displayed after simple mode activation (filtering, grouping and sorting features are not supported in this mode). All the related settings can be customized in the Options dialog;
o
The Generate Query command has been added to the Table / View Editor
135
. Use this command to copy current filter conditions to the SQL Editor
106
window as an SQL query. It is also possible to copy filter condition to clipboard as WHERE clause using grid’s popup menu;
o
Now it is possible to encrypt the contents of the selected cell by the md5 algorithm (the corresponding item has been added to grid's popup menu).
· Database designer : the Note and Text tools have been added. You can use
279
them to decorate the diagrams.
· Create Database Profiles wizard : the Hide already registered databases option
79
has been added.
· Object editors, SQL Editor, Database Designer, BLOB Viewer and other database-
dependent windows: only connected databases are now displayed in the drop­down list.
08/23/2007 - SQL Maestro for MySQL 7.8 released
Server management extensions:
· SQL Maestro for MySQL was optimized to work with MySQL servers with a small
timeout;
· Since this version you can reorder fields for existing tables. It is also possible to
107
reorder parameters for a stored procedure/function and reorder partitions (only for newly created tables);
· It is now possible to cancel a long running query execution (MySQL 5) and data
fetching (all MySQL versions);
· Field Editor: the NCHAR and NVARCHAR types are added to the type list;
· Process Browser : session killing is now works correctly for all MySQL versions.
285
Interface improvements:
· The SQL Formatter for DML statements (SELECT, INSERT, UPDATE and DELETE)
is implemented. It can be invoked through the Format SQL link on the SQL Editor's navigation bar (Ctrl+Alt+D shortcut). Also it is now used for view body formatting
© 2009 SQL Maestro Group
175
MySQL Maestro Help20
(MySQL stores view body as a single line)
· Data grid : the editor for ENUM fields displays a lookup list with enumeration
211
values.
· Extract Metadata Wizard is improved. Now it works faster and requires less
258
memory
· Now SQL Maestro for MySQL displays execution time for lengthy operations.
· Get SQL Dump Wizard : the result table is now scripted correctly.
239
· The Row count and Data length columns are added to the table list (Database
Editor , Object Browser ).
77 58
· The database hints in the explorer tree now contain connection ID and default
character set/collation. Hints for tables and columns are also included character set and collation, but only if they are different from database default.
· Data Import Wizard: the speed of loading of Excel files was significantly increased.
· Foreign key editor : now only InnoDB tables are displayed in the foreign table list.
119
Table engine is also now checked for the Relation tool in the Database Designer.
08/21/2007 - Renaming of administration tools family for MySQL
SQL Maestro Group have renamed all MySQL Administration tools family members because of MySQL AB trademark policy.
Since then the new title of MySQL Maestro is SQL Maestro for MySQL.
06/25/2007 - MySQL Maestro 7.6 released
Server management extensions:
· The most important thing added in this version of MySQL Maestro is support of UTF-8 data.
· Process Browser is implemented. This feature is very useful for DBAs who want
285
to monitor the users' activity (in fact, there are potentially thousands of sessions in a database at any one time). You can view details for each session (such as user, connect time, database name, client host, last SQL statement executed and more) as well as group and filter sessions by client host, connected user, database, client application, etc. To access the Process Browser window, select the corresponding item from the Tools menu.
· Now MySQL Maestro displays view body correctly even if you're not the owner of the view.
Interface improvements:
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 21
· Database Designer : a possibility of locking/unlocking diagram objects is added.
279
This feature prevents your diagram from unforeseen changes: when the diagram is locked, you can neither move/resize/delete existing objects nor add new ones.
· Some new features are incorporated into SQL Editor and SQL Script Editor .
172 255
Now it is possible:
o
comment/uncomment selected text (Shift+Ctrl+. / Shift+Ctrl+, shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift+Ctrl+, having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported;
o
convert selected text to different cases (lower, UPPER, and NameCase);
o
export the contents of the editor to RTF and HTML formats (to file or to clipboard);
o
print/preview the contents of the editor.
· The Copy to SQL Script Editor command is added to all object editors (available in the Navigation Bar on the SQL tab). Use it for quick copying object’s SQL definition (DDL) to the SQL Script Editor for future modifications;
· Data grid : some advanced filtering abilities were implemented (see Main menu |
211
Tools | Options | Data grid | Filter);
· Explorer tree: the Browse command is added to lists' popup menus (runs the
Object Browser tool).
41
58
02/15/2007 - MySQL Maestro 7.2 released
Server management extensions:
· MySQL Maestro has been successfully tested with the latest MySQL versions up to
5.0.27, 5.1.15 beta and 5.2 alpha;
· Support of the Falcon storage engine from MySQL 5.2 is implemented;
Interface improvements:
· The main feature of the new version is Graphical Database Designer - a case tool
279
for managing your database in a few mouse clicks. This piece of our software is intended for creation of physical Entity Relationship Diagrams that represent objects in your MySQL databases. Each diagram displays the tables of your database and the relationships between them.
o
Handy tools of Designer allow you to create new and edit existing tables and references;
o
© 2009 SQL Maestro Group
The reverse engineering feature will help you to understand the schema
MySQL Maestro Help22
structure and make its modification in an easy and clear way.
o
Now you can quickly and easily print your database structure with a lot of options including header and footer, paper size and orientation, etc;
o
A rich set of options and settings give you a way to see your database in your own look and feel style.
A diagram of your database can help you define operational aspects of your application logic that you might otherwise overlook. Also, a well-defined data diagram that accurately represents your tasks can be helpful in orienting employees to goals and operations.
· SQL Editor : now MySQL Maestro can edit even very large SQL files. Also the
172
speed of editor's work has been significantly improved;
· SQL Editor: queries' tabs can now been displayed at the all sides of the editor
(bottom, top, left or right);
· The hint for foreign keys now contains such information as foreign table name and
field correspondence.
12/08/2006 - MySQL Maestro 6.12 released
Server management extensions:
· The Make primary key and Clear primary key commands are now accessible
anywhere in the software (Table Editor, Explorer Tree, Object Browser, etc);
Interface improvements:
· The tabbed interface is implemented in addition to classic MDI (see screenshot).
You can choose your favorite UI in the Options dialog;
· MySQL Maestro now stores parameters history for procedure execution so you can
choose a set of already used values instead of entering them manually;
· SQL Script Editor : if a user opens a file larger than 100K, MySQL Maestro will
255
suggest him to execute the script file without opening it in the editor. Of course it is also possible to execute any script file using this way: just press the "Execute
script from file" link on the Script Editor navigation bar and specify the filename;
· We have implemented the Data Analysis , a tool to represent your data as OLAP
275
cubes;
· Database profiles are now grouped by host+port+login combination rather than host
+port in the previous versions;
· The Table Editor interface is improved: now all the subitems i.e. fields, indexes,
106
and triggers are displayed at the main editor tab. We found this layout more comfortable;
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 23
· BLOB viewer /editor : the text pane provides now several types of text
266 224
highlighting (Plain text, HTML, JScript, CSS, PHP, XML, SQL, and SQLite DDL). Also it is possible to find and replace a text fragment of a BLOB column data;
· It is now available to refresh schema object list whenever an object depends on
other objects e.g. refresh table list on view creation;
· The Insert key is now a shortcut for creating a new database object from the
Explorer tree;
· Create Profiles Wizard : we've added an option for converting new object names
79
to lower/upper case;
· Data grid: the speed of data loading was significantly increased.
10/20/2006 MySQL Maestro 6.10 released
A new version of MySQL Maestro, a powerful Windows GUI solution for MySQL server administration and database development, has been released.
Please consider the list of all new features implemented in MySQL Maestro 6.10:
· The new version connects to the database much faster because of using the
information_schema database (MySQL 5.0 and higher).
· It is now possible to view/change SQL scripts generated by MySQL Maestro before
executing.
· Support of events (MySQL 5.1.6+) and table partitions (MySQL 5.1.3+) is
158 129
implemented.
· Now it is possible to read and set object grants and user permission even you
200
have no access to mysql database.
· Support of all the user permissions (up to MySQL 5.1.12) is provided.
· A new tool for multi-dimensional analysis, Data Analysis (OLAP Viewer), is
implemented in the new version MySQL Maestro. With the tool it is able to slice and dice information efficiently and provide customers with an extremely intuitive end-user experience. Data can be rendered to answer business questions - and best of all - it allows you to focus on business rules rather than creating dozens and dozens of reports.
· Server scope objects (such as users, UDFs, etc) are now displayed in the Explorer
tree. There is also a separate branch for all the triggers.
· SQL Editor improvements: now you can execute each query in a separate thread in
order to continue your work with the software while the query is executing. The Procedure and Function editors are also improved for the purpose of executing the routine asynchronously.
· Create Object Wizards are improved: now it is possible to specify all the object
© 2009 SQL Maestro Group
MySQL Maestro Help24
properties and subitems during its creation. The Create View Wizard now includes the Filter Builder dialog to facilitate creating WHERE condition. Also the wizards became resizable now for more usability.
· MySQL security management became easier. Now you can set all object
permissions within the Object Editor.
· Table Editor: Foreign key references is implemented. This feature allows you to
127
manage foreign keys that are created in other tables and reference columns of the current table.
· Object Browser tool for operating on database objects designed as an extension
58
of Database Explorer with advanced features such as sorting, grouping and filtering the database objects. It also provides such operation as multiple selecting of objects (for copying, dropping, etc.) and the ability of using drag-and-drop operations between Object Browser and Database Explorer is implemented.
· For your convenience it is implemented the second mode of viewing data as info
cards.
· New Explorer option "Display system object in different color" allows you to mark
system objects with customizable color (purple by default).
· Table Editor provides viewing of text fields' contents in data grid.
· The Code Folding feature is implemented in all the SQL editors and viewers. The
255
Code Folding item group makes it possible both to view the whole text and to divide it into logical parts (regions). Each part can be collapsed and extended.
· SQL Editor: the pair bracket highlight is available for your convenience.
· Now it is possible to set character set and collation during the database, table or
field creation. They also can be changed within the corresponding editors.
· Table maintenance commands (Analyze Table, Check Table, Repair Table, Optimize
Table) are now available from the Table Editor or from popup menu of Database
Explorer.
· Server Editor and Database Editor are added.
· MySQL Maestro provides now the ability to describe the object directly from the
Database Explorer.
· New software look and feel: program icon, installer, splash screen, wizard image
and various other interface improvements.
In addition to this, a lot of other improvements and bugfixes were made.
09/01/2005 - New version format
When setting product versions, we have accepted the following principles for version format:
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 25
· the first figure of the product version stands for the year of release;
· the second figure of the version is meant to indicate the month of the current
version release.
For example, MySQL Maestro 5.4 (former version 1.9) indicates that the version was released in April 2005.
Please refer the present news item for checking out whether your current product version is the latest one released.
08/02/2005 - MySQL Maestro 1.95 released
The key feature of this version is support of triggers, which were actually implemented in MySQL 5.0.10. You can add new triggers to the database and edit existing ones using the Trigger Editor as well as removing needless triggers. Also triggers are now supported by the Extract Database and SQL Script Editor modules.
Other improvements and bugfixes:
1. Fixed a bug with reordering table fields for MySQL 4.1 and higher.
2. SQL Script Editor: the CREATE VIEW statements with the ALGORITHM keyword are now displayed correctly in the object tree.
3. Extract Database: now default character set is included into database definition for MySQL 4.1.x and 5.x.
4. Fixed a bug with displaying the View Editor toolbar.
5. SQL Editor: it is now possible to see the results of CHECKSUM TABLE statements.
6. Other small improvements and bugfixes.
04/28/2005 - MySQL Maestro 1.9 released
1. Stored procedures and functions are now compiled correctly under MySQL 5.0.3 and higher.
2. Support of character sets and collations is added to the Create Database and Create Table wizards (for MySQL 4.1.x and 5.x).
3. Support of new MySQL privileges is implemented. Now it is possible to grant/revoke CREATE VIEW and SHOW VIEW privileges (MySQL 5.0.1 or higher) as well as CREATE ROUTINE, ALTER ROUTINE and CREATE USER privileges for MySQL 5.0.3+.
4. The "Manage Database Objects" submenu is added in the popup menu of the Explorer Tree. Use it to quickly open the Object Manager tool with database tables, views, procedures, etc.
© 2009 SQL Maestro Group
MySQL Maestro Help26
5. All database objects now can be dragged from the Explorer Tree to the SQL Script
Editor (the SQL definition of the object will be pasted). Also you can drag-n-drop
tables and views from the Explorer Tree to the SQL Editor; in this case a SELECT statement will be generated.
6. The Ctrl+F7 and Ctrl+F9 shortcuts now can be used to compile views, procedures, and functions.
7. Russian localization included into the installation package (thanks to Elmir Mirdiev). Earlier our software was also translated to French and Italian languages.
8. The Close View item is added to the Main Menu | Windows | Close submenu.
9. Double-click at the column header area of an object list (fields, indexes, etc) does not invoke the corresponding editor anymore. Similarly double-click at the Data Grid's header does not invoke the Data Input Form.
10. Default values are now displayed correctly in the field list.
11. Fixed the bug with editing DATETIME fields in the Data Grid and Data Input Form.
12. Some other improvements and bug fixes.
12/16/2004 - MySQL Maestro 1.8 released
1. The Code Insight system now supports aliases in SELECT queries. For example, you
can type something similar
SELECT * from mytable t where t.
and MySQL Maestro will display you the list of all the table fields in the popup window.
2. Since this version it is possible to use the "Database Tools" item in the popup menu
of the Explorer Tree and Database Profile Manager to get access to some frequently used modules such as SQL Editor, Visual Query Builder, Extract
Database, etc more quickly.
3. The Add Index window is redesigned to make index creation more comfortable.
4. Now MySQL Maestro doesn't disconnect from an active database if you change its
profile properties (except changing server or database name).
5. Data Grid: double click on the grid now invokes the Data Input form. Also we've
added shortcuts for such operations as Export Data, Import Data, Get SQL Dump, etc.
6. It is now possible to open the corresponding object editor directly from the BLOB
Viewer (see the "Edit BLOB Source" link).
7. The MySQL Help System is now available for the Security Manager.
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 27
8. Some interface changes for improving multilingual support.
9. Some other minor improvements and bug fixes.
10/15/2004 - MySQL Maestro 1.7 released
Version 1.7 released. The multilingual support is implemented: now our software can be translated to any language. The Italian (thanks to Giuseppe Maxia and StarData s.r.l.) and French (thanks to Renaud Lepage) translations are included into the installation package. To change the application language, select it from the Main menu | Tools | Languages menu. It is also easy to translate MySQL Maestro to another language: just find the English.txt file in the MySQL Maestro\Languages directory, save it as YourLanguage.txt and translate all the strings from the file using any text editor e.g. Notepad or MS Word. If you send as a new translation, we'll provide you with a free business license of MySQL Maestro.
Other improvements and bug fixes:
1. The "Auto link tables by foreign keys" option is added to the Visual Query Builder settings. If this option is on, MySQL Maestro will automatically add links between tables when you add a new table to the Query Builder area. Of course this option works only if your MySQL server supports the foreign keys.
2. The Copy to Clipboard item is added to the Data Grid's popup menu. Use it to copy selected records to the Windows clipboard. Records in the clipboard are separated by the line break character. The Tab character is used to separate values within a record. To copy all the grid records at the same time, you can use the Select All item, which is added as well. Both these operations are also available through the main menu.
3. The Show Filter Panel and Show Subobjects buttons are added to the MySQL Maestro main tool bar.
4. The Ctrl+O and "Ctrl+D" shortcut keys are now associated with Object Manager and Database Profile Manager accordingly.
5. The Data Export page is added to the MySQL Maestro options dialog. Here you can specify the formats for data exporting. If you set ON the Auto save format option, MySQL Maestro saves the data formats each time you change them in the Export
Data Wizard. The Set Defaults button resets all the export formats.
6. Since this version it is not necessary to close/open windows with data grids (e.g.
Table Editor or SQL Editor) to apply the changes you made in the Options dialog.
7. Security Manager: now grants are set correctly for all MySQL servers (there were some problems with 3.23.xx versions).
8. Some other minor improvements and corrections.
08/25/2004 - MySQL Maestro 1.6 released
© 2009 SQL Maestro Group
MySQL Maestro Help28
Version 1.6 released. In this version we have implemented the support for views, which are available in MySQL starting from version 5.0.1. The views are usually used for more friendly representation of data selected from one or several tables. They also can be used to limit an access for data viewing or editing by users. Also we have adapted MySQL Maestro for managing stored procedures and functions, which are belong to individual database instead of a host starting from version 5.0.1 of MySQL server.
Several improvements and bug fixes:
· Retrieving of stored procedures and functions from a server does not require a user
to have any permissions to the 'mysql' database;
· Fixed bug in the Export Data Wizard with loading destination file format and file
name from a template;
· The popup window for parameters input appeared incorrectly in some cases;
· Fixed bug in the SQL Script Editor with parsing negative numbers within the INSERT
INTO statement in some cases;
· Field list on the step for customizing Excel file format could contain duplicate
values;
· The "Server's host key did not match the signature supplied" error appeared during
connection to some SSH servers. Now it is fixed.
07/12/2004 - MySQL Maestro 1.5 released
Version 1.5 released. In this version we have implemented a possibility to connect to a remote MySQL server using a secure protocol. The secure connection is established through the Secure SHell (SSH) tunnel, which guarantees a high security for the data transmission between a local PC and remote MySQL server. All the parameters for the SSH connection are stored in database profiles as extra properties, and can be specified as follows:
· In the Create Database Wizard , when you create a new database. In this case
72
the SSH connection is established before the database is created, and all the SSH parameters are stored in the database profile, if an appropriate option is checked in the wizard.
· In the Create Database Profile Wizard , when you register existing database(s).
79
The SSH parameters are also stored in the database profiles.
· In the Edit Database Profile dialog, when you edit an already registered
86
database profile.
Also MySQL Maestro can ask you for the SSH parameters when you attempt to retrieve user privileges or server variable list through the SSH tunnel in the Security Manager or
Server Properties window.
· In addition to the described feature we have made some small improvements and
several minor bug fixes. Here is a list of most important changes:
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 29
· we've made the Export Data and Import Data wizards sizeable for easier
navigation within their controls;
· the columns containing a user name, user host, and database object are frozen
in the Security Manager for convenience purposes now;
· table type can be reported incorrectly in the Table Properties dialog with MySQL
4.1.3;
· there could be a problem to create a new database if the server port number was
different from the default one;
· fixed bug with the 'commands out of sync' error occurred with executing
subqueries in the SQL Editor in some cases.
05/28/2004 - MySQL Maestro 1.4 released
Version 1.4 released. Now it is possible to manage several table subobjects at once e.g.
· create/edit/drop all the indexes and foreign keys for a whole database. This
feature is available in the Create Database Object dialog, which can be invoked from the Object menu;
· drop several fields, indexes, or foreign keys at a time for a table: just select
required objects at the proper page of the Table Editor and simply press the Del key;
· copy several fields, indexes, or foreign keys from one table to another: you can do
it using standard Copy/Paste functions or by drag-n-drop between two instances of the Table Editor.
Several minor bugs were fixed:
· there were some troubles with copying tables containing foreign keys from one
database to another;
· the Copy Database wizard did not copy tables with foreign keys properly in some
cases. The "Disable foreign key checks" option was added to the final step of the wizard to avoid this problem;
· the Windows -> Close All menu item did not closed all child windows in some cases;
· the database explorer did not restore its width after sequential hiding and showing
by its splitter.
04/09/2004 - MySQL Maestro 1.3 released
In this version we have implemented the Object Manager - a feature-rich tool for easy manipulation of database objects. Now it is possible to work with tables, queries,
© 2009 SQL Maestro Group
55
MySQL Maestro Help30
procedures and other database objects as easy as it can be. Here are some examples, which demonstrate how you can use the new tool:
· you can open several database objects at a time;
· you need to clear data from all database tables? Just open the Object Manager,
press Ctrl+A, then choose Empty Tables from the popup menu;
· in earlier versions of MySQL Maestro you can copy a table definition to the
clipboard by Ctrl+C and then paste it in the same or different database. Now it is possible to process several tables at once;
· it is also possible to drop several database objects at a time. Hope you will treat
this tool carefully.
· full drag-n-drop support is available: you can drag objects between the Object
Manager and the Database Explorer as well as between two instances of the Object Manager;
and much more.
The Object Manager starts automatically when you connect to a database. It is possible to disable this feature in the Options dialog as well as call the Object Manager manually from the Object menu.
We also have fixed several bugs:
· the Diagram Viewer did not clear the list of fields after switching to another
database using combo box in the Database group area. This bug could cause some instability of the application;
· the Move Up/Move Down menu items did not work in the field list on the second
step of the Create Table wizard;
· some steps of the Create New Procedure and Create New Function wizards did not
open the proper help topic after clicking on the Help button.
03/08/2004 - MySQL Maestro 1.2 released
The main feature of this version is the Diagram Viewer . It is a tool for representing
271
data from a table or a query as a diagram in various ways. Also the Diagram Viewer has the Export diagram image feature, as well as the Export diagram data one, with a lot of formats supported. The interface of the new tool is liked to BLOB Viewer, so we hope it will be easy to use.
Some technical details:
· you can save the diagram as Bitmap, PDF, JPEG, GIF, PostScript, Metafile, VML,
PNG, or PCX file. Of course it is possible to open the result file in the associated application (e.g. Paint, Acrobat Reader, Photoshop, etc) directly from MySQL Maestro;
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 31
· supported diagram types are: bar, line, area, point, pie, or fast line;
· it is possible to show/hide diagram axis;
· it is possible to show/hide the diagram legend;
· it is possible to specify axis labels source and diagram header.
The Diagram Viewer is located in the Tools menu, the appropriate button on the toolbar is also available.
Several minor bugfixes:
· the confirmation dialog appeared for each database object dropping even if an
appropriate option was off in the Options dialog. Now this bug is fixed;
· fixed bug with impossibility to disconnect from a database if the MySQL server was
shut down during the connection session;
· group boxes did not appear in accordance with current scheme in some cases.
02/04/2004 - MySQL Maestro 1.1 released
In this version we have implemented the Database Profile Manager, which is a tool, designed as an extension of the Database Explorer with some advanced features. In particular, it allows you to:
· connect/disconnect several databases at a time;
· remove a group of database profiles. It is useful if you don't work with these
databases any more;
· get quick access to the selected database profile properties.
Of course it is also possible to create a new database, attach an existing database to MySQL Maestro, or drop a database. The Database Profile Manager can be launched by the proper menu item from the main menu or by the corresponding button on the toolbar.
Also we have fixed some minor bugs:
· the Create Database Profiles wizard did not work with servers, which do not allow
to execute the SHOW DATABASES command to retrieve the list of available databases. The corresponding options was added to the wizard to fix this bug;
· fixed bug with impossibility to create more than one database during one
application session;
· there was a bug with reordering database profiles in the database explorer using
drag-and-drop operations;
© 2009 SQL Maestro Group
MySQL Maestro Help32
· the Show Subobjects option lost its state and always switched off after exiting
MySQL Maestro and running it again. It is fixed now.
01/07/2004 - First public release of MySQL Maestro
MySQL Maestro is a powerful solution for the MySQL server administering and
development. We tried to create a new software, which includes itself the best things available in the existing products as well as implements an unique functionality.
Please find below a short list of the main MySQL Maestro features:
· support of all the latest versions of MySQL server from 3.23 to 5.0;
· fully self-dependency: MySQL Maestro does not require a client library (even
libmysql.dll) to connect to MySQL;
· easy database object management;
· user-friendly interface;
· powerful security manager;
· stored procedures and functions support;
· powerful BLOB viewer /editor ;
266 224
· data export and data import modules.
Of course this list does not contain all the things implemented in our software. With MySQL Maestro you can, for example, create a new table in a few mouse clicks, get SQL
239
dump of your metadata and data (even without knowledge of both syntaxes), get a
high-quality printable report for your database, execute any SQL script , copy a table
255
from one database to another by drag-n-drop or by pressing Ctrl+C/Ctrl+V, backup, restore, analyze, check, repair, and optimize tables, and many many more. In short our product makes MySQL server as easy as ABC. :-)
© 2009 SQL Maestro Group

1.7 Getting Started

Welcome to MySQL Maestro! 33
To start working with MySQL databases in MySQL Maestro you should first create a database profile or several database profiles using Create Database Profiles Wizard . If
79
you have no databases to create profiles for, you can create a new database through
Create Database Wizard . After that you can connect to the database, manage its
72
objects, table data and so on. See the instructions below to learn how to perform these operations in the easiest way.
Enjoy working with MySQL Maestro!
© 2009 SQL Maestro Group
MySQL Maestro Help34
This part's topics contain the shot overviews of the common principles for working with our software:
· How MySQL Maestro looks when you start it for the first time

· Explaining user interface

· Working with databases
· Switching between windows
1.7.1 Explaining user interface
The SQL Maestro Group products are famous for their clear and intuitive user interface. The programs are built around the three-pane workspace that includes the database
explorer and child windows consisting of the navigation bar and work area.
This topic provides a brief guide to the components of MySQL Maestro's user interface. For detailed descriptions, see below.
36
34
37
39
Database Explorer
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 35
Execute query
(F9) or (F8)
Execute query as script
(Shift+F9) or (Shift+F8)
Execute selected only
(Alt+F9) or (Alt +F8)
Window list
Alt+0
Previous Window
F6
Next Window
Ctrl+F6
The Database Explorer field occupies the left side of MySQL Maestro main window. It represents all the connected databases objects including system objects .
89
The explorer provides the fastest way to reach the object properties, to perform the following operations with database profiles using the popup menu:
· create new objects (database profiles, database objects, table objects...);
· edit currently selected objects;
· remove currently selected objects from the explorer tree;
· duplicate objects;
· rename objects if available and edit object comments out of the object editor.
Editors and Viewers
According to the MDI style implementation the MySQL Maestro tools and editors are opened in appropriate windows. Each window consists of a navigation bar and work area. The software supports Classic and Tabbed MDI.
See also: Switching between windows , Tabbed MDI
39 35
Navigation bar
The Navigation Bar contains a set of logically grouped links provided to realize the corresponding actions. Just position the mouse over a link and wait for a second to display the appropriate action shortcut making it possible for experienced users to control the program almost entirely with the keyboard. You can find several shortcuts below.
Toolbars
The bars occupy the top of the main window. The Toolbars provide quick access to the most frequently-used functions. Just position the mouse over a tool and wait for a second to display a brief text describing what it is for.

1.7.2 Tabbed MDI

For your convenience, MySQL Maestro provides you with a possibility to choose (
Options|Application) your favorite UI. Among classic MDI style that is shown on the
most manual screenshots the tabbed MDI style is also available.
Applying the style you'll get all the objects editors opening on separate sheets. You can move from one sheet to another by clicking the sheet tabs at the bottom of the working area. The tab for the active sheet is underlined in the color you choose; tabs for inactive sheets are fully colored.
© 2009 SQL Maestro Group
MySQL Maestro Help36
You can switch between the sheets with corresponding sheet tabs or using Ctrl+Tab. If you don't see the tool you want, click the tab scrolling buttons to display the tab, and then click the tab. You can also move the sheets.

1.7.3 First time started

This is how MySQL Maestro looks when you start it for the first time. Select the
Database | Create Database Profiles main menu item to create profiles for the existing
databases or the Database | Create new database main menu item to create a new database and (optionally) to create a profile for it in Create Database Wizard .
79
72
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 37

1.7.4 Working with databases

After you have created the required database profiles (Create Database Profile Wizard
79
) they appear in the explorer tree on the left. Now you can establish connection to the database. If connection succeeds, the database node expands displaying the tree of its objects.
Now you can perform all the necessary MySQL admin routines such as creating, editing, copying, extracting and dropping database objects, design your database as ER diagram, build queries visually, execute queries and SQL scripts, accomplish database administration operations in a few mouse clicks, view and edit data including BLOBs, represent data as diagrams and pivot grids, analyze information summarized into OLAP cubes, export and import data to/from most popular file formats, manage server security features, and use a lot of other admin tools designed for making your work with MySQL
© 2009 SQL Maestro Group
MySQL Maestro Help38
server comfortable and efficient.
· Basic principles of working with objects in MySQL Maestro
· Database Editor
· Database Profile Editor
· Database Object Management
· Queries
169
· Database Tools
77
86
96
254
40
© 2009 SQL Maestro Group

1.7.5 Switching between windows

The Window List dialog allows you to switch the child application windows quickly. To open the dialog select the Windows | Window List... item of the main menu or use the Alt+0 hot keys combination.
Most of the windows are linked according to their active databases and displayed in the form of a tree, e.g. Table Editor, SQL Editor, Diagram Viewer, etc. Windows which are common for the entire program are shown as separate nodes of the tree.
Welcome to MySQL Maestro! 39
To activate the window you need, select one of the window tree items and click the OK button.
© 2009 SQL Maestro Group
MySQL Maestro Help40

2 Basic principles of working with objects

MySQL Maestro provides you with all the tools you need to manage and navigate MySQL objects. Note that at least one connection to a database should be established to make these tools available.
The following list contains the most common features provided by MySQL Maestro to administrate MySQL objects.
· Database Explorer
· Wizards and Editors
· Object Manager
· Object Browser
· Duplicating Object
41
45
55
58
62
· Changing Object Properties
· Describing Object
69
68
© 2009 SQL Maestro Group
2.1 Database Explorer

Database Explorer is the basic feature of MySQL Maestro which allows you to perform

practically all necessary operations upon databases and their objects. The Database
Explorer field occupies the left side of MySQL Maestro main window. All the objects at
the Explorer tree are grouped by kind and listed under the according MySQL servers/ database node.
To start working with a database you need to create its profile first. The conception of database profiles gives you an opportunity to connect to databases in one touch and work with the selected databases only.
Basic principles of working with objects 41
See also: Object Manager , Object Browser
55 58
Note: In case your databases have a large quantity of objects you can speed up the object search by typing first letters of the object name in the explorer area.
Note: You can also customize the Explorer to hide/display table subobjects, represent
296
system objects in different color, etc.
The sections below describe each of these actions in detail.
· What operation can I accomplish upon database profiles within the Explorer Tree?
· How can I connect to a database?
· How can I disconnect from a database?
41
43
· What operations can I accomplish upon database objects within the Explorer Tree?
43
· Can I copy a database object from one database to another?
· Can I filter Explorer content?
· How can I create new/drop a database?
44
43
43
42
© 2009 SQL Maestro Group
MySQL Maestro Help42
Operations upon database profiles in the Explorer Tree
Using popup menu of the Explorer area you can realize the following operations:
· create new database profiles (the Create Database Profiles... item);
· edit currently selected database profile (the Edit Database Profile... item);
· remove currently selected database profile from the explorer tree (the Remove
Database Profile item).
In addition to these operations, Database Explorer gives you an ability to reorder existing profiles by performing drag-and-drop operations within the explorer tree.
© 2009 SQL Maestro Group
Basic principles of working with objects 43
How can I connect to a database?
You can establish connection to a database in Database Explorer by selecting the database profile and double-clicking it or pressing the Enter key (alternatively, you may use the Shift+Ctrl+C hot key combination). The same operation is also available through the Connect to Database item from the explorer popup menu, or through the
Database | Connect to Database main menu item.
How can I disconnect from a database?
You can abort connection from a database in Database Explorer by selecting the database profile and pressing the Shift+Ctrl+D hot key combination. The same operation is also available through the Disconnect from Database item from the explorer popup menu, or through the Database | Disconnect from Database main menu item.
Operations upon database objects
Database Explorer allows you to perform the following operations with database objects
using its popup menu (note that the popup menu contains object-specific items only when some database object is currently selected in the explorer tree):
· create a new database object (the Create New Object... item);
· edit currently selected database object (using the Edit Object... item, pressing the
Enter key or double-clicking the database object);
· drop the selected object from the database (the Drop Object... item);
· rename the selected database object (the Rename Object... item);
· edit the database object properties (the Object properties ... item);
· duplicate the selected object (the Duplicate Object... item).
· run the Object Browser tool (the Browse ... item).
Can I copy a database object from one database to another?
Database Explorer provides you with an ability of copying database objects from one
database to another. To perform this operation, you should connect to both the source and the destination databases first. After the connection is established, simply drag and drop an object to copy from the source database to the corresponding node (Tables,
Queries, etc.) of the destination database.
Note: You also can use the Edit | Copy and the Edit | Paste main menu items
to copy/paste a database object using Windows clipboard (alternatively, you may use the Ctrl+C/Ctrl+V hot keys combinations respectively).
How can I create new/drop a database?
To create a new MySQL database (not existing on your MySQL server) with Database Explorer, select the Create New Database... item from the popup menu and set all the necessary options within the Create Database Wizard .
72
To drop an existing database using Database Explorer, connect to the database you wish
to drop, select the Drop Database item from the popup menu of the database and confirm dropping in the dialog window.
© 2009 SQL Maestro Group
MySQL Maestro Help44
Note: Alternatively, you can use the Database | Create New (Drop) Database
main menu item to perform these operations.

2.1.1 Filtering explorer content

MySQL Maestro allows you to reduce the number of represented objects in the explorer tree. To hide seldom usable objects, filter your explorer content.
Filter Panel is available through the View | Show Filter Panel main menu item.
· Specify the Filter expression. The expression can contain any part of object name
combined with an asterisk ('*') as a wildcard character and a question-mark ('?') as a mask character.
· Define the Filtered objects, object types for filtering in the explorer tree.
· Check the according radio button (Show by expression, Hide by expression) to
define whether database objects will be shown or hidden in accordance with the filter expression.
· Click Apply button.
Note: A filter expression, if applied to the content of Database Explorer, is
applied to the content of Object Manager and Object Browser as
55 58
well.
© 2009 SQL Maestro Group

2.2 Wizards and Editors

MySQL Maestro provides wide opportunities to create and edit MySQL objects within the appropriate wizard and editor correspondingly.
Create Object Wizards can be invoked from the MySQL Maestro main menu (Object |
Create Database object). Also it is possible to call them from the Database Explorer's
popup menu, from the Navigation Bar of the respective Object Editors, as well as from such tools as Object Manager and Object Browser.
To open an object editor, just double click its node in the Database Explorer tree. Of course this action is also available through popup menus, navigation bars, and so on.
Basic principles of working with objects 45

· Create Object Wizards

· Object Editors
47
See also: Object Manager , Object Browser
2.2.1 Create Object Wizards
MySQL Maestro provides a number of Create Object Wizards to accomplish the most facile MySQL object creation. Easily understandable wizard steps allow you to specify all the object properties.
Several wizard steps are common for all wizards. This part purpose is the formulation of the basic principles for the Create Object Wizard organization.
· On the first wizard step you need to specify the new object name.
· On the second one you have to define all the object properties. To clear up the
object properties meanings see the appropriate topic of the respective Create Object Wizard section.
· Some objects has subitems (e.g. each table contains fields, indexes, procedures
have parameters, etc). In this case the next step allows you to manage such subobjects of the object being created. We recommend you to store the following shortcuts in order to speed your work: the Ins key adds a new subobject, the Enter key displays the subobject's editor, and the Del key drops the subobject.
45
55 58
46
· The next wizard step is final. It is provided to sum up the Create Object Wizard
operation.
Note: There are some objects to have an additional Create Object Wizard
steps. The detailed description of the steps you can find at the appropriate topic of the corresponding section.
See also:
· Create Table Wizard
· Create View Wizard
· Create Function Wizard
· Creation of a New Query
· Create Procedure Wizard
© 2009 SQL Maestro Group
46
100
131
149
169
140
MySQL Maestro Help46
· Create Event Wizard
2.2.1.1 Setting object name
Select the container (table, schema, database, etc.) for the new object from the list of available containers and enter the new object name in the respective box.
Note: the name of the object must be unique among all the object names in its
container. Moreover, all the objects that are source of data need unique names among themselves. You can use any identifier that is allowed by MySQL server.
159
339
2.2.1.2 Viewing commom information
At this step common information about the object to be created is displayed. Select the
Open object editor after creating option to open the appropriate Object Editor after the
new object is created. Click the Ready button to complete creation of the object.
© 2009 SQL Maestro Group
Basic principles of working with objects 47

2.2.2 Object Editors

Database Object Editors are the basic MySQL Maestro tools for working with existing
objects. The proper editor can be opened automatically after the object is created and is used for specifying and editing necessary object properties. You can also open the necessary object editor within the Explorer Tree or Object Manager.
The editors consist of a several tabs. Several tabs are similar for all editors. This part purpose is the formulation of the basic principles for the Object Editor organization.
· To edit main table properties such as name, owner, comment, and others use the
Properties tab. To clear up the object properties meanings see the appropriate
topic of the respective Object Editor section.
· In case the object has subitems (e.g. each table contains fields, indexes,
procedures have parameters, etc), its editor contains the corresponding tab named Subitems. You can add, edit or drop subobjects using the grid's popup menu or editor's navigation bar. To change the subitems' options, use the corresponding editor. For example, to modify function or procedure parameter, use Parameter
Editor .
· Use the Permissions tab to manage access privileges (grants) of the
corresponding object.
· In a similar manner, some objects called grantees (e.g. users or roles) can have
rights to do something with other objects (e.g. a user can read data from a table).
52
48
© 2009 SQL Maestro Group
MySQL Maestro Help48
This relationship can be set up at the Grants tab.
· Most of objects have a possibility to be created from an SQL script (SQL
definition). If so, the corresponding script is available at the SQL tab of the editor.
· There is a Result tab in editors of such routines as functions and procedures that
can take parameters, perform calculations or other actions, and return a result. You can execute any routine directly from its editor.
Note: Some object editors have additional tabs. The detailed description of
them you can find at the appropriate topic of the corresponding section.
To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl +F9 or Ctrl+F7 shortcut keys.
It is also possible to modify object properties without opening the object editor: use the
Object Properties item of the popup menu of the selected object from the explorer tree.
2.2.2.1 Permissions of the Object
The Permissions grid allows you to manage access privileges (grants) of users.
49
51
53
Grants give specific privileges for an object (table, view, query, database, function, procedure, etc.) to one or more users.
© 2009 SQL Maestro Group
Basic principles of working with objects 49
Using the grid you can grant/revoke privileges as well as sort and filter displayed grantees.
See also: Users
2.2.2.2 Object grants
The Grants grid allows you to manage access privileges (grants) of the current object.
A grant gives specific privileges on an object (table, view, procedure) to the current one.
All objects are grouped by kind. Filter the object kinds using the checkboxes at the bottom of the window. Using the grid you may sort and filter data.
© 2009 SQL Maestro Group
195
MySQL Maestro Help50
To grant the subject privilege on the object double-click an empty field; to revoke the privilege double-click a grant with grant option.
Use grid’s popup menu to grant, grant all, grant with grant option, grant all with grant option, grant on all, grant on all with grant option, revoke, revoke all and revoke on all:
· select the Grant item to grant the subject privilege on the object;
· select the Grant All item to grant all the privileges on the object;
· to revoke the privilege, all the privileges on the object or the privileges on all the
server objects select the Revoke, Revoke All or Revoke On All items respectively.
Using the popup menu you can also collapse or expand all the object kinds.
© 2009 SQL Maestro Group
2.2.2.3 SQL Definition
The SQL tab displays the SQL definition for the object with all its properties. Bear in mind that this text is read-only. If you want to change the object definition, use the appropriate editor tabs instead, or copy the text to the Windows Clipboard to paste it in SQL Editor or SQL Script Editor.
The SQL definition window allows you to browse the text effectively. The popup menu and the extensive system of hot keys give you the opportunity to search expressions within the text, to select the whole text for copying it to the Windows Clipboard, to save the definition to the *.sql or *.txt files, to print the document, etc.
Basic principles of working with objects 51
You can customize the displayed definition using the Editors & Viewers options.
313
The Properties item of the popup menu displays the Options dialog in which you can establish optional settings concerning the current database.
The Code Folding item group makes it possible to view either the whole text or its logical parts (regions). Each region can be collapsed and extended.
In extended mode the whole text is displayed (set by default)
In collapsed mode the text is hidden behind one text line denoting the first line of the collapsed region.
The latest software version allows to Copy to SQL Script Editor (available in the
Navigation Bar on the SQL tab). Use it for quick copying object’s SQL definition (DDL) to
the SQL Script Editor for future modifications.
© 2009 SQL Maestro Group
MySQL Maestro Help52
2.2.2.4 Parameter Editor
Parameter Editor allows you to set parameter options in a few mouse clicks.
Use the Parameter name box to set the parameter name. Note that the name of the parameter must be unique among parameter names in the function.
The Data type drop-down list defines the type of the parameter.
Use the Scope box to set whether parameter is Input, Output or Input-Output.
© 2009 SQL Maestro Group
Basic principles of working with objects 53
2.2.2.5 Executing functions and procedures
Function Editor provides an opportunity to execute current routine by opening the Results
tab, by clicking the Execute item of the Navigation Bar, or by pressing the F9 key.
If the Function has parameters, MySQL Maestro will ask you to specify the values for these parameters in the Input parameters dialog which appears before the procedure execution. Input parameters dialog allows you to specify the values for all input parameters. After changes are made, click the OK button to execute the Function, or the
Cancel button to abort the execution.
© 2009 SQL Maestro Group
MySQL Maestro Help54
MySQL Maestro supports Parameter History. Values that have been set previously as the routine parameters are represented in the History tab of the Input Parameter dialog with a date and time of their last using. Double click a necessary set of values to set them as the routine parameters. You can manage the Parameter History with Delete history item and Clear history links.
The result of the successfully executed routine can be found within the Results tab of
Function Editor.
Note: If any unsaved changes are applied to the routine being currently edited, the
execution of the routine is impossible until changes are saved by the Compile procedure item of the Navigation Bar.
© 2009 SQL Maestro Group
2.3 Object Manager
Basic principles of working with objects 55

Object Manager is a tool for operating on database objects designed as an extension of

the Database Explorer with advanced features, such as multiple selecting of objects
41
(for copying, dropping, etc.) and the ability of using drag-and-drop operations between
Object Manager and Database Explorer as well as between two instances of the Object Manager. To open Object Manager select the Object | Object Manager main menu item.
Note: At least one connection to a database should be established to make
Object Manager available.
· Using popup menu
· Multiple selecting of database objects
See also: Object Browser
56
56
58
© 2009 SQL Maestro Group
MySQL Maestro Help56

2.3.1 Using popup menu

The popup menu of Object Manager may have different content depending on the current selection. The common menu items allow you to switch the object list view between four standard modes (large icons, small icons, list and report), refresh the current view, and select all the objects in the view. If none of objects are currently selected, other menu items are unavailable to use, except of the one for creating a new object. If one or more objects are selected, clipboard operations (such as copy and paste) become available as well as the items for editing and dropping selected object(s). If the current object type of the Object Manager is "Tables", the Empty Table(s) menu item is also available.

2.3.2 Multiple selecting of objects

Object Manager allows you to operate on several objects at a time. You have an
opportunity to select a batch of objects and after the object group is selected, you can operate on it (e.g. drop several objects at once) as if it were a single object.
© 2009 SQL Maestro Group
Basic principles of working with objects 57
© 2009 SQL Maestro Group
MySQL Maestro Help58
2.4 Object Browser

Object Browser is a tool for operating on database objects designed as an extension of

Database Explorer with advanced features such as sorting, grouping and filtering the
41
database objects. It also provides such operation as multiple selecting of objects (for copying, dropping, etc.) and the ability of using drag-and-drop operations between
Object Browser and Database Explorer. To open Object Browser select the Object | Object Browser main menu item.
· Sorting database objects
· Grouping database objects
· Filtering database objects
59
60
60
Note: At least one connection to a database should be established to make
Object Browser available.
See also: Object Manager , Data View
55 210
© 2009 SQL Maestro Group

2.4.1 Sorting database objects

Object Browser represents database objects in a grid. The object kind to display is
defined on the top of the Navigation bar. The columns correspond to the objects properties and rows correspond to the objects. Click the column caption to sort objects by the values of this column in the ascending or descending mode. The navigation buttons allow you to open current object editor, create new or drop the existing one.
As Object Manager the browser allows you to operate on several objects at a time. You have an opportunity to select a batch of objects and after the object group is selected, you can operate on it (e.g. drop several objects at once) as if it were a single object.
The unique feature of the MySQL Maestro is an opportunity of drag-and-drop operations between Object Browser and SQL Editor, SQL Script Editor. After the action objects are represented in SQL Editor as SQL queries (if they contain data) or as their full name in the database otherwise. SQL Script Editor displays the objects as SQL definition.
Basic principles of working with objects 59
© 2009 SQL Maestro Group
MySQL Maestro Help60

2.4.2 Grouping database objects

You can group grid objects by any of the columns by dragging the column header to the destination area. Now all the records are displayed as subnodes to the grouping row value as shown in the picture. To reverse grouping, just drag the column name from the upper area back.

2.4.3 Filtering database objects

You can filter objects in the grid using one of the following methods:
· use the drop-down button in the column caption area to filter objects by the value
of the selected column
· click the drop-down button in the column caption area, then select the Custom
item and build a simple filter within the dialog in the following way: select a logical operator for checking the column values (like is less than, is greater than, etc) and set the value to be checked by this operator in the neighboring box; then set the second condition if necessary in the following way and set the relation between
© 2009 SQL Maestro Group
Basic principles of working with objects 61
these two conditions, whether both of them should be matched or just one of them; use the '_' character to represent any single symbol in the condition and the '%' character to represent any series of symbols in the condition
After you set a filter, the filtering panel becomes visible at the bottom of the grid where you can see the active filtering condition and easily enable or disable it by clicking the check box on the left. Using this panel you can also customize your filter in a more complicated way by clicking the Customize button and building your filter within the
Filter Builder dialog.
217
© 2009 SQL Maestro Group
MySQL Maestro Help62

2.5 Objects Duplicating

MySQL Maestro offers several ways of objects duplicating.
1. Duplicate Object Wizard. The wizard is the most flexible tool of the coping. Along
with a possibility to adjust the new object definition it allows you to copy data (for tables). But it consists of several steps and takes more time than other manners.
62
2. Duplicate Object window allows you to attune new object's SQL definition. It is
preferred for creation a copy of selected object. Here you can find some additional info.
3. By Drag-n-Drop operation.
66

2.5.1 Duplicate Object Wizard

The Duplicate Object Wizard allows you to create a new database object with the same properties as the existing one. It is the most flexible tool of copying objects provided by MySQL Maestro. It also allows you to copy data of the selected table to the new one.
To run the wizard select the Object | Duplicate Database Object... main menu item.
· Selecting source and destination databases
· Selecting object to duplicate
· Modifying definition of a new object
See also: Create Database Object
2.5.1.1 Selecting source and destination databases
Select the database containing a source object from the list of connected databases, and then specify the database for the duplicated object.
63
98
65
62
64
You should connect to the destination database beforehand (see Database Management
70
).
© 2009 SQL Maestro Group
Basic principles of working with objects 63
2.5.1.2 Selecting object to duplicate
Specify a database object to create the new one with the same properties.
1. Select the type of the object to duplicate from the Source objects drop-down list.
2. Pick up the necessary object from the list.
© 2009 SQL Maestro Group
MySQL Maestro Help64
2.5.1.3 Modifying new object definition
The last wizard step allows you to edit the new object definition directly.
Use this step to edit the name of object been creating (New Object Name). By default MySQL Maestro generates the new object definition with the same name if the duplicating is to the source database, or like "%SOURCE_OBJECT_NAME%01" otherwise.
Note: the name of the object must be unique among all the object names in its
container. Moreover, all the objects that are source of data need unique names among themselves. You can use any identifier that is allowed by MySQL server.
You can edit the result SQL statement manually, add or remove fields, change field types, using the New object definition text area. Click the Ready button to complete the operation. Check the according boxes to Copy Data (only for tables) and to Open Object Editor after the duplicating.
339
© 2009 SQL Maestro Group
Basic principles of working with objects 65

2.5.2 Duplicate Selected Object

Within the Duplicate Object window you can duplicate a selected object fast and with some modifications.
It is available from the corresponding link of the object's popup menu at the Database
Explorer.
© 2009 SQL Maestro Group
MySQL Maestro Help66
Select the database for a new object from the list of connected databases first.
Enter the name for the new object.
Note: the name of the object must be unique among all the object names in its
container. Moreover, all the objects that are source of data need unique names among themselves. You can use any identifier that is allowed by MySQL server.
You can also edit the SQL definition of the object if necessary (add or remove fields, change field types, etc.).

2.5.3 Copy, Paste and Drag-n-Drop features

MySQL Maestro provides you with an ability of copying database objects within the database or even from one database to another (in this case you should connect to both the source and the destination databases first).
To copy an object, just drag the object in a source window (such as Database Explorer,
Object Manager, Object Browser) and drop it to the target container in another window.
You also can use the Edit | Copy and the Edit | Paste main menu items or the Ctrl+C/ Ctrl+V hot keys combinations respectively. Copying several objects at a time is also available.
339
© 2009 SQL Maestro Group
Basic principles of working with objects 67
It is also possible to drag and drop objects between Database Explorer, Object Manager, Object Browser and SQL Editor or SQL Script Editor. This works as follows:
SQL Editor: after dropping the object you will get a query to retrieve object data (e.g.
SELECT * FROM table_name) or the full name of the object if it doesn't contain data (domains, indexes, etc.).
SQL Script Editor: after dropping the object you will get its SQL definition if applicable.
See also: Database Explorer , Object Manager , and Object Browser
41 55 58
© 2009 SQL Maestro Group
MySQL Maestro Help68

2.6 Changing Object Properties

It can be convenient to use the opportunity of editing object properties in the fastest way provided within the Object Properties dialog. The dialog allows you to view and edit the selected object properties quickly, without opening the object editor.
To open this dialog, select the Object Properties item from the popup menu of the selected object in the explorer tree.
To clear up the object properties meanings, see the appropriate topic of the respective
Object Editor section.
© 2009 SQL Maestro Group

2.7 Describing Object

Essentially a comment is the most often altered object property. To simplify it's editing, the MySQL Maestro provides an ability to Describe the object within the Database
Explorer immediately without opening of the object's editor.
Step-by-step:
· Select the necessary object in the explorer tree;
· Choose the Describe Object... item in the popup menu;
· Edit object comments within the Describe Object window;
· To commit the changes, push OK button.
Basic principles of working with objects 69
© 2009 SQL Maestro Group
MySQL Maestro Help70
Use for this purpose Create Database Wizard . In order to run the wizard you should either
· select the Database | Create New Database... main menu item
or
· use the Create New Database... item of the popup menu.
Using Create Database Wizard set the Create profile after creating the
database option to create a new profile and open the Database Profile Properties dialog after the database is created.
To edit a database:
· select the database to edit in the explorer tree;
· edit database properties within the appropriate tabs of Database
Editor .
In order to drop a database you should first select the database to drop in the explorer tree and establish connection (if you are not connected to the database yet), then either
· select the Database | Drop Database main menu item
or
· use the Drop Database item of the popup menu
and confirm dropping in the dialog window to complete the operation.
In MySQL Maestro database profiles are created within Create
Database Profiles Wizard . In order to run the wizard you should
either

3 Database Administration

MySQL Maestro allows you to manipulate databases by means of database profiles. Profile contains database connection settings and a set of options to automatize common manipulations with databases (a possibility to connect to the database at MySQL Maestro startup, login prompt before connection, etc.). To start working with databases in MySQL Maestro, you should create database profile(s) first.
Use the following links for details:
How can I create a new database?
72
How can I change attributes of an existing database?
77
How can I drop an existing database?
How can I create new database profiles?
79
© 2009 SQL Maestro Group
· select the Database | Create Database Profiles... main menu
item
or
· use the Create Database Profiles... item of the popup menu.
Using Create Database Profiles Wizard set the necessary connection
and authorization options and click the Ready button to complete the operation.
How can I edit existing database profile options?
Database connection properties and profile options are edited within the Database Profile Properties dialog window. In order to open the dialog for the selected database profile you should either
· select the Database | Edit Database Profile... main menu item
or
· use the Edit Database Profile... item of the popup menu.
In order to remove a database profile you should first select the database profile in the explorer tree, then either select the Database
| Remove Database Profile main menu item, or use the Remove Database Profile item of the popup menu and confirm removing profile
in the dialog window to complete the operation.
In order to connect to a database you should first select the database in the explorer tree, then either
· select the Database | Connect to Database main menu item
or
· use the Connect to Database item of the popup menu.
In order to disconnect from a database you should first select the database in the explorer tree, then either
· select the Database | Disconnect from Database main menu item
or
· use the Disconnect from Database item of the popup menu.
86
Database Administration 71
How can I remove database profiles?
How can I connect to a database?
How can I disconnect from a database?
© 2009 SQL Maestro Group
MySQL Maestro Help72

3.1 Create Database Wizard

To run the Create Database Wizard, select the Database | Create New Database... main menu item or click the Create New Database button on the main toolbar.
· Setting database connection properties
· Specifying database properties
See also: Database Editor
77
75
72

3.1.1 Setting connection properties

The first wizard step allows you to set connection properties for the new database.
MySQL Maestro allows you to connect to MySQL servers directly, via Secure SHell (SSH) tunnel or HTTP tunnel.
· Direct connection is the most preferable connection mode.
© 2009 SQL Maestro Group
Database Administration 73
· If your MySQL server does not allow direct connections from remote workstations, you
can establish connection to intermediate SSH server and forward all MySQL commands through the Secure SHell (SSH) tunnel.
· HTTP tunneling is a technique used in conditions of restricted network connectivity
including firewalled networks, networks behind proxy servers, and NATs. It is the slowest way and is recommended to use if the others are impossible.
Irrespectively of a connection mode you should specify common credentials as follows:
Host
The host name of the MySQL server.
Port number
The TCP/IP port to use if server is not localhost.
User name
The username used to connect to MySQL.
© 2009 SQL Maestro Group
MySQL Maestro Help74
To establish connection to intermediate SSH server and forward all MySQL commands through the secure tunnel, you need to:
1. Check I can connect to the server directly or via SSH tunneling.
2. Use Configure SSH options to open the SSH Options window.
3.Check Connect through the Secure Shell (SSH) tunnel and specify the following SSH connection properties.
Host name
Specify the host name or IP of your site.
Port number
Set the SSH server port number.
Enter valid User name and Password to log in to the remote server.
Note: MySQL host name always should be set relatively to the
SSH server. For example, if both of MySQL and SSH servers are located on the same computer, you should specify localhost as Host name instead of server's external host name or IP address.
Password
The password for the user account on server.
SSH tunnel connection
© 2009 SQL Maestro Group
Database Administration 75
To connect to a remote server using a PHP script, you need to:
1.Upload the connection PHP script to your website. The script is named mysql_tunnel.
php and can be found under the installation folder, usually C:\Program Files\SQL Maestro Group\MySQL Maestro.
2.Select the I have to use HTTP tunneling radio button.
3.Enter the connection PHP script URL, e.g. www.yoursite.com/files/mysql_tunnel.php. You can test the connection before the profile is created. Just use Test script using
default browser to open connection script in your browser, enter all the required
connection parameters and use the Test connection button.
4.In case using of a proxy server use Configure tunnelling options to open the HTTP
tunnelling options window and specify your proxy server connection parameters and HTTP authentication.
Note: You are actually connecting to your database through the PHP script on the server, so in most cases the host/server name is "localhost" unless the target server is not installed on the same server as the Web server.
HTTP tunnel connection
Check the Create profile after creating the database option to open the Edit Database
Profile dialog after the new database is created.
86

3.1.2 Specifying database properties

The next wizard step allows you to set common database options. All fields below are
© 2009 SQL Maestro Group
optional, i.e. it is not obligatory for you to fill them.
MySQL Maestro Help76
Collation
Use the field to specify the default collation for the database. Collation name can be either a Windows collation name or a SQL collation name.
© 2009 SQL Maestro Group
3.2 Database Editor

Database Editor allows you to browse all the database objects and its main properties.

There is possible to create, edit and drop database subitems.
Database Administration 77
To open the editor, use popup menu of the database node at the Explorer tree.
41
Subitems
Every tab is intended for managing corresponding database objects (e.g. tables, views, queries, etc.). Open the object in its editor by double-clicking or pressing the Enter key. The popup menu allows you to create new, edit or drop the selected database objects. Using this menu you can also create a copy of the object.
You can operate on several objects at a time. For this you have to select database objects with the Shift or the Ctrl key pressed. After the group of objects is selected,
© 2009 SQL Maestro Group
MySQL Maestro Help78
you can operate on it, e.g. delete several objects at once, as it was a single object.
The Properties tab displays available database parameters. Below you can find some of their descriptions.
Character set
Here it is represented the set of symbols and encodings using in the database.
Collation
The field contains the database collation name, the set of rules for comparing characters in a character set.
© 2009 SQL Maestro Group

3.3 Creating Database Profiles

Create Database Profiles Wizard allows you to create a single database profile or several
profiles from one host. To run the wizard, select the Database | Create Database
Profiles... main menu item, or press the Shift+Ctrl+P hot keys combination. You can also
use the Create Database Profiles button of the main toolbar.
Database Administration 79
· Setting database connection properties
· Selecting databases to register
· Setting database profile options
82
83
See also: Edit Database Profile Dialog
79
86

3.3.1 Setting connection properties

The first wizard step allows you to specify the database connection properties that will be used on further connections.
MySQL Maestro allows you to connect to MySQL servers directly, via Secure SHell (SSH) tunnel or HTTP tunnel.
· Direct connection is the most preferable connection mode.
© 2009 SQL Maestro Group
MySQL Maestro Help80
· If your MySQL server does not allow direct connections from remote workstations, you
can establish connection to intermediate SSH server and forward all MySQL commands through the Secure SHell (SSH) tunnel.
· HTTP tunneling is a technique used in conditions of restricted network connectivity
including firewalled networks, networks behind proxy servers, and NATs. It is the slowest way and is recommended to use if the others are impossible.
Irrespectively of a connection mode you should specify common credentials as follows:
Host
The host name of the MySQL server.
Port number
The TCP/IP port to use if server is not localhost.
User name
The username used to connect to MySQL.
Password
The password for the user account on server.
© 2009 SQL Maestro Group
SSH tunnel connection
To establish connection to intermediate SSH server and forward all MySQL commands through the secure tunnel, you need to:
1. Check I can connect to the server directly or via SSH tunneling.
2. Use Configure SSH options to open the SSH Options window.
3.Check Connect through the Secure Shell (SSH) tunnel and specify the following SSH connection properties.
Host name
Specify the host name or IP of your site.
Port number
Set the SSH server port number.
Enter valid User name and Password to log in to the remote server.
Note: MySQL host name always should be set relatively to the
SSH server. For example, if both of MySQL and SSH servers are located on the same computer, you should specify localhost as Host name instead of server's external host name or IP address.
Database Administration 81
HTTP tunnel connection
© 2009 SQL Maestro Group
MySQL Maestro Help82
To connect to a remote server using a PHP script, you need to:
1.Upload the connection PHP script to your website. The script is named mysql_tunnel.
php and can be found under the installation folder, usually C:\Program Files\SQL Maestro Group\MySQL Maestro.
2.Select the I have to use HTTP tunneling radio button.
3.Enter the connection PHP script URL, e.g. www.yoursite.com/files/mysql_tunnel.php. You can test the connection before the profile is created. Just use Test script using
default browser to open connection script in your browser, enter all the required
connection parameters and use the Test connection button.
4.In case using of a proxy server use Configure tunnelling options to open the HTTP
tunnelling options window and specify your proxy server connection parameters and HTTP authentication.
Note: You are actually connecting to your database through the PHP script on the server, so in most cases the host/server name is "localhost" unless the target server is not installed on the same server as the Web server.
Check the Create a single profile option to set the database name manually and
create a single profile for this database.
Hide already registered databases
Check the box to shorten the databases list on the next wizard step.

3.3.2 Selecting databases

The second wizard step allows you to select databases to register. Select the
databases to be registered by moving them from the Available databases list to the
© 2009 SQL Maestro Group
Selected databases list.
Database Administration 83

3.3.3 Setting profile options

Use the next wizard step to set the database alias and other profile options (the detailed description is given below). You can select several databases to set options for all the selected databases at once (except the alias which should be unique for each individual database). Click the Ready button when done to start working with the selected databases in MySQL Maestro.
© 2009 SQL Maestro Group
MySQL Maestro Help84
Login prompt before connection Use the option to enable MySQL Maestro to prompt for user name and password every time you connect to the database.
Keep connection alive Check the box for pinging server before each query execution.
Show system objects Check the box to make system objects visible.
Connect automatically at startup With this option on connection to the profile database is automatically established at the application startup.
New object's names (Don't change case, Convert to upper case, Convert to lower case)
The option allows you to specify the newly created objects case.
Default table engine (MyISAM, InnoDB)
Use the drop-down list to specify the storage engine to be the default engine for the database tables. MyISAM manages non-transactional tables. It provides high-speed storage and retrieval, as well as fulltext searching capabilities.
© 2009 SQL Maestro Group
Database Administration 85
The InnoDB storage engine provides transaction-safe tables.
© 2009 SQL Maestro Group
MySQL Maestro Help86

3.4 Editing Database Profile

Use the Edit Database Profile dialog to edit the profile properties set on its creation. To open the dialog, select the database in the explorer tree, then select the Database |
Edit Database Profile... main menu item or press the Shift+Ctrl+E hot key combination.
You can also use the Edit Database Profile button of the main toolbar.
· Editing database connection properties
· Settings database options
89
· Setting default directories for database tools
· Editing obligatory scripts to execute
· Setting log options and file names
See also: Create Database Profile Wizard
91
94
79
86
90

3.4.1 Editing connection properties

The tab allows you to change connection properties of an existing database profile. Here you can change the database and edit the database alias, an optional name to display the database in the Explorer tree and in all the application tools.
MySQL Maestro allows you to connect to MySQL servers directly, via Secure SHell (SSH) tunnel or HTTP tunnel.
© 2009 SQL Maestro Group
Database Administration 87
· Direct connection is the most preferable connection mode.
· If your MySQL server does not allow direct connections from remote workstations, you
can establish connection to intermediate SSH server and forward all MySQL commands
through the Secure SHell (SSH) tunnel.
· HTTP tunneling is a technique used in conditions of restricted network connectivity
including firewalled networks, networks behind proxy servers, and NATs. It is the
slowest way and is recommended to use if the others are impossible.
Irrespectively of a connection mode you should specify common credentials as follows:
Host
The host name of the MySQL server.
Port number
The TCP/IP port to use if server is not localhost.
User name
The username used to connect to MySQL.
Password
The password for the user account on server.
SSH tunnel connection
© 2009 SQL Maestro Group
MySQL Maestro Help88
To establish connection to intermediate SSH server and forward all MySQL commands through the secure tunnel, you need to:
1. Check I can connect to the server directly or via SSH tunneling.
2. Use Configure SSH options to open the SSH Options window.
3.Check Connect through the Secure Shell (SSH) tunnel and specify the following SSH connection properties.
Host name
Specify the host name or IP of your site.
Port number
Set the SSH server port number.
Enter valid User name and Password to log in to the remote server.
Note: MySQL host name always should be set relatively to the
SSH server. For example, if both of MySQL and SSH servers are located on the same computer, you should specify localhost as Host name instead of server's external host name or IP address.
To connect to a remote server using a PHP script, you need to:
HTTP tunnel connection
© 2009 SQL Maestro Group
Database Administration 89
1.Upload the connection PHP script to your website. The script is named mysql_tunnel. php and can be found under the installation folder, usually C:\Program Files\SQL Maestro Group\MySQL Maestro.
2.Select the I have to use HTTP tunneling radio button.
3.Enter the connection PHP script URL, e.g. www.yoursite.com/files/mysql_tunnel.php. You can test the connection before the profile is created. Just use Test script using
default browser to open connection script in your browser, enter all the required
connection parameters and use the Test connection button.
4.In case using of a proxy server use Configure tunnelling options to open the HTTP
tunnelling options window and specify your proxy server connection parameters and HTTP authentication.
Note: You are actually connecting to your database through the PHP script on the server, so in most cases the host/server name is "localhost" unless the target server is not installed on the same server as the Web server.

3.4.2 Setting profile options

Customize database options according to your needs. The detailed description is given below.
© 2009 SQL Maestro Group
MySQL Maestro Help90
Login prompt before connection Use the option to enable MySQL Maestro to prompt for user name and password every time you connect to the database.
Keep connection alive Check the box for pinging server before each query execution.
Connect automatically at startup With this option on connection to the profile database is automatically established at the application startup.
Show system objects
Check the option to make system objects visible.
Default table engine (MyISAM, InnoDB)
Use the drop-down list to edit the storage engine to be the default engine for the current database tables. MyISAM manages non-transactional tables. It provides high-speed storage and retrieval, as well as fulltext searching capabilities. The InnoDB storage engine provides transaction-safe tables.

3.4.3 Setting default directories

Use the tab to specify the default directories respectively for database extract, data export, data import, table backup/restore and data dump.
© 2009 SQL Maestro Group
Database Administration 91

3.4.4 Editing obligatory scripts to execute

Use the tab to specify the obligatory scripts to execute after MySQL Maestro will connect to the database or before disconnect from the database. You can also enable/ disable a written script.
© 2009 SQL Maestro Group
MySQL Maestro Help92
Below you can find an example of an obligatory script to execute after MySQL Maestro will connect to the database. The script writes a connect time to the log table.
© 2009 SQL Maestro Group
Loading...
Buy Points How it Works FAQ Contact Us Questions and Suggestions Privacy Policy Cookie Policy Terms of Use