Toad for MySQL - General

Community Discussion

Dron
Follow / 15 Oct 2014 at 2:24pm / Toad for MySQL
Latest post by on 15 Oct 2014 at 5:37pm

How can I move tab toolbars above the tabs?

Expand content
I have upgraded from 7.2 to 7.3 and was very disappointed with unrevertable UI changes. I've spent about 1 hour trying to make new version look like 7.2 version, recovering my old skin, placing windows...

I have upgraded from 7.2 to 7.3 and was very disappointed with unrevertable UI changes. I've spent about 1 hour trying to make new version look like 7.2 version, recovering my old skin, placing windows in convenient layout etc. I am still unable to place tab toolbars above the tabs. I need only edit toolbar which has "format SQL" button. Having this toolbar below the tabs makes it hard to switch tabs - you need to find it between 2 rows of buttons.

One more thing which is hard to understand for me. How can I see at once database object tabs (with tables for example) from 2 different connections? When I open new Database Explorer it is opened with the tree of all objects at the left side so I have 2 trees at once. Also is I switch between SQL Editor tab from 2 different connections my DB Explorer tab is changed and I cannot. That is so confusing.

Other wishes about DB Explorer window: add refresh button to the toolbar and make is customazable, allow removing filter which just eats space, do not show "+" if there are no items in the list.

In Connection Manager allow removing toolbar - there are no useful buttons as for me. You rarely  need to add new connections but switching between them is oftern operation. Switching is 

Unanswered 58 1 / Create an account to join the discussion.
hugovzky
Follow / 3 Sep 2012 at 6:13am / Toad for MySQL
Latest post by on 14 Oct 2014 at 7:19pm

System.OutOfMemoryException thrown when running big queries

Expand content
Hi, When I run some big queries (>20MB sql script) Toad throws an out of memory error message. System.OutOfMemoryException Exception of type 'System.OutOfMemoryException' was thrown. Stack Trace...

Hi,

When I run some big queries (>20MB sql script) Toad throws an out of memory error message.

System.OutOfMemoryException
Exception of type 'System.OutOfMemoryException' was thrown.
Stack Trace:
at System.String.Replace(String oldValue, String newValue)
at ActiproSoftware.SyntaxEditor.Document.GetText(LineTerminator lineTerminator)
at ActiproSoftware.SyntaxEditor.SyntaxEditor.get_Text()
at Quest.Toad.Editor.EditorForm.CheckConnection()
at Quest.Toad.Editor.EditorForm.DoExecuteSqlScript()
at Quest.Toad.Editor.EditorForm.ExecuteSqlScript()

I'm using Toad for MySQL 6.3.0.642

Could anyone help me about this?

Thanks in advance

2101 6 / Create an account to join the discussion.
pstein
Follow / 8 Oct 2014 at 8:48pm / Toad for MySQL

How to backup and restore Toad settings to file?

Expand content
In previous version it was not possible to backup all current Toad settings into an external file. Is this long-awaited feature now possible in the new version 7.3? I want e.g. to restore these settings...


In previous version it was not possible to backup all current Toad settings into an external file.

Is this long-awaited feature now possible in the new version 7.3?

I want e.g. to restore these settings in another Toad installation on my notebook.

Peter

Unanswered 80 0 / Create an account to join the discussion.
pstein
Follow / 8 Oct 2014 at 5:49am / Toad for MySQL
Latest post by on 8 Oct 2014 at 7:10pm

Make windows border thin and toolbar icon smaller in v7.3?

Expand content
How can I make the window border smaller/thin and the toolbar icons smaller in the (new) version 7.3? Peter

How can I make the window border smaller/thin and the toolbar icons smaller in the (new) version 7.3?

Peter

Unanswered 129 2 / Create an account to join the discussion.
olivierdemeijer
Follow / 7 Oct 2014 at 8:20pm / Toad for MySQL

SSH tunnel Connection and mysql_clear_password.dll

