Toad for MySQL - General

Community Discussion

snolan_484
Follow / 9 Aug 2013 at 5:18pm / Toad for MySQL
Latest post by on 31 Mar 2015 at 6:51pm

Error Message prevents Toad from closing

Expand content
I get an error disconnecting from time to time and when the error occurs it prevents Toad from closing. Once that happens, the only way to close Toad is to go to the Windows Task Manager and end the process...

I get an error disconnecting from time to time and when the error occurs it prevents Toad from closing. Once that happens, the only way to close Toad is to go to the Windows Task Manager and end the process. The error message is as follows:

System.ArgumentNullException
Value cannot be null.
Stack Trace:
at System.Threading.Monitor.ReliableEnterTimeout(Object obj, Int32 timeout, Boolean& lockTaken)
at Quest.Toad.Debugger.DebugProviderBase.Cancel()
at Quest.Toad.Debugger.DebugProviderBase.Dispose(Boolean disp)
at Quest.Toad.Debugger.DebugProviderBase.Dispose()
at Quest.Toad.Debugger.DebugClient.CloseDebugging(Connection connection)
at Quest.Toad.Debugger.DebugClient.ConnectionClosingHandler(Object sender, ConnectionClosingEventArgs e)
at Quest.Toad.Notification.NotificationManager.InternalConnectionClosing(Object sender, ConnectionClosingEventArgs args)
at Quest.Toad.Notification.NotificationManager.ConnectionClosing(Object sender, Connection connection)
at Quest.Toad.Gui.MainForm.OnFormClosing(FormClosingEventArgs e)
at System.Windows.Forms.Form.WmClose(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at DevExpress.XtraEditors.XtraForm.WndProc(Message& msg)
at Quest.Toad.Gui.MainForm.WndProc(Message& msg)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Unanswered 3259 9 / Create an account to join the discussion.
Scott M. Sanders
Follow / 25 Feb 2015 at 6:47pm / Toad for MySQL
Latest post by on 20 Mar 2015 at 10:33pm

Uninstall Manually

Expand content
How do I uninstall if the entry is missing from Programs and Features? I found and carefully removed everything Toad from the Registry, it took some hours and worked, but I bet there’s an easier...

How do I uninstall if the entry is missing from Programs and Features?

I found and carefully removed everything Toad from the Registry, it took some hours and worked, but I bet there’s an easier way.

Unanswered 1461 1 / Create an account to join the discussion.
johannes.harlander
Follow / 11 Mar 2015 at 11:25am / Toad for MySQL
Latest post by on 20 Mar 2015 at 10:31pm

Toad for MySQL 7.3.1.3290 via SSL to MySQL

Expand content
mit MySQL Workbench funktioniert die Verbindung, bitte um hilfe: meine meldung: System.IO.IOException Fehler bei Handshake wegen eines unerwarteten Paketformats. Stack Trace: bei System.Net.Security...

mit MySQL Workbench funktioniert die Verbindung, bitte um hilfe:

meine meldung:

System.IO.IOException

Fehler bei Handshake wegen eines unerwarteten Paketformats.

Stack Trace:

  bei System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)

  bei System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)

  bei System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)

  bei System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)

  bei System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)

  bei System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)

  bei System.Net.Security.SslStream.AuthenticateAsClient(String targetHost, X509CertificateCollection clientCertificates, SslProtocols enabledSslProtocols, Boolean checkCertificateRevocation)

  bei MySql.Data.MySqlClient.NativeDriver.StartSSL()

  bei MySql.Data.MySqlClient.NativeDriver.Open()

  bei MySql.Data.MySqlClient.Driver.Open()

  bei MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)

  bei MySql.Data.MySqlClient.MySqlConnection.Open()

  bei Quest.Toad.MySQL.MySQLConnection.OpenInitialTestConnection()

  bei Quest.Toad.MySQL.MySQLConnection.DoBeforeConnect()

  bei Quest.Toad.Db.Connection.Connect(Boolean notify)

  bei Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

danke. hannes

