Toad® for MySQL

Version 4.1.0 (Click here for previous versions)

Release Notes

November 16, 2008


Contents

Welcome to Toad for MySQL

New in this Release

Resolved Issues and Enhancements

Known Issues

Third Party Known Issues

Upgrade and Compatibility

System Requirements

Global Operations
 

Installation

For More Information


Welcome to Toad for MySQL

Toad for MySQL is a database development and administration solution that provides productivity features for rapidly creating and executing queries, automating database object management, developing SQL code, and instant access to MySQL expertise.

Developers and administrators have access to a community of users, peers, and experts to help solve development and administration issues and assist in developing applications and feedback for improving Quests products.

All of this comes with the backing of Quest Software, a healthy and growing corporate entity that can provide the necessary training, support, and superior customer service demanded by IT management.
 


New in This Release

Review the following sections for updates in this release and new features:

General

Upgrades:

If you migrate settings during an upgrade, Toad only migrates shared reports and project manager files if you are using the default directory in the Network Settings option page (Tools | Options | Environment | Network Share). If you specified a custom network share directory, the files will not be migrated.

Performance Improvements:

Options:

Database Administration

 

Query Development

Query Builder:

You can determine the connection used by a query by placing the cursor over the Query Builder tab.


 

Editor:

The Document Recovery feature is now supported when running multiple instances of Toad.
 

Data Management

Automation

 


Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of the Toad for MySQL.

 Feature

 Resolved Issue

 Defect

Connections

 

Toad now supports connections using:

  • HTTP tunneling

  • SSH tunneling

ST#41619

ST#53982

Export Wizard/ One Click Export

All data export formats now support International characters.

ST#49830

Import Wizard

You can now import data that contains International characters from Excel.

ST#49831

You can now import large data sets from Excel (approximately 650,000 rows) without experiencing performance issues.

ST#42321

CR#219754

Object Explorer/ Database Explorer

Selecting a non-primary key index from the object list now displays details in the tabs on the right side.

ST#54904

You can now view details in the right side of the Database Explorer for indexes that do not have a primary key.

ST#54904

You can now apply or remove a named database or object filter by selecting a drop-down arrow beside the filter icon.

ST#42900

CR#228419

You no longer set the default object list display format (Tabbed, Tree view, or Drop-down) from the Options window. Instead, you now set the default from the drop-down list in the Object Explorer toolbar (far right of the object toolbar) and it is saved for future sessions.

ST#45363

Query Builder

The following issues have been fixed for reverse engineering SQL from the Query tab or the Editor:

  • An Inner Join is no longer changed to a Cross Join when reverse engineering a query.

  • The Diagram tab correctly models a Group by clause on a calculated column.

ST#52569

ST#48258


Known Issues

The following is a list of issues known to exist at the time of the Toad for MySQL release.

Feature

Known Issue

Defect

Installation/ Upgrades

Customized options selected in the Configuration wizard are not applied if you are running Toad as a Restricted user.

Workaround:
Customize these settings using the Options pages in Toad (Tools | Options).

CR#216699

Startup

(Windows Vista on Toad client only) If you initially start Toad when logged in as a standard user and enter a license key, the license key should be saved to:

    C:\Program Files\Quest Software\Toad for SQL Server 4.1

However, a standard user does not have write privileges in Vista to C:\Program Files so the key is saved to the following directory instead:

    C:\Users\username\AppData\Local\VirtualStore\Program Files\Quest
    Software\Toad for SQL Server 4.1

If you later start Toad as an administrator, you are prompted to enter the key again because it is not in the C:\Program Files directory.

N/A

Data Reports

Currently, you cannot create a Label Report in the Toad Data Report wizard.

CR#215945

Debugger

If you use a GET_LOCK command in a script you are debugging, you cannot debug the methods.

N/A

Editor

When using the View Object at Cursor (F4) feature, triggers are not found.

CR#164917

(MySQL 4.1 only) Attempting to execute a "show innodb status" statement results in a "Net packets out of order" error message.

CR#193385

Export Wizard/ One Click Export

Binary data types cannot be exported in this release.

CR#170430

When exporting large results sets (approximately 500K), you may run out of memory before the operation completes.

Workaround:
Create a view for the query and export using that view.

CR#203483

Import Wizard

 

Currently, you cannot import Excel 2007 files because they are saved using an xlsx format.

Workaround:
Save the Excel 2007 file as a 2003 compatible file before importing it.

CR#221667

Object Explorer/ Database Explorer

(MySQL 4.1 only) Currently, you cannot filter databases or objects.

ST#46945

Currently, BIGINT data types are not supported in the Data tab.

ST#54328

Query Builder

When reverse engineering a query from the Query tab or the Editor, the Diagram tab does not support a SELECT statement where the columns are qualified with the database name.

Workaround:
When you visualize the query to display in the Diagram tab, Toad automatically creates calculated columns for the columns qualified with a database name. This allows you to execute the query and return the correct result set.

For a complete list of considerations and limitations, see Reverse Engineer Queries in the help.

