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

544 0 / Create an account to join the discussion.
Kalle L
Follow / 26 Apr 2012 at 9:10pm / Toad for MySQL
Latest post by on 25 Apr 2017 at 10:27pm

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.  

17478 22 / Create an account to join the discussion.
Zlatko.G
Follow / 14 Jan 2017 at 10:45am / Toad for MySQL
Latest post by on 20 Apr 2017 at 4:16pm

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
795 11 / Create an account to join the discussion.
t17
Follow / 16 Apr 2017 at 7:03pm / Toad for MySQL
Latest post by on 18 Apr 2017 at 4:31pm

Run .sql file from editor

Expand content
I have a series of scripts coded and saved in individual .sql files. Is there a way to run a .sql file from within the editor, e.g. (pseudo code) "RUN c:\folder1\script01.sql" Thanks

I have a series of scripts coded and saved in individual .sql files. Is there a way to run a .sql file from within the editor, e.g. (pseudo code)

"RUN c:\folder1\script01.sql"

Thanks

Unanswered 88 1 / Create an account to join the discussion.
conorgdaly_5555
Follow / 12 Apr 2017 at 8:40pm / Toad for MySQL
Latest post by on 14 Apr 2017 at 11:44pm

Linux support - 2017 edition

Expand content
Now that .NET Core has been out for a while, is Toad for MySQL running on Linux any closer to happening?

Now that .NET Core has been out for a while, is Toad for MySQL running on Linux any closer to happening?

111 2 / Create an account to join the discussion.
alyssel
Follow / 13 Apr 2017 at 4:13pm / Toad for MySQL
Latest post by on 13 Apr 2017 at 8:30pm

Toad for MySQL not sending automated emails

Expand content
I have created .tas files and scheduled for a specific time, but emails or email failure messages are not sent. It shows to have run successfully in job manager. Any thoughts or ideas?

I have created .tas files and scheduled for a specific time, but emails or email failure messages are not sent. It shows to have run successfully in job manager. Any thoughts or ideas?

Unanswered 136 3 / Create an account to join the discussion.
Yoni Sade
Follow / 3 Nov 2016 at 1:54pm / Toad for MySQL
Latest post by on 4 Apr 2017 at 7:07am

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.

847 5 / Create an account to join the discussion.
TheBatman
Follow / 31 Mar 2017 at 1:36pm / Toad for MySQL
Latest post by on 3 Apr 2017 at 9:02pm

Complete Result Set Variable in E-mail

Expand content
Hi there, I might be being a little obtuse here but I cannot work out to insert the full result set into a e-mail body from a SQL Execute, I enter the variable name as #Result# in the body which returns...

Hi there,

I might be being a little obtuse here but I cannot work out to insert the full result set into a e-mail body from a SQL Execute,

I enter the variable name as #Result# in the body which returns the first row from the result set. Does anyone know how to insert the full result set without using an attachment.

I did a fair amount of looking around and I am getting nowhere!

Thanks in advance!!!

Stuart

124 1 / Create an account to join the discussion.
korazy
Follow / 29 Mar 2017 at 8:56pm / Toad for MySQL
Latest post by on 30 Mar 2017 at 8:21pm

Schema compare shows difference incorrectly

Expand content
When I do a schema compare, I have a table that Toad shows has a difference, but the tables match. Below in the screenshot shows where the difference is, but they are actually matches. Is there a parameter...

When I do a schema compare, I have a table that Toad shows has a difference, but the tables match.  Below in the screenshot shows where the difference is, but they are actually matches.

Is there a parameter that could be causing this?

Thanks.

153 2 / Create an account to join the discussion.
rgreener
Follow / 21 Mar 2017 at 11:41pm / Toad for MySQL
Latest post by on 26 Mar 2017 at 6:16am

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

133 1 / 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 !

12078 3 / 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 ч.]

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

411 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 119 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"

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

12686 3 / 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.

129 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 216 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/

21026 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 252 3 / Create an account to join the discussion.