Toad for MySQL - General

Community Discussion

UTTAM POWAR
Follow / 2 May 2015 at 11:01am / Toad for MySQL

connection time out while connecting.

Expand content
I have mysql database connect it with database via toad 7.3 mysql Problem is that, It doesnot connect without internet services run. Is it possible to connect it without running internet service ...

I have mysql database connect it with database via toad 7.3 mysql

Problem is that, It doesnot connect without internet services run.

Is it possible to connect it without running internet service

Let me know setting if any

78 0 / Create an account to join the discussion.
akshay
Follow / 3 Oct 2014 at 9:34am / Toad for MySQL
Latest post by on 15 Apr 2015 at 12:03pm

Attempted to read past the end of the stream MySQL Database Error

Expand content
With Toad for MySQL 7.3 I am now unable to connect to a DB (ssh) which I was able to connect to with the 7.2 version and no details have changed. I keep getting the following error: "Attempted to...

With Toad for MySQL 7.3 I am now unable to connect to a DB (ssh) which I was able to connect to with the 7.2 version and no details have changed. I keep getting the following error:

"Attempted to read past the end of the stream".

Can someone please help to resolve this issue

Unanswered 3633 1 / Create an account to join the discussion.
Swapnil Ronghe
Follow / 14 Apr 2015 at 10:02am / Toad for MySQL
Latest post by on 14 Apr 2015 at 1:14pm

sql join query taking too much time to execute in mysql

Expand content
taking too much time to execute sql join query in toad for mysql

taking too much time to execute sql join query in toad for mysql

802 1 / Create an account to join the discussion.
jaybonk_218
Follow / 14 Jun 2010 at 7:54pm / Toad for MySQL
Latest post by on 12 Apr 2015 at 6:01pm

Object Explorer doesn't show all stored procedures

Expand content
I created a procedure and when I went to view it in the object explorer tab for procedures, it wasn't visible in the list. This is the only procedure in this particular database, but if I do a select...

I created a procedure and when I went to view it in the object explorer tab for procedures, it wasn't visible in the list.  This is the only procedure in this particular database, but if I do a select from information_schema.routines it shows up, along with the list of procedures in other databases.

I've dropped and created the procedure a number of times, each time it says executed successfully, and shows up in information_schema, just not in the object explorer.

3685 4 / Create an account to join the discussion.
NioZero
Follow / 12 Feb 2015 at 7:17pm / Toad for MySQL
Latest post by on 10 Apr 2015 at 3:01pm

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?

Answered 3990 9 / Create an account to join the discussion.
dennis7
Follow / 9 Apr 2015 at 2:24pm / Toad for MySQL

Change colors of Database Diagram tables?

Expand content
Hi, Is there any way to change the colors used in the Database Diagrams? With the default color scheme, I cannot even read the names of the tables on a printout. Thanks!

Hi,

Is there any way to change the colors used in the Database Diagrams? With the default color scheme, I cannot even read the names of the tables on a printout.

Thanks!

Unanswered 1054 0 / Create an account to join the discussion.
CMT18
Follow / 7 Apr 2015 at 9:19am / Toad for MySQL

Reverse Engineer Table/FK question

Expand content
Hi, When extract DDL from a schema, Is there a way to separate between the table and its foreign keys? I would want the create Foreign Keys to be separate since I would want to create all the tables...

Hi,

When extract DDL from a schema, Is there a way to separate between the table and its foreign keys?

I would want the create Foreign Keys to be separate since I would want to create all the tables first

and then create all the foriegn keys without worrying that FK create may fail since the ref table was not created first ?

1221 0 / Create an account to join the discussion.
snolan_484
Follow / 2 Apr 2015 at 8:53pm / Toad for MySQL
Latest post by on 2 Apr 2015 at 8:56pm

Bug: incorrect prompt for variables

Expand content
In a very specific case, Toad for MySQL will prompt for variables when it should not, and then return an incorrect result. The following test will reproduce the bug Execute the following SQL SELECT...

In a very specific case, Toad for MySQL will prompt for variables when it should not, and then return an incorrect result. The following test will reproduce the bug

Execute the following SQL

SELECT 'Test \' to show incorrect variable prompt?';

Expected result:

Test ' to show incorrect variable prompt?

Actual result:

Prompt for a variable named @f0, which should not be shown at all, and then regardless of whether you click OK or Cancel, and regardless of whether or not you enter a value for the variable the following result (the question mark replaced with "@f0")

Test ' to show incorrect variable prompt@f0

Note that if you use two quotes instead of \' to escape the quote then Toad works correctly, so

Execute the following SQL

SELECT 'Test '' to show incorrect variable prompt?';

Gives the expected result:

Test ' to show incorrect variable prompt?

 

1535 1 / Create an account to join the discussion.
AMDWEBSITES
Follow / 8 Apr 2012 at 5:56pm / Toad for MySQL
Latest post by on 2 Apr 2015 at 8:33am

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?

6990 3 / Create an account to join the discussion.
snolan_484
Follow / 9 Aug 2013 at 5:18pm / Toad for MySQL
Latest post by on 31 Mar 2015 at 5: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 4831 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 2930 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

3020 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

2545 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

2761 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

5749 7 / Create an account to join the discussion.
pablo.boswell
Follow / 21 Oct 2014 at 9: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!!!!!!!

3692 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.
5482 2 / 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.

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



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

4058 2 / Create an account to join the discussion.