Expand content
Hi Communiity, I set up a SSH tunnel connection following these steps , which works fine, except that TOAD complains about [ Authentication method 'mysql_clear_password' not supported by any...

Hi Communiity,

I set up a SSH tunnel connection following these steps, which works fine, except that TOAD complains about [Authentication method 'mysql_clear_password' not supported by any of the available plugins]

I fixed the very same problem with HeidiSQL by putting mysql_clean_password.dll and dialog.dll in a plugin folder, but I can't figure where to put those two dll's in TOAD in order to make it find them.

Can  anyone help ? Looks like most of the dll are somehow "declared"  in *.pck file if it can help.

Thank in advance !

107 0 / Create an account to join the discussion.
mike222
Follow / 8 Sep 2011 at 11:06pm / Toad for MySQL
Latest post by on 7 Oct 2014 at 3:27pm

Can anyone explain the rational behind toad's weird window behaviour

Expand content
Ok, I admit that its a valuable tool and pretty amazing for what is provided for free. But I'm at a loss trying to grok the twisted logic that seems behind the windowing behavior? Open Toad and double...

Ok, I admit that its a valuable tool and pretty amazing for what is provided for free.  But I'm at a loss trying to grok the twisted logic that seems behind the windowing behavior?
  
Open Toad and double click on a table in object explorer.  The table's data is displayed in a window (WIN1).

Single click on another table in object explorer.  That table's data replaces the previously selected tables data in WIN1.  ODD, WHY SHOULD IT BE ASSUMED THAT I WANT TO LOSE WHAT I PREVIOUSLY SELECTED?  ESPECIALLY IF I RIGHT CLICK ON THE NEW OBJECT EXPLORER SELECTION.

Alt-Z to open new window (WIN2) that contains a duplicate of the data in WIN1 so that clicking around in object explorer does not overwrite the data in WIN1 that I am interested in.  Double click in object explorer on another table and its data now overwrites WIN2.  MORE STEPS THAN PROBABLY NECESSARY AND NOT VERY INTUITIVE BUT OK, FINE.

With WIN2 selected double or single click on new table in object explorer and WTF data in WIN1 is overwritten again.  THAT ISN'T THE ONE THAT HAD FOCUS.

Is that any way to config Toad to work as follows?

Double click on table in object explorer opens new window only when there are no open non SQL script windows.  Otherwise, data overwrites the window tab THAT PRESENTLY HAS FOCUS.

Single click on table in object explorer DOES NOT change what is in active window.

If I have window tabs open on tables when I shutdown and if upon a restart Toad is unable to simply requery (F5) and refresh the data in those tabs, close them automatically.  What is the point of having a bunch of empty non functional tabs open?  Or, what is the magic to force them to reload the data?

755 2 / Create an account to join the discussion.
savoym
Follow / 3 Oct 2014 at 1:12pm / Toad for MySQL
Latest post by on 6 Oct 2014 at 1:32pm

Cannot connect to server after installing Toad 7.3

Expand content
For some reason I cannot to any of MySQL servers using Toad 7.3. I was using Toad 7.0 and I can still connect to all MySQL servers using 7.0 but I cannot using the new Toad 7.3. Any suggestions? I cannot...

For some reason I cannot to any of MySQL servers using Toad 7.3.  I was using Toad 7.0 and I can still connect to all MySQL servers using 7.0 but I cannot using the new Toad 7.3.

Any suggestions?  I cannot find an error log or file where I can get some more details.  The only error I'm getting is that I cannot make a connection.

Please help!  Thanks.

Answered 246 3 / Create an account to join the discussion.
deeturagit
Follow / 29 Sep 2014 at 11:34pm / Toad for MySQL
Latest post by on 3 Oct 2014 at 4:28am

Toad for MySQL 7.3 Tools menu missing

Expand content
I have just installed 7,3 and have no tools menu. I have checked under customization and there is no menu listed, there is a set of tools icons, shame I cannot use it to do imports of data from csv as...

I have just installed 7,3 and have no tools menu. I have checked under customization and there is no menu listed, there is a set of tools icons, shame I cannot use it to do imports of data from csv as 7.2 does. Is this one of the paid for features?? 

210 3 / Create an account to join the discussion.
njorger
Follow / 11 Sep 2012 at 8:14pm / Toad for MySQL
Latest post by on 2 Oct 2014 at 3:01pm

System.OutOfMemoryException thrown when running big queries

Expand content
I have re-posted this to try and get the answer posted for others who are still having this issue. System.OutOfMemoryException Exception of type 'System.OutOfMemoryException' was thrown. Stack...

I have re-posted this to try and get the answer posted for others who are still having this issue.

System.OutOfMemoryException
Exception of type 'System.OutOfMemoryException' was thrown.
Stack Trace:
at System.String.Replace(String oldValue, String newValue)
at ActiproSoftware.SyntaxEditor.Document.GetText(LineTerminator lineTerminator)
at ActiproSoftware.SyntaxEditor.SyntaxEditor.get_Text()
at Quest.Toad.Editor.EditorForm.CheckConnection()
at Quest.Toad.Editor.EditorForm.DoExecuteSqlScript()
at Quest.Toad.Editor.EditorForm.ExecuteSqlScript()

822 2 / Create an account to join the discussion.
dmikester1
Follow / 23 Sep 2014 at 5:44pm / Toad for MySQL
Latest post by on 24 Sep 2014 at 3:17pm

Please add option to ask to delete record!

Expand content
This is the third time now that I have deleted a record mistakenly by hitting my delete key and it updates the changes immediately without me hitting the checkmark. This is very frustrating. Something...

This is the third time now that I have deleted a record mistakenly by hitting my delete key and it updates the changes immediately without me hitting the checkmark.  This is very frustrating.  Something like deleting a record should ask "are you sure??"  Please add this into Toad.

Thanks

Mike

156 3 / Create an account to join the discussion.
Alex CanĂ¡rio
Follow / 13 May 2014 at 1:28am / Toad for MySQL
Latest post by on 24 Sep 2014 at 1:10pm

Quest.Licensing.LicenseException

Expand content
Hi Guys After installer the Toad for MySQL 7.2 show the error message bellow. Can anybody help-me? Thanks Alex Canario

Hi Guys

After installer the Toad for MySQL 7.2 show the error message bellow.

Can anybody help-me?


Thanks

Alex Canario

1072 19 / Create an account to join the discussion.
Steven Soto
Follow / 23 Sep 2014 at 3:12am / Toad for MySQL

Toad for MySQL 7.3 is released!

Expand content
The new stable version of Toad for MySQL 7.3 is now available for immediate download. Just head over to the download section and get it right now!

The new stable version of Toad for MySQL 7.3 is now available for immediate download.

Just head over to the download section and get it right now!

256 0 / Create an account to join the discussion.
soapergem
Follow / 22 Sep 2014 at 4:56pm / Toad for MySQL
Latest post by on 22 Sep 2014 at 5:09pm

Where do I buy a license for Toad for MySQL?

Expand content
And how much does it cost? I downloaded the Freeware version, but cannot for the life of me find where one can go to purchase the full version. Can anyone provide a link please?

And how much does it cost? I downloaded the Freeware version, but cannot for the life of me find where one can go to purchase the full version. Can anyone provide a link please?

207 2 / Create an account to join the discussion.
rlgh60
Follow / 18 Sep 2014 at 4:27pm / Toad for MySQL

Error with SELECT ... INTO ... FROM syntax.

Expand content
I have some sql that does a " SELECT col1 INTO @col_value FROM db1 ". It executes ok when running from the command line on the server. But running from the Editor tab in Toad for MySql version...

I have some sql that does a "SELECT col1 INTO @col_value FROM db1".   It executes ok when running from the command line on the server.  But running from the Editor tab in Toad for MySql version 7.2.0.2992, it fails with an error..  This command  worked in the previous version of Toad.

Even if I try to do a simple SELECT 1 INTO @VAR1; , it fails. with an error message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT
    1
INTO
    @VAR1' at line 1.

Any suggestions on how to solve this issue?

Unanswered 127 0 / Create an account to join the discussion.
flokocha
Follow / 17 Jan 2013 at 4:57pm / Toad for MySQL
Latest post by on 18 Sep 2014 at 10:35am

SSH using RSA keys

Expand content
Hello! I'm trying to set up a connection through a ssh tunnel requiring a pair of rsa keys. But I can't see any option in the connection settings to select the location of my private key. Is this...
Hello!

I'm trying to set up a connection through a ssh tunnel requiring a pair of rsa keys. But I can't see any option in the connection settings to select the location of my private key.

Is this kind of ssh connection impossible?

Thank you

Flo
1171 3 / Create an account to join the discussion.
kulasart
Follow / 13 Aug 2014 at 11:10am / Toad for MySQL
Latest post by on 10 Sep 2014 at 3:45pm

[ERROR] While trying to create group execute script

Expand content
I cant select multiple database schemas, from single server while creating Group Execute script. More than that - list with avalible schemas can not be created in Group Execute window. Exception: System...

I cant select multiple database schemas, from single server while creating Group Execute script.

More than that - list with avalible schemas can not be created in Group Execute window.

Exception: System.NullReferenceException
Message  : Object reference not set to an instance of an object.
Stack Trace:
    Quest.Toad.Grouping.GroupExecutionControl.AddTreeNode(TreeListNode parentTreeNode, ObjectTrl trl)
    Quest.Toad.Grouping.GroupExecutionControl.FetchDatabasesAndAdd(TreeListNode treeNodeParent, Connection conn)
    Quest.Toad.Grouping.GroupExecutionControl.PopulateDatabases(List`1 nodes)

 

Operating System
  Microsoft Windows 7 Professional  6.1.7601 AMD64
  Manufacturer: Microsoft Corporation

275 2 / Create an account to join the discussion.
hsheng
Follow / 2 Sep 2014 at 8:50pm / Toad for MySQL
Latest post by on 2 Sep 2014 at 11:03pm

How to setup Toad for MySQL (Freeware) to use more physical memory

Expand content
Hi, Is it possible to configure Toad for MySQL (Freeware) 7.2.0.2922 to use more than 4G physical memory? Thanks

Hi,

Is it possible to configure Toad for MySQL (Freeware) 7.2.0.2922 to use more than 4G physical memory?

Thanks

Unanswered 178 1 / Create an account to join the discussion.
Rrralec
Follow / 29 Aug 2014 at 2:32pm / Toad for MySQL

Trouble connecting locally...

Expand content
Hello, I have been trying to connect to my own computer to simply learn and write queries for, at the moment, simple data sets in CSV format. My issue: regardless of which SQL program I use, be it mySql...

Hello, 

I have been trying to connect to my own computer to simply learn and write queries for, at the moment, simple data sets in CSV format. 

My issue: regardless of which SQL program I use, be it mySql WorkBench, HeidiSQL, SQLyog, Toad for MySQL, I cannot connect locally. 

I use the standard 

127.0.0.1

localhost

root

port 3306 

setttings and to no avail. 

I have created an exception in my Windows Firewall for port 3306, 

I cannot find Toad in the list of Services. 

I have tried every combination of the above settings in fields Host, Username, Password.

Is there anything I am missing? I'm almost beginning to think I misunderstand entirely what it means to connect locally... I have not set up a server, or have any previous database ready. 

A colleague of mine uses SequelPro on her Mac and simply imports CSV files to query them. 

Also, I have now attempted to connect locally using an SQL program using both of my computers... making it feel as if there really is something wrong with the way I'm attempting to connect. 

If anyone would be able to help, it would be much appreciated. I have never hit a roadblock so early in my attempts to learning a computer software, I am barely making it past the installation... 

Thank you. 

Alec

200 0 / Create an account to join the discussion.
Henrik Johnson
Follow / 14 Apr 2014 at 8:20pm / Toad for MySQL
Latest post by on 28 Aug 2014 at 7:49pm

Toad for MySQL 7.2 is released!

Expand content
The new stable version of Toad for MySQL 7.2 is now available for immediate download. Just head over to the download section and get it right now!

The new stable version of Toad for MySQL 7.2 is now available for immediate download.

Just head over to the download section and get it right now!

2050 9 / Create an account to join the discussion.
pstein
Follow / 24 Feb 2011 at 3:54pm / Toad for MySQL
Latest post by on 28 Aug 2014 at 3:39pm

How to change password for database aaa and user uuu?

Expand content
How can I change the password for (existing) database aaa and existing user uuu? is it only possible through cmdline or through Toad GUI as well? Peter
How can I change the password for (existing) database aaa and existing user uuu?

is it only possible through cmdline or through Toad GUI as well?

Peter
3210 2 / Create an account to join the discussion.