Toad World adds value to your Toad experience by providing free education and revealing new functionalities — along with
time-saving tricks and tips.
Visit the community »

Toad for MySQL

Automate MySQL Development Tasks

Toad® for MySQL is a freeware development tool that enables you to rapidly create and execute queries, automate database object management, and develop SQL code more efficiently. It provides utilities to compare, extract, and search for objects; manage projects; import/export data; and administer the database. Toad for MySQL dramatically increases productivity and provides access to an active user community.

Features

Version Control Integration — Lets you check in and check out code from within the editor to reduce the risk of errors.

Macro Record and Playback — Records and plays back keyboard commands.

Database Browser — Reorganizes and manages objects and object types.

Code Snippet Editor — Lets you create and alter code snippets for expand-and-collapse code blocks, speeding navigation.

Security Manager — Permits or restricts user access to specific Toad features for better system control.

SQL Editor — Helps you create, execute, modify, and save queries; view and edit data; and process DDL commands — all from an easy-to-use interface.

Fast, Multi-Tabbed Schema Browser — Displays and manages database objects graphically.

DB Extract, Compare-and-Search Utility — Lets you compare two MySQL databases, view the differences, and create the script to update the target.

Import/Export Utility — Facilitates data transfer across MySQL databases.

Sys Reqs

System Requirements

Client Requirements

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

Platform1 GHz minimum
Memory512 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

133 MB of RAM minimum, 1 GB recommended

Note: The disk space required may vary based on the edition of Toad selected for installation

Operating System

Windows Server 2003 (32-bit or 64-bit)

Windows XP Professional (32-bit or 64-bit)

Windows Vista (32-bit or 64-bit)

Windows Server 2008 (32-bit or 64-bit)

Windows Server 2008 R2 (64-bit)

Windows 7 (32-bit or 64-bit)

Important: Toad uses the Microsoft Distributed Transaction Coordinator (DTC) when opening a SQL file to get Full-Text Search status, but DTC is disabled by default on Windows Vista and Windows Server 2008. If you are using either operating system, ensure that Network DTC access is enabled on the Toad client. See http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx for more information about enabling DTC access.

.NET FrameworkMicrosoft .NET Framework 3.5 (Service Pack 1)
Note: The following conditions apply:
  • If you have the .NET Framework 4.0 installed, you must still install the .NET Framework 3.5 (Service Pack 1).
  • The .NET Framework Client Profile is not supported.
  • To run Toad, the .NET security policy must be set to unrestricted. For information about setting this policy, refer to User Privilege Requirements.
Additional Requirements

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, ensure that your server meets the following minimum hardware and software requirements:

Operating System

Windows 2000 Service Pack 4 or later

Windows 2003

Windows XP (32-bit or 64-bit)

Windows Vista (32-bit or 64-bit)

Windows Server 2000 Service Pack 4 or later

Windows 2000 Professional Edition Service Pack 4 or later

Windows XP (32-bit with Service Pack 2 or later and 64-bit)

Windows Server 2003 (32-bit or 64-bit) Service Pack 1 or later

Windows Vista (32-bit or 64-bit)

Windows Server 2008 (32-bit or 64-bit)

Windows Server 2008 R2 (64-bit)

Windows 7 (32-bit or 64-bit)

Database Server

MySQL 4.1, 5.0, 5.1

Sybase ASE 12.5, 15.0.2, 15.0.3, 15.5

Sybase IQ 15

Sybase SQL Anywhere 12

Cloud Database ServiceToad can manage Amazon RDS and any other cloud or service offering compatible with MySQL.

Virtualization Support

Application VirtualizationLimited testing has been performed for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2.
Note: Toad may work in virtualization environments other than the ones in which it was tested.

Language Supported:

  • US English