MySQL Maestro User's guide Copyright © 2002-2009 SQL Maestro Group I MySQL Maestro Help Table of Contents Foreword 0 I Welcome to MySQL Maestro! 1 Installation ................................................................................................................................... 2 Registration ................................................................................................................................... 3 License Agreement ................................................................................................................................... 4 System................................................................................................................................... Requirements 5 About SQL Maestro Group ................................................................................................................................... 6 What's new ................................................................................................................................... 7 Getting Started ................................................................................................................................... 1 3 4 5 7 8 16 33 Explaining user interface .......................................................................................................................................................... 34 Tabbed MDI .......................................................................................................................................................... 35 First time started .......................................................................................................................................................... 36 Working with .......................................................................................................................................................... 37 databases Switching between windows .......................................................................................................................................................... 39 II Basic principles of working with objects 1 Database Explorer ................................................................................................................................... 2 Wizards and Editors ................................................................................................................................... 40 41 45 Filtering explorer content .......................................................................................................................................................... 44 Create Object.......................................................................................................................................................... 45 Wizards Setting object name ......................................................................................................................................................... 46 Viewing commom information ......................................................................................................................................................... 46 Object Editors .......................................................................................................................................................... 47 Permissions of the Object ......................................................................................................................................................... 48 Object grants ......................................................................................................................................................... 49 SQL Definition ......................................................................................................................................................... 51 Parameter ......................................................................................................................................................... 52 Editor Executing ......................................................................................................................................................... 53 functions and procedures 3 Object................................................................................................................................... Manager 55 Using popup .......................................................................................................................................................... 56 menu Multiple selecting of objects .......................................................................................................................................................... 56 4 Object................................................................................................................................... Browser 58 Sorting database objects .......................................................................................................................................................... 59 Grouping database objects .......................................................................................................................................................... 60 Filtering database objects .......................................................................................................................................................... 60 5 Objects Duplicating ................................................................................................................................... 62 Duplicate Object Wizard .......................................................................................................................................................... 62 Selecting source and destination databases ......................................................................................................................................................... 62 Selecting object to duplicate ......................................................................................................................................................... 63 Modifying new object definition ......................................................................................................................................................... 64 Duplicate Selected Object .......................................................................................................................................................... 65 Copy, Paste and Drag-n-Drop features .......................................................................................................................................................... 66 6 Changing Object Properties ................................................................................................................................... 68 © 2009 SQL Maestro Group Contents 7 Describing Object ................................................................................................................................... II 69 III Database Administration 1 Create................................................................................................................................... Database Wizard 70 72 Setting connection properties .......................................................................................................................................................... 72 Specifying database properties .......................................................................................................................................................... 75 2 Database Editor ................................................................................................................................... 3 Creating Database Profiles ................................................................................................................................... 77 79 Setting connection properties .......................................................................................................................................................... 79 Selecting databases .......................................................................................................................................................... 82 Setting profile options .......................................................................................................................................................... 83 4 Editing Database Profile ................................................................................................................................... Editing Setting Setting Editing Setting 86 connection properties .......................................................................................................................................................... 86 profile options .......................................................................................................................................................... 89 default directories .......................................................................................................................................................... 90 obligatory scripts to execute .......................................................................................................................................................... 91 log options .......................................................................................................................................................... 94 IV Database Object Management 1 Database Object Creation ................................................................................................................................... 2 Tables ................................................................................................................................... 96 98 99 Create Table.......................................................................................................................................................... 100 Wizard Specifying table options ......................................................................................................................................................... 101 Adding table subitems ......................................................................................................................................................... 105 Table Editor .......................................................................................................................................................... 106 Editing table properties ......................................................................................................................................................... 107 Managing table data ......................................................................................................................................................... 111 Fields .......................................................................................................................................................... 113 Setting field parameters ......................................................................................................................................................... 115 Indexes .......................................................................................................................................................... 117 Index Editor ......................................................................................................................................................... 118 Foreign Keys .......................................................................................................................................................... 119 Setting reference options ......................................................................................................................................................... 120 Triggers .......................................................................................................................................................... 121 Create Trigger Wizard ......................................................................................................................................................... 123 Specifying trigger properties ......................................................................................................................................... 123 Specifying trigger definition ......................................................................................................................................... 124 Trigger Editor .................................................................................................................................................... ...