Toad for MySQL - General

Community Discussion

imal
Follow / 21 Nov 2014 at 8:56pm / Toad for MySQL

Shortcut for 'Edit SQL' or File>New>Editor menu command...

Expand content
Can someone explain to me how i can open a new Script editor via a keyboard shortcut? This is driving me insane. I tried to set my own shortcut using Tools>Options>Keyboard but 'New Script'...

Can someone explain to me how i can open a new Script editor via a keyboard shortcut? This is driving me insane. I tried to set my own shortcut using Tools>Options>Keyboard but 'New Script' command is not listed there. Hopefully i am missing something? 

Toad for MySQL version: 7.3.0.3250

Thanks!

23 0 / Create an account to join the discussion.
swapnil123
Follow / 21 Nov 2014 at 10:51am / Toad for MySQL

Unable to connect remote MySQL database.

Expand content
I am Unable to connect Remote MySQL database using " Toad for MySQL ,Version 7.2.0.2922 ". Server is listening on port 3306.I can access the same database remotely through MySQL Workbench 6...

I am Unable to connect Remote MySQL database using " Toad for MySQL ,Version 7.2.0.2922 ".

Server is listening on port 3306.I can access the same  database remotely through MySQL Workbench 6.1 but can't access through Toad.

Also firewall is not blocking access to server.

I have attached error screen and telnet response on port 3306.Please help me to resolve problem.

                 

27 0 / Create an account to join the discussion.
SQL_Jockey
Follow / 15 Nov 2012 at 11:00pm / Toad for MySQL
Latest post by on 19 Nov 2014 at 11:17pm

Unresponsive TOAD for MySQL

Expand content
Is it just me??? Whenever I leave my Toad for MySQL open on my desktop for a long time it becomes somewhat non-responsive. "A long time" is roughly 1 hour, but I'm not sure exactly. "somewhat...

Is it just me???


Whenever I leave my Toad for MySQL open on my desktop for a long time it becomes somewhat non-responsive.


"A long time" is roughly 1 hour, but I'm not sure exactly.


"somewhat non-responsive" means that I can type in the editor, click on menus/toolbars, but when I try to execute a query the program does not respond.


My work around is to use Windows Task Manager and end task the TOAD application.


I do this several times a day.


Any ideas, help, and/or workarounds would be appreciated.


I really enjoy using this product, but I'm really getting tired of using task manager.


Thanks!

1748 18 / Create an account to join the discussion.
armzak6
Follow / 11 Nov 2014 at 1:05pm / Toad for MySQL
Latest post by on 18 Nov 2014 at 11:52pm

Connection error question

Expand content
Just downloaded Toad for Mysql when I try to connect I get the following error: "Unable to connect to any of the specified MySQL hosts." release notes say you have to download Toad 7.0 to...

Just downloaded Toad for Mysql when I try to connect I get the following error:

"Unable to connect to any of the specified MySQL hosts."

release notes say you have to download Toad 7.0 to correct this error. Only Toad 7.3 is available for download, how do you find Toad for Mysql 7.0 for download??

224 11 / Create an account to join the discussion.
aquitta
Follow / 12 Nov 2014 at 9:00pm / Toad for MySQL
Latest post by on 12 Nov 2014 at 9:41pm

Toad for MySql to recognize my.ini ?

Expand content
You can probably guess from the question that I'm new to this environment, so please bear with me. I have my.ini including a reference to the windows authentication plugin, as below: [mysqld] plugin...

You can probably guess from the question that I'm new to this environment, so please bear with me.

I have my.ini including a reference to the windows authentication plugin, as below:

[mysqld]
plugin-load=authentication_windows.dll

I've rebooted both my desktop and the server.

I have this both on my Windows 8 client install and the Windows Server 2012 server install. When I connect to the server and list plugins via the command below:

select *
from information_schema.PLUGINS
where plugin_name like '%mysql%';

I do get that the plugin is there and installed:

PLUGIN_NAMEPLUGIN_VERSIONPLUGIN_STATUSPLUGIN_TYPEPLUGIN_TYPE_VERSION
mysql_native_password 1.0 ACTIVE AUTHENTICATION 1.0
mysql_old_password 1.0 ACTIVE AUTHENTICATION 1.0

.

.

but when I try to create a login (below), it tells me that the plugin is not installed.

CREATE USER cust_login
IDENTIFIED WITH authentication_windows
AS 'domain\\MyWindowsName';

Plugin 'authentication_windows' is not loaded

Is my connection to MySQL using the my.ini file? If not, how can I set that in TOAD?

Thanks

Andre

Unanswered 59 1 / Create an account to join the discussion.
alexander.sitte
Follow / 22 Oct 2014 at 3:00pm / Toad for MySQL
Latest post by on 12 Nov 2014 at 2:55pm

