Toad for MySQL Forum - Toad for MySQL - Toad World

Toad for MySQL Forum

Danny Torres
Follow / 1 Nov 2016 at 1:57pm / Toad for MySQL

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
Do you have a quick support question and short of time? Contact us Via Twitter @ QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

Do you have a quick support question and short of time? Contact us Via Twitter  @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

501 0 / Create an account to join the discussion.
olivierdemeijer
Follow / 7 Oct 2014 at 9:20pm / Toad for MySQL
Latest post by on 22 Mar 2017 at 6:30pm

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 !

11964 3 / Create an account to join the discussion.
rgreener
Follow / 21 Mar 2017 at 11:41pm / Toad for MySQL

Unable to open TPG file with version 7.9.0.637

Expand content
I have Mysql Toad loaded on two machines. One is running 7.7 and the other 7.9.0.637. Both machines were able to open the same TPG file stored on dropbox. After upgrading to 7.9.0.637 the tpg file does...

I have Mysql Toad loaded on two machines. One is running 7.7  and the other 7.9.0.637.   Both machines were able to open the same TPG file stored on dropbox.  After upgrading to 7.9.0.637  the tpg file does not open.  normally after successfully opening the filename appears on the tab. On the 7.9 version,  it shows "untitled" on the tab and you cannot show underlying grid by right clicking.

Has something changed??  Any troubleshooting tips?

thanks very much!

rg

34 0 / Create an account to join the discussion.
ihristov
Follow / 31 Aug 2016 at 9:08am / Toad for MySQL
Latest post by on 20 Mar 2017 at 6:14pm

Object reference not set to an instance of an object error while exporting...

Expand content
11:04:18 ч. Thread (20) Export Started [31.8.2016 г. 11:04:18 ч.] 11:04:18 ч. Thread (20) Export Wizard: Building object list 11:04:19 ч. Thread (20) Exporting Data (1 of 1) 11:04:19 ч. Thread (20) Object...

