MySQL GUI Tools Manual

Copyright 2004-2008 MySQL AB, 2009 Sun Microsystems, Inc.

This documentation is NOT distributed under a GPL license. Use of this documentation is subject to the following terms: You may create a printed copy of this documentation solely for your own personal use. Conversion to other formats is allowed as long as the actual content is not altered or edited in any way. You shall not publish or distribute this documentation in any form or on any media, except if you distribute the documentation in a manner similar to how Sun disseminates it (that is, electronically for download on a Web site with the software) or on a CD-ROM or similar medium, provided however that the documentation is disseminated together with the software on the same medium. Any other use, such as any dissemination of printed copies or use of this documentation, in whole or in part, in another publication, requires the prior written consent from an authorized representative of Sun Microsystems, Inc. Sun Microsystems, Inc. and MySQL AB reserve any and all rights to this documentation not expressly granted above.

For more information on the terms of this license, for details on how the MySQL documentation is built and produced, or if you are interested in doing a translation, please contact the Documentation Team.

If you want help with using MySQL, please visit either the MySQL Forums or MySQL Mailing Lists where you can discuss your issues with other MySQL users.

For additional documentation on MySQL products, including translations of the documentation into other languages, and downloadable versions in variety of formats, including HTML, CHM, and PDF formats, see MySQL Documentation Library.

Abstract

This manual describes all the MySQL GUI Tools.

Document generated on: 2010-01-27 (revision: 18871)


Table of Contents

Preface
1. MySQL Enterprise
2. Installation
2.1. Introduction
2.2. Installing Under Windows
2.2.1. Using the Windows Installer
2.2.2. Installing From the ZIP File
2.3. Installing Under Linux
2.3.1. Installing the Generic Tarball
2.3.2. RPM Installation
2.4. Installing Under Mac OS X
3. Removing MySQL GUI Tools
3.1. Uninstall – Windows
3.2. Uninstall – Linux
3.3. Uninstall – Mac OS X
4. Upgrading MySQL GUI Tools
4.1. Upgrading – Windows
4.2. Upgrading – Linux
4.2.1. Tarball Upgrade
4.2.2. RPM Upgrade
4.3. Upgrading – Mac OS X
5. Running MySQL GUI Tools
5.1. Running Under Windows
5.2. Running Under Linux
5.3. Running On Mac OS X
I. MySQL Administrator
6. Introduction to MySQL Administrator
7. Connection Dialog
7.1. Advanced Options
7.2. Configure-service Mode
8. Main Window
8.1. Introduction
8.2. Sidebar
8.3. Working Area
8.4. Menus
8.4.1. File
8.4.2. Edit
8.4.3. View
8.4.4. Tools
8.4.5. Help
9. Server Information
10. Service Control
10.1. Introduction
10.2. Start/Stop Service
10.3. Configure Service
11. Startup Variables
11.1. Introduction
12. Server Connections
12.1. Introduction
12.2. Threads
12.3. User Connections
13. User Administration
13.1. Introduction
13.2. User Accounts
13.3. User Information
13.4. Global Privileges
13.5. Schema Privileges
13.6. Table Column Privileges
13.7. Resources
14. Health
14.1. Introduction
14.2. Connection Health
14.3. Memory Health
14.4. Creating Custom Health Graphs
14.5. Status Variables
14.6. System Variables
15. Server Logs
15.1. Introduction
15.2. Error Log
15.3. Slow Log
15.4. General Log
16. Backup
16.1. Introduction
16.2. Backup Project
16.3. Advanced Options
16.3.1. Backup Execution Method
16.3.2. Output File Options
16.4. Schedule
17. Restore
17.1. Introduction
17.2. The General Tab
17.3. Restore Content
18. Replication Status
18.1. Introduction
18.2. Configuring Replication Servers
18.3. Using the Replication Status Section
19. Catalogs
19.1. Introduction
19.2. Schema Tables
19.2.1. Table Status
19.2.2. Row Status
19.3. Schema Indexes
II. MySQL Query Browser
20. Introduction to the MySQL Query Browser
21. A Tour of the MySQL Query Browser
21.1. The Main Query Window
21.2. The Query Toolbar
21.2.1. The Navigation Buttons
21.2.2. The Query Area
21.2.3. The Action Buttons
21.3. The Advanced Toolbar
21.4. The Result Area
21.5. The Object Browser
21.5.1. The Database Browser
21.5.2. The Bookmark Browser
21.5.3. The History Browser
21.6. The Information Browser
21.6.1. The Syntax Browser
21.6.2. The Function browser
21.6.3. The Parameter Browser
21.6.4. The Transaction Browser
21.7. The Script Editor
21.7.1. The Script Debugging Buttons
21.7.2. The Script Area
22. Using The MySQL Query Browser
22.1. Entering and Editing Queries Manually
22.2. Building Queries
22.3. Creating Views
22.4. Navigating Result Sets Within the Result Area
22.5. Exporting Result Sets
22.6. Handling BLOB and TEXT Columns
22.7. Editing Result Sets Within the Result Area
22.8. Comparing Result Sets
22.9. Managing Stored Procedures and Functions with MySQL Query Browser
22.10. Editing Queries From a Development Tool
22.11. Using the Regex Text Importer Tool
III. Common Administrator and Query Browser Components
23. Options Dialog
23.1. Introduction
23.2. General Options
23.3. Connections
23.3.1. SSL Connections
23.4. Editors
23.5. The Browser Section
23.5.1. Display Options
23.5.2. Query Options
23.5.3. Various
23.6. Administrator
23.6.1. User Administration
23.6.2. Health Graphs
23.6.3. Backup
IV. Common Administrator and Query Browser Components
24. The MySQL Table Editor
24.1. Introduction
24.2. The Main Editor Window
24.3. The Columns And Indices Tab
24.3.1. The Column Editor
24.3.2. The Detail Area
24.4. The Table Options Tab
24.5. The Advanced Options Tab
24.5.1. The Various Section
24.5.2. The Row Options Section
24.5.3. The Storage Options Section
24.5.4. The Merge Table Options Section
24.5.5. The Table RAID Settings Section
24.6. Applying Your Changes
V. MySQL Migration Toolkit
25. Introduction to the MySQL Migration Toolkit
26. An Overview of the Migration Process
27. The Migration Process In-Depth
27.1. Introduction
27.2. The Welcome Screen
27.3. The Configuration Type Screen
27.4. The Source Database Screen
27.4.1. Microsoft Access
27.4.2. Microsoft SQL Server
27.4.3. Oracle
27.4.4. MySQL
27.4.5. Saving Connection Information
27.5. The Target Database Screen
27.6. The Connect to Server Screen
27.7. The Source Schema Selection Screen
27.8. The Reverse Engineering Screen
27.9. The Object Type Selection Screen
27.9.1. Migrating a Sub-Set of Object Types
27.10. The Object Mapping Screen
27.10.1. GRT Object
27.10.2. Table Objects
27.11. The Meta Migration Screen
27.12. The Manual Editing Screen
27.13. The Object Creation Options Screen
27.14. The Creating Objects Screen
27.15. The Data Mapping Options Screen
27.16. The Bulk Data Transfer Screen
27.17. The Summary Screen
27.18. Saving the Current Application State
28. Scripted Migration
28.1. The Steps for Scripted Migration
28.2. Setting the Source and Target Connection
28.3. Reverse Engineering
28.4. Migration Methods
28.5. Map Objects and Migrate
28.6. The SQL Create Statements
28.7. Bulk Data Transfer
29. Extending The MySQL Migration Toolkit
29.1. Introduction
29.2. Architecture of the MySQL Migration Toolkit
29.3. The Modular Migration Process
29.4. Tools Required to Extend the MySQL Migration Toolkit
30. Preparing a Microsoft Access Database for Migration
31. The Generic Runtime Environment (GRT) Shell
31.1. Introduction
31.2. Exploring the GRT Shell
31.2.1. Menu Items
31.2.2. The Shell
31.2.3. The Globals Tree Panel
31.3. Using the GRT Shell
31.4. Invoking the GRT Shell From the Command Line
VI. Appendixes
A. Installing From Source
A.1. Introduction
A.2. Downloading The Source Code
A.3. Building from Source under Windows
A.3.1. Prerequisites
A.3.2. Compiling and Building
A.4. Building from Source under Linux
A.4.1. Prerequisites
A.5. Compiling and Building
A.5.1. Building Static Binaries
A.5.2. Building RPMs
B. Troubleshooting Application Errors
B.1. Troubleshooting Connection Errors
B.2. Troubleshooting Display Problems
C. How Connections Are Stored
D. XML Files Common to the MySQL GUI Applications
E. XML Files Used by MySQL Query Browser
F. XML Files Used by MySQL Administrator
G. The MySQL System Tray Monitor
H. Third-party Software Used by the MySQL GUI Tools
H.1. PCRE Library
H.2. PNG Support
I. Notes for Translators

