You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Toad for MySQL great and have the most points for this month!
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
Hi,When I run some big queries (>20MB sql script) Toad throws an out of memory error message. System.OutOfMemoryExceptionException 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 18.104.22.1682
Could anyone help me about this?
Thanks in advance
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.
How can I make the window border smaller/thin and the toolbar icons smaller in the (new) version 7.3?
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 !
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?
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.
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??
I have re-posted this to try and get the answer posted for others who are still having this issue.System.OutOfMemoryExceptionException 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()
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.
After installer the Toad for MySQL 7.2 show the error message bellow.
Can anybody help-me?
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!
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?
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 22.214.171.12492, 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 1INTO @VAR1' at line 1.
Any suggestions on how to solve this issue?
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.NullReferenceExceptionMessage : 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
Is it possible to configure Toad for MySQL (Freeware) 126.96.36.19922 to use more than 4G physical memory?
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
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...
The new stable version of Toad for MySQL 7.2 is now available for immediate download.