11:04:18 ч. Thread (20) Export Started [31.8.2016 г. 11:04:18 ч.]
11:04:18 ч. Thread (20) Export Wizard: Building object list
11:04:19 ч. Thread (20) Exporting Data (1 of 1)
11:04:19 ч. Thread (20) Object SQL Query started.
11:04:19 ч. Thread (20) Writing rows 0 - 1
11:04:19 ч. Thread (20) Exception in WriteRows
11:04:19 ч. Thread (20) Object reference not set to an instance of an object.
11:04:19 ч. Thread (20) Writing rows Finalize
11:04:19 ч. Thread (20) Object Table Result Set finished with error: Object reference not set to an instance of an object.
11:04:19 ч. Thread (20)    at Quest.Toad.ImportExport.Writers.WriterBase.WriteRows(FastTable fastTable)
   at Quest.Toad.ImportExport.ExportObjectData.StartTableWrite(Object context)
   at Quest.Toad.ImportExport.ExportObjectData.Begin(LogEventHandler logEventHandler, Dictionary`2 connections, Object context)
11:04:24 ч. Thread (20) Export Finished [31.8.2016 г. 11:04:24 ч.]

1682 8 / Create an account to join the discussion.
nazman_junior
Follow / 3 Feb 2017 at 9:34am / Toad for MySQL
Latest post by on 20 Mar 2017 at 5:41am

Issue with case sensitive (Upper case/Lower case/Title case and etc...

Expand content
Hi, I have a question, how do i turn off case sensitive feature on toad for mysql v 7.0? Cause it seems like I can't search/query data with different type of cases, let say "Azman/aZman/azMan...

Hi, I have a question, how do i turn off case sensitive feature on toad for mysql v 7.0? Cause it seems like I can't search/query data with different type of cases, let say "Azman/aZman/azMan/azmAn/azmaN/AZMAN" or any other type of cases will give me different results. It's like it checks base on case sensitive. Hope someone can help me.

Thank you so much.

321 4 / Create an account to join the discussion.
charles.pritt
Follow / 17 Mar 2017 at 3:37pm / Toad for MySQL

Unable to login to any of my Mysql databases with toad 7.7 or 7.9

Expand content
I have 3 installations of toad. I have version 7.0, 7.7, and 7.9. I have 147 MySQL servers. They are all on linux vm's. With version 7.0 I can login to all of my servers using TCP. With version...

I have 3 installations of toad. I have version 7.0, 7.7, and 7.9.

I have 147 MySQL servers.  They are all on linux vm's.

With version 7.0 I can login to all of my servers using TCP. 

With version 7.7 or 7.9 I cannot log  into any server.  I have tried to create new connections with the 7.7 & 7.9 versions but that does not resolve the issue. As, far as i am concerned versions 7.7 & 7.9 are useless to me.

suggestions would be appreciated.

Unanswered 53 0 / Create an account to join the discussion.
chanchal_sheik
Follow / 16 Mar 2017 at 3:18pm / Toad for MySQL

Automation\Schedule\Job Manager\Access Denied\Toad Data Point 3.6

Expand content
I am trying to schedule an automated job but on clicking schedule get popup with error "Access Denied"

I am trying to schedule an automated job but on clicking schedule get popup with error "Access Denied"

41 0 / Create an account to join the discussion.
Guest
Follow / 24 Feb 2010 at 4:47pm / Toad for MySQL
Latest post by on 15 Mar 2017 at 11:50am

Schema Compare always different with auto increment option

Expand content
Using v 4.6.0.531 schema compare. Every table is marked as different if you have the compare auto increment option on (not the auto increment value), you need to turn on the ignore option for both auto...

Using v 4.6.0.531 schema compare.

Every table is marked as different if you have the compare auto increment option on (not the auto increment value), you need to turn on the ignore option for both auto increment and auto increment value for the schema compare to make any sense.

All the other options seem to be fine.

Is this a bug?

Thanks,
Mark.

12579 3 / Create an account to join the discussion.
Yoni Sade
Follow / 3 Nov 2016 at 1:54pm / Toad for MySQL
Latest post by on 15 Mar 2017 at 10:10am

BUG: Group Execute error - "Lookup Error - MySQL Database Error...

Expand content
Even though I've selected databases across different servers, I'm getting error when trying to group execute the SQL script: "Lookup Error - MySQL Database Error: No database selected"...

Even though I've selected databases across different servers, I'm getting error when trying to group execute the SQL script:

"Lookup Error - MySQL Database Error: No database selected"

After that, the "Execute Scripts" button is stuck as a red stop circle, until I cancel the "Group Execute" option by clicking on its green double green arrow button.

After doing that, I'm not able to mark the "Group Execute" checkbox in the vertical "Group Execute" tab on the left side of the editor.

I'm using Toad for MySQL 7.9.0.637.

681 2 / Create an account to join the discussion.
namhoon
Follow / 9 Mar 2017 at 7:36am / Toad for MySQL

datetime column default value Error In "Schema Compare"...

Expand content
HI. When using "Schema Compare" the Datetime Default value CURRENT_TIMESTAMP appears in the ' CURRENT_TIMESTAMP' . Must appear at CURRENT_TIMESTAMP. ' must not be written...

HI.

When using  "Schema Compare"

the Datetime Default value  CURRENT_TIMESTAMP appears in the ' CURRENT_TIMESTAMP' .

Must appear at CURRENT_TIMESTAMP. 

'  must not be written.

I think this is not a difficult error.

I hope it will be able to correct it soon.

77 0 / Create an account to join the discussion.
t17
Follow / 3 Mar 2017 at 10:06pm / Toad for MySQL
Latest post by on 4 Mar 2017 at 1:19am

Editor instant syntax checking

Expand content
Suddenly I find as I am typing in the editor window, Toad is instantly checking syntax in real time and automatically flipping over to the Messages tab to show the result of that syntax check - all as...

Suddenly I find as I am typing in the editor window, Toad is instantly checking syntax in real time and automatically flipping over to the Messages tab to show the result of that syntax check - all as I am typing.

I find this annoying as I would rather it stay on the Result Sets tab of the previous output (as it always used to do) - until I am ready to execute the statement again.

Is there a setting to change this behavior?

Thanks

Answered 142 2 / Create an account to join the discussion.
andyd01
Follow / 6 Jan 2011 at 1:49pm / Toad for MySQL
Latest post by on 4 Mar 2017 at 1:18am

Toad Hangs - has to be terminated

Expand content
I have an ongoing problem with Toad for MySql where if I leave it running, but don't use it for a period of time, when I come back to it it's basically hung. I can't do anything in the software...

I have an ongoing problem with Toad for MySql where if I leave it running, but don't use it for a period of time, when I come back to it it's basically hung.  I can't do anything in the software, and I can't quit and I have to terminate the process.  This happens several times a day.

Running on Windows 7 x64.  Anybody know what's going on and how to fix this/

20629 23 / Create an account to join the discussion.
jackolson
Follow / 1 Mar 2017 at 8:09pm / Toad for MySQL
Latest post by on 3 Mar 2017 at 2:03pm

error #2006

Expand content
Dear All, Help me out ! MySQL error message: error #2006 What does this message mean? Is there something I can do myself to repair MySQL?

Dear All,

Help me out !

MySQL error message: error #2006

What does this message mean? Is there something I can do myself to repair MySQL?

 

Answered 178 3 / Create an account to join the discussion.
gowtham_chandra
Follow / 22 Feb 2017 at 9:38am / Toad for MySQL
Latest post by on 2 Mar 2017 at 4:59pm

How to Save Database Diagram as an Image file ?

Expand content
I have created database diagram for my schema using toad. It was done and fine. While saving by default, it is .ter format. And accepting no other formats. How can I save my diagram as an Image file (for...

I have created database diagram for my schema using toad. It was done and fine. While saving by default, it is .ter format. And accepting no other formats. How can I save my diagram as an Image file (for ex .jpg) ?  

Thanks in advance ! :) 

Answered 217 3 / Create an account to join the discussion.
headingwest
Follow / 20 Jan 2017 at 10:26pm / Toad for MySQL
Latest post by on 2 Mar 2017 at 4:58pm

MySQL how do I create snapshot

Expand content
Hi, I'm trying to compare schemas with 2 MySQL databases using a snapshot. How do I create a snapshot? According to the help file I click on an icon/button that I'm unable to find. Thanks for...

Hi, I'm trying to compare schemas with 2 MySQL databases using a snapshot.

How do I create a snapshot? According to the help file I click on an icon/button that I'm unable to find.

Thanks for your help.

348 2 / Create an account to join the discussion.
georgikostadinov933@yahoo.com

Query different 2 different databases on different servers - TOAD

Expand content
Hi I have a problem about data extract which is too big to handle manually so I need to create a temp table which to insert some data and then use that temp table to write the select query joining different...

Hi

I have a problem about data extract which is too big to handle manually so I need to create a temp table which to insert some data and then use that temp table to write the select query joining different other tables to get the required data,..

my issue is that I have 1 db where I'm able to create temp table but the db where I need to get the primary data from is located on another db (another server)

I have googled it how can I query from different dbs and found some cross-query but still cannot find something specific guide for that issue and at whole if this is possible to be done .

Can you please provide some experience help regarding that issue?

Unanswered 90 0 / Create an account to join the discussion.
milosilic1
Follow / 18 Feb 2017 at 2:31pm / Toad for MySQL

Toad for MySQL freeware licensing

Expand content
Hi, is Toad for MySQL freeware free for commercial use? Thanks, Milos

Hi,

is Toad for MySQL freeware free for commercial use?

Thanks,

Milos

Unanswered 178 0 / Create an account to join the discussion.
Zlatko.G
Follow / 14 Jan 2017 at 10:45am / Toad for MySQL
Latest post by on 13 Feb 2017 at 4:25pm

Will Toad for Mysql support in the future MariaDB

Expand content
Dear Toad, My name is Zlatko. I am a volunteer at the union retirees Croatian. I use Toad for MySQL as a frontend to a database MariaDB. Keep track of union members. I'm very pleased with Toad for...
Dear Toad,
My name is Zlatko. I am a volunteer at the union retirees Croatian. I use Toad for MySQL as a frontend to a database MariaDB. Keep track of union members. I'm very pleased with Toad for MySQL program.
I wonder if in the near future Toad for MySQL database support MariaDB. Currently MariaDB and MySQL are compatible. In the future will certainly be no significant differences in these databases so will no longer be compatible so Toad for MySQL will no longer be a frontend for MariaDB.
My question is whether it will in the near future Toad for MySQL support especially MariaDB? Do you plan to make Toad for MariaDB? It interests me because I started a lot of union members in the database MariaDB and only serve to know the program of Toad for MySQL. Toad for MySQL is easy to use for beginners like me.
Best regards,
Zlatko
572 10 / Create an account to join the discussion.
wjb
Follow / 22 Jan 2017 at 7:01am / Toad for MySQL
Latest post by on 7 Feb 2017 at 8:47am

edit exception

Expand content
I clicked edit, but nothing happens, including some buttons that open the edit

I clicked edit, but nothing happens, including some buttons that open the edit

Answered 392 5 / Create an account to join the discussion.
savoym
Follow / 20 Oct 2014 at 6:49pm / Toad for MySQL
Latest post by on 2 Feb 2017 at 4:20pm

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.

22722 5 / Create an account to join the discussion.