1501 1 / Create an account to join the discussion.
mito
Follow / 13 Mar 2015 at 5:28pm / Toad for MySQL
Latest post by on 20 Mar 2015 at 10:29pm

Unable to compare. Error when selecting databases.

Expand content
On the 'new compare'-window if I try to select a database from the dropdown error popup says: "Keyword not supported 'ts;pooling' Devart.Data.MySql " This used to work in previous...

On the 'new compare'-window if I try to select a database from the dropdown error popup says: "Keyword not supported 'ts;pooling' Devart.Data.MySql "

This used to work in previous versions.

Toad for MySQL version: 7.3.1.3290

1087 1 / Create an account to join the discussion.
s.pollard
Follow / 5 Mar 2015 at 1:43am / Toad for MySQL
Latest post by on 20 Mar 2015 at 10:16pm

Unable to view saved toad sql files through my documents / windows...

Expand content
hi - recently when i save a file in toad - other users cannot view the files that i save. When i go to view the files by going thorugh my computer into the folder they are saved in they do not appear....

hi - recently when i save a file in toad - other users cannot view the files that i save. When i go to view the files by going thorugh my computer into the folder they are saved in they do not appear. however when i log into toad i can see them. 

has anyone else experienced this issue?

Cheers

1325 1 / Create an account to join the discussion.
pstein
Follow / 21 Sep 2011 at 12:27pm / Toad for MySQL
Latest post by on 16 Mar 2015 at 8:06pm

Can I download older (v5.x) versions of Toad for MySQL?

Expand content
I prefer to use older version (v5.x) of Toad for MySQL. Can I download them somewhere? on the main download page there is only the newest GA version available. Peter

I prefer to use older version (v5.x) of Toad for MySQL.

Can I download them somewhere?
on the main download page there is only the newest GA version available.

Peter

4190 7 / Create an account to join the discussion.
pablo.boswell
Follow / 21 Oct 2014 at 10:50pm / Toad for MySQL
Latest post by on 16 Mar 2015 at 8:04pm

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

2162 2 / Create an account to join the discussion.
Madhur
Follow / 31 Jan 2013 at 9:19am / Toad for MySQL
Latest post by on 12 Mar 2015 at 8:08am

Unable to connect to any of the specified MySQL hosts.

Expand content
HI I am using Windows 7 64-bit, trying to make a connection using Toad MY-SQL Providing the following details: Username: root Password: password Connection Type: TCP Host: localhost Port: 3306 Didn't...
HI I am using Windows 7 64-bit, trying to make a connection using Toad MY-SQL

Providing the following details:

Username: root
Password: password
Connection Type: TCP
Host: localhost
Port: 3306

Didn't provide any database name. I got the following error -"Unable to connect to any of the specified MySQL hosts". Any help is appreciated.
3939 2 / Create an account to join the discussion.
AMDWEBSITES
Follow / 8 Apr 2012 at 5:56pm / Toad for MySQL
Latest post by on 12 Mar 2015 at 8:06am

Connection Error - "Unable to connect to any of the specified...

Expand content
Hi there, I hope you can help, as I'm almost pulling my hair out!! I've set up a MySQL database through my host tsohost and tried to connect to it via TOAD but am constantly getting the error message...

Hi there,

I hope you can help, as I'm almost pulling my hair out!!

I've set up a MySQL database through my host tsohost and tried to connect to it via TOAD but am constantly getting the error message "Unable to connect to any of the specified MySQL hosts."

I've checked all my details and entered them correctly. I've also checked that my Port 3306 is open. I'm at a loss as to what is wrong...

These are the details I have from my host:

Hostname: 10.168.1.** (also tried the default localhost)
Connection Method: TCP
Database Version: MySQL 5
Database Name: amd_****
Database Username: amd_****
PAssword: ****

Can you please help?

5351 2 / Create an account to join the discussion.
NioZero
Follow / 12 Feb 2015 at 7:17pm / Toad for MySQL
Latest post by on 5 Mar 2015 at 10:42pm

Download Older version

Expand content
Hi, i want to download an older version of Toad for MySql. I installed the last version but when i try to connect to one of our databases it shows the message "Authentication with old password no...