List of Figures

7.1. Connection Dialog
7.2. Switching to Configure-Service Mode
7.3. Configure-Service Mode
8.1. MySQL Administrator Main Window
8.2. Marked Area Between Sidebar and Working Area
13.1. User Accounts
13.2. User Information Tab
14.1. The Graph Settings Dialog
15.1. Displaying Entries from the Middle of the General Log
17.1. The Restore Content Tab
18.1. The Replication Status Section
21.1. The MySQL Query Browser Main Query Window
21.2. The Query Area Expanded to Ten Lines
21.3. The MySQL Query Browser Status Icons
21.4. The Advanced Toolbar
21.5. The Database Browser
21.6. The Script Editor
21.7. The File Open Dialog
22.1. The Table Tool
22.2. The BLOB Handling Icons
22.3. Stored Procedure in Database Browser
23.1. Options Dialog
23.2. Options Dialog: Connections
23.3. Options Dialog: Advanced Parameters
23.4. The Query Browser Options Dialog
24.1. The MySQL Table Editor
24.2. The Column Editor
24.3. The Index Editor
24.4. The Confirm Table Edit Dialog
26.1. The MySQL Migration Toolkit Migration Plan
27.1. The MySQL Migration Toolkit Welcome Screen
27.2. The Configuration Type Screen
27.3. Source Database – Microsoft Access
27.4. Source Database – Microsoft SQL Server
27.5. Source Database – Oracle
27.6. Oracle JDBC Driver Not Attached
27.7. Source Database – MySQL
27.8. Target Database – MySQL
27.9. The Connect to Servers Screen
27.10. The Source Schema Selection Screen
27.11. The Reverse Engineering Screen
27.12. The Object Type Selection Screen
27.13. The Detail View of the Object Type Selection Screen
27.14. The Add Ignore Pattern Dialog
27.15. The Object Mapping Screen
27.16. The Meta Migration Screen
27.17. The Manual Editing Screen
27.18. The Manual Editing Screen – Detailed View
27.19. The Object Creation Options Screen
27.20. The Creating Objects Screen
27.21. The Data Mapping Options Screen
27.22. The Bulk Data Transfer Screen
27.23. The Summary Screen
30.1. The Show Section
30.2. The System Objects
30.3. Granting Access to the System Objects
31.1. The GRT Shell (Windows)
B.1. Error Message Dialog
G.1. The MySQL System Tray Monitor

List of Tables

A.1. Required Components
A.2. Requirements for MySQL Query Browser