[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 103 1 / Create an account to join the discussion.
Henrik Johnson
Follow / 12 Nov 2014 at 1:23am / Toad for MySQL

Old Toad for MySQL installers

Expand content
For people who require old installers they are now available at. Toad for MySQL 6.0.1.1723 Toad for MySQL 6.3.0.642 Toad for MySQL 6.7.0.1524 Toad for MySQL 7.0.2038 Toad for MySQL 7.2.0.2922...

For people who require old installers they are now available at.

Toad for MySQL 6.0.1.1723

Toad for MySQL 6.3.0.642

Toad for MySQL 6.7.0.1524

Toad for MySQL 7.0.2038

Toad for MySQL 7.2.0.2922

Enjoy!

69 0 / Create an account to join the discussion.
Henrik Johnson
Follow / 29 Mar 2012 at 8:20pm / Toad for MySQL
Latest post by on 11 Nov 2014 at 8:54pm

Toad for MySQL 6.3 is released!

Expand content
The new version of Toad for MySQL 6.3 is now available for immediate download from www.toadformysql.com . Contains improved user interface for automation, query builder, editor and adds integration to...

The new version of Toad for MySQL 6.3 is now available for immediate download
from www.toadformysql.com .

Contains improved user interface for automation, query builder, editor and adds
integration to Sharepoint. Also features improvements in document recovery, Code
Completion, Code Snippets, Report Designer, Project Manager, FTP and
performance.

/Henrik Johnson

Quest Software

563 2 / Create an account to join the discussion.
Henrik Johnson
Follow / 14 Apr 2014 at 8:20pm / Toad for MySQL
Latest post by on 7 Nov 2014 at 11:28pm

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!

2617 13 / Create an account to join the discussion.
icefall
Follow / 6 Nov 2014 at 6:59am / Toad for MySQL

Toad for MySQL 7.3.0 Error after Changing a Value in Grid with select...

Expand content
Hello, i have the problem that, if i execute a statement with joins inside and try to change a value in the grid, i get an error like: You have an error in your SQL syntax; check the manual that corresponds...

Hello,


i have the problem that, if i execute a statement with joins inside and try to change a value in the grid, i get an error like:

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 'SET fk_Auftragsstatus = 21 WHERE (id = 5614440 OR (NULL = 1 AND id IS NULL))' at line 1


One Statement for example, but i get the error with any other select with join:

select Auftrag.* from Auftrag
inner join Auftragsposition B on Auftrag.id = B.fk_Auftrag and B.fk_Auftragsart = 1
inner join Auftragsposition A on Auftrag.id = A.fk_Auftrag and A.fk_Auftragsart = 2
where fk_Auftragsstatus = 33 and A.Storno = 0 and B.Storno = 0;

What its wrong? With Toad 6.0 there was not that Error.

Kind regards,


IceFaLL

Unanswered 80 0 / Create an account to join the discussion.
Roger Haragushiku
Follow / 23 Oct 2014 at 1:35am / Toad for MySQL
Latest post by on 1 Nov 2014 at 2:54am

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)

Answered 163 2 / Create an account to join the discussion.
jgi
Follow / 29 Oct 2014 at 9:01pm / Toad for MySQL

Keyboard shortcut to run select statement on table in object explorer

Expand content
Hi guys When browsing through tables / views in object explorer I often need to run select statement on a table to see the data. Only option I know is to make a right click -> generate SQL -> Select...

Hi guys

When browsing through tables / views in object explorer I often need to run select statement on a table to see the data. Only option I know is to make a right click -> generate SQL -> Select statement -> To editor and then click on run button. This is very inconvenient and time consuming. Is there any way to define a shortcut which would do all the steps at ones?


Thanks

Jaro

78 0 / Create an account to join the discussion.
zklas
Follow / 27 Oct 2014 at 7:16am / Toad for MySQL

Toad for MySql 7.3.0.3250 - Special characters problem

Expand content
Hi , First of all I'm just beginner so forgive me for asking stupid questions ... ;-) I'm using wampserver ( MySql 5.6.12) on windows XP and after installing a new Toad 7.3.0.3250 version noticed...

Hi ,

First of all I'm just beginner so forgive me for asking stupid questions ... ;-)

I'm using wampserver ( MySql 5.6.12) on windows XP and after installing a new Toad 7.3.0.3250 version noticed a problem in editor and grid view with special characters ...

For example sql "select 'žćčđšŽĆČĐŠ' from dual" returns 'žccdšŽCCЊ' ?!?
I tried to change editor character encoding from "windows default" to utf8, but the result is the same.

Simple "select on a table" returns correct values from database, but when I try to update table for example like "update table set column = "Č" database is updated with "C" values instead of "Č"?!? The same things happend when I update through the "Table/Data View" editor.

Thanks in advance
ZKlas

107 0 / Create an account to join the 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

109 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?
1615 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?

374 2 / 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!!!!!!!

89 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.

159 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 147 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

2443 6 / Create an account to join the discussion.