Hi, i want to download an older version of Toad for MySql. I installed the last version but when i try to connect to one of our databases it shows the message "Authentication with old password no longer supported, use 4.1 style passwords". Older version of Toad has no problem connecting to the database

What is the last version when old password where supported and if possible to have a download link please?

Unanswered 2337 5 / Create an account to join the discussion.
savoym
Follow / 3 Mar 2015 at 3:56pm / Toad for MySQL

Difference between Rows value under the Information tab for the selected...

Expand content
Working on Version: 7.3.1.3290. I am looking at 2 very different values on a table I'm trying to get a true row count on. In Toad when I select the TABLE and then on the right side of my display...

Working on Version: 7.3.1.3290.

I am looking at 2 very different values on a table I'm trying to get a true row count on.

In Toad when I select the TABLE and then on the right side of my display I have multiple tabs such as Columns, Data Information, Indexes, Constraints , etc.  Under the Information tab there is a Rows value that shows:  1952388

However, when I execute a SELECT COUNT(*) FROM tableA I see a COUNT(*) = 731826.

What is the difference?  Which one is the true row count?  

Any help/direction would be appreciated.  Thank you.

1310 0 / Create an account to join the discussion.
simarjeet
Follow / 12 Feb 2015 at 10:23am / Toad for MySQL
Latest post by on 27 Feb 2015 at 7:21pm

how I can speed up mysql query with group by