ST#49731

 

 


Third Party Known Issues

The following is a list of third party issues known to exist at the time of Toad for MySQL release.

Feature

Known Issue

Defect

Data Grid

Currently, Korean characters are not supported.

CR#160929

Currently, if the value of a TIME data type is greater than 24-hours, the value does not display correctly.
 

N/A

Export Data

In order to export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from one of the following locations:  

2003 PIAs

http://www.microsoft.com/downloads/details.aspx?FamilyID=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&DisplayLang=en
 

2007 PIAs

http://www.microsoft.com/downloads/details.aspx?familyid=59DAEBAA-BED4-4282-A28C-B864D8BFA513&displaylang=en

CR#138239

Output

Currently, Korean characters are not supported.

CR#160929

 


Upgrade and Compatibility

For information about upgrading, see the Installation Guide available from the Windows Start menu under Program Files | Quest Software | Toad for MySQL Freeware 4.1 | Documentation.
 


System Requirements

Client Requirements

Before installing Toad for MySQL, ensure your client system meets the following minimum hardware and software requirements:

Platform

1 GHz recommended

Memory

512 MB of RAM minimum, 1 GB recommended


Note: The memory required may vary based on the following:

  • Applications that are running on your system when using Toad
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database
Hard Disk Space 51 MB of disk space for installation
Operating System

Windows® 2000

Note: The Automation feature requires the .NET Framework 3.0 or later, which is not supported on Windows 2000.

Windows 2003

Windows XP Professional (32-bit or x64)

Windows Vista (32-bit or x64)

Additional Software

.NET Framework
Microsoft .NET Framework 2.0 or later

Notes: Consider the following:

  • To run Toad, the .NET security policy must be set to unrestricted. For more information, see User Privilege Requirements.
  • To use the Automation feature, the .NET Framework 3.0 or later must be installed.

Web Browser
Microsoft Internet Explorer 6.0 or later


PDF Viewer

Adobe® Acrobat® Reader 7.0 or later (for viewing the Toad for MySQL Installation Guide)

Server Requirements

Before installing Toad for MySQL, ensure your server meets the following minimum hardware and software requirements:

Tested Database Operating Systems

Windows® 2000 with SP4

Windows 2003

Windows XP Professional

Tested Databases

MySQL 4.1.22

MySQL 5.0.41

Citrix Requirements

Toad has been tested for Citrix support on Windows Server 2003 Enterprise Server SP2 using the MetaFrame Presentation Server 4.0 and Citrix Presentation Server Clients 10.2. For information about installing Toad in a Citrix environment, see Install Toad on Citrix Systems in the Toad for MySQL Installation Guide.

User Privilege Requirements

The following user privileges are required for installing and running Toad for MySQL:

  1. From the Windows Start menu, select Settings | Control Panel.

  2. Double-click Administrative Tools.
  3. Double-click Microsoft .NET Framework 2.0 Configuration.
  4. Click + to expand My Computer, and then select the Runtime Security Policy node. A list of tasks for the node display in the right panel.
  5. Click Evaluate Assembly from the list of tasks in the right panel. An Evaluate an Assembly window displays.
  6. Browse to the location of Toad.exe in the File field.
  7. Click Next to view permissions for Toad.exe.
  8. Set the permission to Unrestricted.

Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release is Unicode-enabled and supports any character set. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America,
Western Europe and Latin America, Far-East Asia, Japan.

The following limitation has been identified:


Installation

Contents of the Release Package

The Toad for MySQL release package contains the following products:

Installation Instructions

For important installation information, see the Installation Guide available
from the Windows Start menu under Program Files | Quest Software | Toad for MySQL Freeware 4.1 | Documentation.
 


For More Information

Contact Quest Software:

Email info@quest.com
Mail Quest Software, Inc.
World Headquarters
5 Polaris Way
Aliso Viejo, CA 92656
USA
Web

http://www.quest.com

Refer to our web site for regional and international office information.
 


© 2008 Quest Software, Inc.

ALL RIGHTS RESERVED.

 

This document contains proprietary information protected by copyright. The software described in this document is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.

 

If you have any questions regarding your potential use of this material, contact:

Quest Software World Headquarters
LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656

 

Web site: www.quest.com

Email: legal@quest.com

Refer to our web site for regional and international office information.

 

Trademarks

Quest, Quest Software, the Quest Software logo, Benchmark Factory, DataFactory, DeployDirector, ERDisk, Foglight, Funnel Web, GPOAdmin, I/Watch, Imceda, InLook, IntelliProfile, InTrust, Invertus, IT Dad, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, MessageStats, NBSpool, NetBase, Npulse, NetPro, PassGo, PerformaSure, Quest Central, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Tag and Follow, Toad, T.O.A.D., Toad World, vAnalyzer, vAutomator, vControl, vConverter, vEssentials, vFoglight, vMigrator, vOptimizer Pro, vPackager, vRanger, vRanger Pro, vReplicator, vSpotlight, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vEssentials, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

 

Disclaimer

The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.