Toad for MySQL - General

Community Discussion

steve2k
Follow / 24 Oct 2014 at 8:53am / Toad for MySQL
Latest post by on 24 Oct 2014 at 9:58am

Execute the statement my cursor is on

Expand content
Hello, In a previous version of toad I could just push F9 from the editor window to run the statement where my cursor was. For example - | shows where the cursor is. Select * from table1; Select...

Hello,

In a previous version of toad I could just push F9 from the editor window to run the statement where my cursor was. For example - | shows where the cursor is.

Select * from table1;

Select * from ta|ble 2;   <-- the cursor is here but the statement isn't highlighted.  Pushing F9 would execute this statement.

Select * from table 3;

My company have updated the version ro 10.1.1.8 and now if I try this it doesn't work - it only works if I highlight the statement.

Is there a setting or option I can set to make this work like it used to?  It's a pain having to highlight the whole statement when some are many lines long.

Thanks, Steve

16 1 / Create an account to join the discussion.
Jerzey Al
Follow / 19 Sep 2012 at 10:01pm / Toad for MySQL
Latest post by on 23 Oct 2014 at 8:28pm

Export db schema without data??

Expand content
Thought this would be a no brainer, but Toad for MySQL doesn't seem to handle it right. I'm using the Export Wizard hoping to create SQL statement output for the schema from a db on a remote server...
Thought this would be a no brainer, but Toad for MySQL doesn't seem to handle it right. I'm using the Export Wizard hoping to create SQL statement output for the schema from a db on a remote server. I want to recreate the schema on another server without the millions of records in the tables. I can't seem to make this happen without exporting all the table data too. In the Export Wizard, the last screen allows you to uncheck Export Data, but when you do, the Finish button disables. Is this a bug?? I'm able to uncheck Export Data and save it to a template file. If I pull in the template file, Export Data remains unchecked. But if I execute the template, all the table data is exported anyway, and it'll take a year or so for Toad to generate millions of INSERT statements. I'm using Toad for MySQL 6.3 freeware. Maybe the full version allows you to export just the schema SQL?
1479 1 / Create an account to join the discussion.
IPFox
Follow / 12 Feb 2014 at 10:35am / Toad for MySQL
Latest post by on 23 Oct 2014 at 5:44pm

Unable to connect Remote MySQL DB via Toad anymore

Expand content
Hi, THere has been some time since I last time connected to my few MySQL DBs via Toad, and today when I tried to connect I got the following error: System.Xml.XmlException '', hexadecimal...

Hi,

THere has been some time since I last time connected to my few MySQL DBs via Toad, and today when I tried to connect I got the following error:

System.Xml.XmlException
'', hexadecimal value 0x03, is an invalid character. Line 1, position 1.
Stack Trace:
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)
   at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Char[] data, Int32 length, Int32 invCharPos)
   at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()
   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
   at System.Xml.XmlTextReaderImpl.Read()
   at System.Xml.XmlTextReader.Read()
   at System.Xml.XmlReader.MoveToContent()
   at System.Data.DataSet.ReadXml(XmlReader reader, Boolean denyResolving)
   at System.Data.DataSet.ReadXml(String fileName)
   at Quest.PersistentCache.DataEngine.LoadDataSet()
   at Quest.PersistentCache.DataEngine.Contains(DimensionTypes dimensionType)
   at Quest.PersistentCache.PersistentCache.Contains(DimensionTypes type)
   at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.SetObjectNodeImage(TreeListNode node, ITrl trl)
   at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.SetNodeImage(TreeListNode node, ITrl trl)
   at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.CreateTypeNode(TreeListNode parentNode, String type)
   at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.CreateParentTypes(TreeListNode parentNode, String type)
   at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.updateContentTimer_Tick(Object sender, EventArgs e)
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

First I thought that as I had old Toad 6.xx, I firstly upgraded it to the newest but I still get the same error.

As host for Toad I have Win7 and MySQLs are running on CentOs, even though I think this is Windows issue.

All the other connection methods are working just fine (SQLYog, MysqlCLI)

ANy ideas?

273 2 / Create an account to join the discussion.
Roger Haragushiku
Follow / 23 Oct 2014 at 1:35am / Toad for MySQL

Script Editor not opening

Expand content
I'm not beeing able to open the script editor when creating a new View or editing an old one. On MySQL Workbench a similar problem occuried, but it was only a matter of chosing a default Scheme. On...

I'm not beeing able to open the script editor when creating a new View or editing an old one. On MySQL Workbench a similar problem occuried, but it was only a matter of chosing a default Scheme. On Toad, even chosing a default one, the screen still freezes when trying to open the editor. Does anyone know why it might happen or have seen a similar problem? 64bits / 32bits problem maybe?

Specs

Windows 8.1 Pro 64bits

8gb RAM

i7 2.2GHz CPU

MySQL Server v5.6.21 X64

Connector/ODBC v5.3.4 X86 and X64

Toad for MySQL Freeware v7.3.0.3250 and v7.3.0.3241 Beta (both didn't work, not even running as administrator)

Unanswered 19 0 / Create an account to join the discussion.
alexander.sitte
Follow / 22 Oct 2014 at 3:00pm / Toad for MySQL

[Bug] Autocomplete disappearing instantly (7.3 Stable)

Expand content
Hi, I have downloaded Taod for MySQL 7.3 and have a problem with the Autocomplete feature. 1. It does not pop up automatically. For example, when I type a table alias followed by a period(.) I would...

Hi,

I have downloaded Taod for MySQL 7.3 and have a problem with the Autocomplete feature.

1. It does not pop up automatically. For example, when I type a table  alias followed by a period(.) I would expect that autocomplete shows a list of columns of the table.

2. If I activate the autocomplete popup with CTRL+Period it pops up quickly and disappears right away. I am not able to select anything from it.

Is there a fix for this?

Unanswered 14 0 / Create an account to join the discussion.
pablo.boswell
Follow / 21 Oct 2014 at 9:50pm / Toad for MySQL

HOW THE HELL DO I CREATE A COMPOSITE KEY!?!?!?!?!?!

Expand content
All documentation online is for Toad for DB2 and the menus they talk about are nonexistent in Toad for MYSQL. Why is the most basic command so obtuse to perform? PLEASE HELP!!!!!!!

All documentation online is for Toad for DB2 and the menus they talk about are nonexistent in Toad for MYSQL. Why is the most basic command so obtuse to perform?

PLEASE HELP!!!!!!!

27 0 / Create an account to join the discussion.
savoym
Follow / 20 Oct 2014 at 5:49pm / Toad for MySQL
Latest post by on 20 Oct 2014 at 11:35pm

How to terminate a query that is displayed in Session Monitor

Expand content
I had 2 queries in the editor window. I cancelled it 2X as I had the wrong info in my query. I stopped the background process and thought I was terminating the query. I went into the Session Monitor and...

I had 2 queries in the editor window.  I cancelled it 2X as I had the wrong info in my query.  I stopped the background process and thought I was terminating the query.  I went into the Session Monitor and see those 2 queries in the Query status under the Activity column.  My question is, are these 2 queries still running as they are NOT in sleep mode?  If they are how can I terminate them?

Thanks.

56 4 / Create an account to join the 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 77 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

2160 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 86 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 140 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 !

120 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?

786 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 268 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?? 

226 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()

836 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

171 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

1093 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!

278 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?

221 2 / Create an account to join the discussion.