Expand content
I have simple MyISAM table for search, where I indexed fulltext search ion "search_text" for search text table structure : CREATE TABLE IF NOT EXISTS `product_search` ( `dept_id` int(11) unsigned...

I have simple MyISAM table for search, where I indexed  fulltext search ion "search_text"  for search text

table structure :

    CREATE TABLE IF NOT EXISTS `product_search` (
      `dept_id` int(11) unsigned NOT NULL DEFAULT '0',
      `product_id` int(11) NOT NULL DEFAULT '0',
      `search_text` longtext,
      FULLTEXT KEY `search` (`search_text`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Query :

    SELECT p.product_id
          , p.dept_id
     FROM product_search p
     WHERE (MATCH(search_text) AGAINST('fathers day') AND 1 )
     GROUP BY product_id LIMIT 50

**With group by** it took around **10-12** seconds

**Without group by** it took **0.0086** seconds

When I have checked the query with explain
query explain :

    id     select_type   table      type         possible_keys      key     key_len     ref     rows     Extra     
    1     SIMPLE          p               fulltext     search             search      0                      1         Using where; Using temporary; Using filesort

What should I do in this case?



2272 3 / Create an account to join the discussion.
lucho
Follow / 25 Mar 2014 at 12:34pm / Toad for MySQL
Latest post by on 27 Feb 2015 at 2:04am

Dump SQL Database for re-import in phpmyadmin

Expand content
Hi everyone, I change my web server and i need export my database for re-import in my phpmyadmin server. But how make to let only 1 file?

Hi everyone,

I change my web server and i need export my database for re-import in my phpmyadmin server. But how make to let only 1 file? 

2559 2 / Create an account to join the discussion.
Enric_Naval
Follow / 25 Feb 2015 at 10:18am / Toad for MySQL

"Format code" doesn't understand SEPARATOR?

Expand content
"Format code" refuses to format any query containing GROUP_CONCAT + SEPARATOR: For example: SELECT level , GROUP_CONCAT(code SEPARATOR ' ' ) FROM Logs GROUP BY level; SEPARATOR...

"Format code" refuses to format any query containing GROUP_CONCAT + SEPARATOR:

For example:

SELECT
level
, GROUP_CONCAT(code SEPARATOR ' ')
FROM Logs
GROUP BY level;

SEPARATOR is valid since at least MySQL 4.1: http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html#function_group-concat

This bug exists since beta 7.0 http://www.toadworld.com/products/toad-for-mysql/toad_for_mysql_beta_program/f/90/t/20717.aspx

Unanswered 1419 0 / Create an account to join the discussion.
Alex CanĂ¡rio
Follow / 13 May 2014 at 1:28am / Toad for MySQL
Latest post by on 16 Feb 2015 at 11:18pm

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

4057 20 / Create an account to join the discussion.
olivierdemeijer
Follow / 7 Oct 2014 at 9:20pm / Toad for MySQL
Latest post by on 12 Feb 2015 at 5:18am

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 !

2203 1 / Create an account to join the discussion.
savoym
Follow / 10 Feb 2015 at 2:19pm / Toad for MySQL

Question on column lists

Expand content
I have what I hope is an easy question. I would like to know how to TURN OFF the column list automatically showing up after I key in SELECT and press the keyboard spacebar? I would like to control what...

I have what I hope is an easy question.  I would like to know how to TURN OFF the column list automatically showing up after I key in SELECT and press the keyboard spacebar?  I would like to control what shows up in the editor.  Hope this makes sense.  Any help would be appreciated.

Thanks.

1878 0 / Create an account to join the discussion.
Kalle L
Follow / 26 Apr 2012 at 9:10pm / Toad for MySQL
Latest post by on 6 Feb 2015 at 4:23pm

Can not open SQL files while connected

Expand content
I have recently discovererd toad and I am very impressed so far. I have however one problem: Toad hangs if I open a SQL file while I have an active connection. If I open the SQL file before i open the...

I have recently discovererd toad and I am very impressed so far.

I have however one problem: Toad hangs if I open a SQL file while I have an active connection. If I open the SQL file before i open the connection to the database server, it works OK.

I spent some time googling about this problem, but have'nt found anything. Does anyone have any suggestions?

I am using Toad 6.3.0.642 on Windows 7 Ultimate 64-bit.  

4333 8 / Create an account to join the discussion.
veliecer
Follow / 30 Jan 2015 at 9:42pm / Toad for MySQL
Latest post by on 6 Feb 2015 at 2:31am

Critical not conect to DB MySQL Toad 7.3

Expand content
Hi I have one problem. I trai to open database Mysql 5.6.17,but Toad show the error: --/// System.Net.Sockets.SocketException El sistema detectó una dirección de puntero no válida...

Hi

I have one problem. I trai to open database Mysql 5.6.17,but Toad show the error:

--///

System.Net.Sockets.SocketException
El sistema detectó una dirección de puntero no válida al intentar utilizar un argumento de puntero en una llamada
Stack Trace:
   en System.Net.Sockets.Socket.GetSocketOption(SocketOptionLevel optionLevel, SocketOptionName optionName)
   en System.Net.Sockets.NetworkStream.get_ReadTimeout()
   en MySql.Data.MySqlClient.TimedStream..ctor(Stream baseStream)
   en MySql.Data.MySqlClient.MySqlStream..ctor(Stream baseStream, Encoding encoding, Boolean compress)
   en MySql.Data.MySqlClient.NativeDriver.Open()
   en MySql.Data.MySqlClient.Driver.Open()
   en MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   en MySql.Data.MySqlClient.MySqlConnection.Open()
   en Quest.Toad.MySQL.MySQLConnection.OpenInitialTestConnection()
   en Quest.Toad.MySQL.MySQLConnection.DoBeforeConnect()
   en Quest.Toad.Db.Connection.Connect(Boolean notify)
   en Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()
--///

I need suport, because I Need follow work my Projects 

Regart

Eliecer Vargas.

2069 1 / Create an account to join the discussion.
nuttynibbles
Follow / 10 Apr 2010 at 9:44am / Toad for MySQL
Latest post by on 4 Feb 2015 at 9:26am

Unable to install Toad MySQL on windows 7

Expand content
Hi, i downloaded the latest copy of toad for mysql. when i run it, it shows the blue "initialising wise installation wizard" box followed by the "welcome to the toad for mysql freeware installation...
Hi, i downloaded the latest copy of toad for mysql. when i run it, it shows the blue "initialising wise installation wizard" box followed by the "welcome to the toad for mysql freeware installation wizard". once i click next, it just disappear. i've already set its compatibility level to window xp sp2 but still unable to install.

any help will be appreciated.

Thanks.
4408 6 / Create an account to join the discussion.