Toad for MySQL Forum - Toad for MySQL - Toad World

Toad for MySQL Forum

Community Discussion

charles.pritt
Follow / 26 Apr 2016 at 9:34pm / Toad for MySQL
Latest post by on 27 Aug 2016 at 3:30am

Toad for MySQL 7.7 will not connect to anything

Expand content
Installed new Toad for MySQL 7.7. Imported connections from Toad 7.0. I am unable to connect to any of my pre-defined connections which still work in Toad 7.0. Newly created connections do not work...

Installed new Toad for MySQL 7.7.  Imported connections from Toad 7.0.

I am unable to connect to any of my pre-defined connections which still work in Toad 7.0.

Newly created connections do not work either. I have 105 MySQL servers on linux which i administrate

and so far Toad 7.7 has gone backwards and is useless to me.

87 MySQL servers are MySQL Enterprise 5.7 and the remaining units are Enterprise 5.6

968 5 / Create an account to join the discussion.
sake4567
Follow / 24 Aug 2016 at 4:27pm / Toad for MySQL
Latest post by on 27 Aug 2016 at 3:29am

how to enable execute all button ?

Expand content
Execute all button is disable in the Toad I installed ? how to enable it ?

Execute all button is disable in the Toad I installed ? how to enable it ?

Unanswered 76 1 / Create an account to join the discussion.
marko.demattia
Follow / 10 Feb 2014 at 1:10pm / Toad for MySQL
Latest post by on 27 Aug 2016 at 3:27am

command line to start Toad for MySql

Expand content
Hi, I would to know if it is possible to start toad for mysql with a command line for example "toad.exe username/password@dbserver " thanks in advance

Hi,

I would to know if it is possible to start toad for mysql with a command line for example "toad.exe username/password@dbserver "

thanks in advance

10401 3 / Create an account to join the discussion.
Laro88
Follow / 25 Aug 2016 at 6:39am / Toad for MySQL

Bug?? in Schema comparison, Default values are ignored in the case...

Expand content
There seems to be a bug in the schema comparison between servers. On one server I have a Default value of '' on a couple of columns, however comparing the the tables on different servers does...

There seems to be a bug in the schema comparison between servers.

On one server I have a Default value of '' on a couple of columns, however comparing the the tables on different servers does NOT reveal the Toad 7.9.0.637

It looks like the default '' that results in an empty string is completely omitted.

  

Running the create statement on MySQL Workbench results in the following SQL statement - which has the DEFAULT '' as expected.

CREATE TABLE `part` (
`partid` int(11) NOT NULL AUTO_INCREMENT,
`specifier` varchar(45) NOT NULL,
`serial` varchar(45) NOT NULL,
`nonceid` int(11) NOT NULL DEFAULT '-1',
`uuid` varchar(45) NOT NULL DEFAULT 'x',
`guitype` varchar(45) NOT NULL DEFAULT '',
`description` varchar(300) DEFAULT '',
`jsonconfig` varchar(10000) DEFAULT NULL,
`dynpartref` varchar(45) DEFAULT NULL,
`TZ` varchar(100) DEFAULT NULL,
PRIMARY KEY (`partid`)
) ENGINE=InnoDB AUTO_INCREMENT=21634 DEFAULT CHARSET=utf8;

Any help to get the schema comparison to include this string default would be great.

34 0 / Create an account to join the discussion.
balin
Follow / 16 Apr 2012 at 12:40pm / Toad for MySQL
Latest post by on 9 Aug 2016 at 9:20am

events manager

Expand content
other mysql-clients such as navicat, sqlyog, all have events manager, but i can't find events manger in toad? someone who can tell me, where is it ? or toad for mysql doesn't have yet?
other mysql-clients such as navicat, sqlyog, all have events manager,
but i can't find events manger in toad?
someone who can tell me, where is it ? or toad for mysql doesn't have yet?
4309 4 / Create an account to join the discussion.
romber
Follow / 30 May 2016 at 4:52am / Toad for MySQL
Latest post by on 9 Aug 2016 at 9:19am

is there any plan to add event management feature??

Expand content
toad for mysql is the best tool of mysql managent, but unfortunately, it does not have event management module. so is there any plan to add event management feature?? really need this!!!

toad for mysql is the best tool of mysql managent,

but unfortunately, it does not have event management module.

so is there any plan to add event management feature??

really need this!!!

1055 4 / Create an account to join the discussion.
kevin_28295
Follow / 5 Aug 2016 at 10:45am / Toad for MySQL

Error trying to compare a local and remote database: See video po...

Expand content
The error mentions a table named 'db" but I don't have a table with that name. https://goo.gl/U4LH7E

The error mentions a table named 'db" but I don't have a table with that name.

https://goo.gl/U4LH7E

175 0 / Create an account to join the discussion.
Shahroon
Follow / 2 Aug 2016 at 8:40pm / Toad for MySQL
Latest post by on 4 Aug 2016 at 3:47pm

Toad For MySQL Giving Error When Creating A New Connection

Expand content
I Recently installed Toad For MySQl. When ever a tried to creating new connection i get this error. "MySQL Database Error " "Access denied for user 'root'@'localhost'...

I Recently installed Toad For MySQl. When ever a tried to creating new connection i get this error.  

"MySQL Database Error "

"Access denied for user 'root'@'localhost' (using password: YES)"

Is there a way to fix this?

241 4 / Create an account to join the discussion.
coewar
Follow / 29 Jul 2016 at 11:31pm / Toad for MySQL
Latest post by on 30 Jul 2016 at 1:53am

JSON commands somehow not working in Toad

Expand content
If you send this simple query to MySQL from Toad, it returns an error: SELECT JSON_OBJECT('id', 87, 'name', 'carrot'); I had ver 7.7 and it returned "unknown data type"...

If you send this simple query to MySQL from Toad, it returns an error: SELECT JSON_OBJECT('id', 87, 'name', 'carrot');

I had ver 7.7 and it returned "unknown data type"

Now I tried with 7.9 and it just fails without letting me know why other than:

Category Timestamp Duration Message Line Position
Error 7/29/2016 6:26:11 PM 0:00:00.093 <link> - MySQL Database Error: Fatal error encountered during command execution. 1 0

But sending this query through mysql commandline works fine.

This is supposed to work without any database, as shown here:

https://dev.mysql.com/doc/refman/5.7/en/json-creation-functions.html

I'm using MySQL 5.7.11

and Toad for MySQL 7.9.0.637

Unanswered 259 1 / Create an account to join the discussion.
pstein
Follow / 26 Jun 2016 at 7:16am / Toad for MySQL
Latest post by on 26 Jul 2016 at 8:41pm

Bug: MySQL for Toad v7.7.0.579 always freezes cursor/desktop at second...

Expand content
After a longer time I revert back to Toad for MySQL. I downloaded the newest version and installed it on 64bit Win 7. The first start worked fine. However if I close the setup/connection wizard and...

After a longer time I revert back to Toad for MySQL. I downloaded the newest version and installed it on 64bit Win 7.

The first start worked fine.


However if I close the setup/connection wizard and Toad main window and start it later again then the whole desktop freezes.

Main Toad window and connection dialog is shown again but I cannot move the cursor any more.

The only solution is then to Ctrl+Alt+Del and to log out + re-login into my Win7 account.

This bug is reproducable.


Whats the reason?

Yes, I re-installed Toad again but the error remains.

Peter

569 4 / Create an account to join the discussion.
lijingle
Follow / 13 Jul 2016 at 3:18am / Toad for MySQL
Latest post by on 23 Jul 2016 at 2:59am

toad for mysql autoCommit off, but cann't query data that commit...

Expand content
toad for mysql autoCommit off, but cann't query the line that commit by another transaction befor i commit my trnasaction.

toad for mysql autoCommit off, but cann't query the line that commit by another transaction befor i commit my trnasaction.

369 1 / Create an account to join the discussion.
john5480
Follow / 14 Jul 2016 at 8:54am / Toad for MySQL

cli UI in toad for mysql

Expand content
Hi, i've got version 6.0 and 7.7 , how to use cli UI but not edit window? mysql>

Hi, i've got version 6.0 and 7.7 , how to use cli UI  but not edit window?

mysql>

314 0 / Create an account to join the discussion.
pstein
Follow / 30 Jun 2016 at 7:02am / Toad for MySQL
Latest post by on 13 Jul 2016 at 3:04am

Why is Toad.exe starting WISPTIS.EXE when started but does not close...

Expand content
As I noticed Toad.exe ist starting WISPTIS.EXE process/program on my Win 7 system. Why? My computer is a non-tablet-computer but a "normal" desktop PC. Moreover it is not closing WISPTIS...

As I noticed Toad.exe ist starting WISPTIS.EXE process/program on my Win 7 system.

Why?

My computer is a non-tablet-computer but a "normal" desktop PC.

Moreover it is not closing WISPTIS.EXE again at exit of Toad.

Why?

Is there an option to disable triggering WISPTIS.EXE from Toad?

Peter

433 1 / Create an account to join the discussion.
thorsten
Follow / 12 Jul 2016 at 3:43pm / Toad for MySQL
Latest post by on 13 Jul 2016 at 2:30am

Format SQL - Parser Messages: Incorrect syntax near 'GET'...

Expand content
Hi, when I copy/past the example procedure regarding Get-Diagnostigs from the MySql Reference Manual into Toad for MySql (Version 7.7.0.579) and use the function "Format SQL" I get the following...

Hi,

when I copy/past the example procedure regarding Get-Diagnostigs from the MySql Reference Manual into Toad for MySql (Version 7.7.0.579) and use the function "Format SQL" I get the following error message: 

Parser Messages:12/07/2016 16:08:16: line 11, col 5: Incorrect syntax near 'GET'

Does anyone has an idea?

DB version is 5.7.13-log.

Many thanks in advance...

Thorsten

Procedure taken from here:

https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html

CREATE PROCEDURE p ()
BEGIN
-- Declare variables to hold diagnostics area information
DECLARE errcount INT;
DECLARE errno INT;
DECLARE msg TEXT;
DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
-- Here the current DA is nonempty because no prior statements
-- executing within the handler have cleared it
GET CURRENT DIAGNOSTICS CONDITION 1
errno = MYSQL_ERRNO, msg = MESSAGE_TEXT;
SELECT 'current DA before mapped insert' AS op, errno, msg;
GET STACKED DIAGNOSTICS CONDITION 1
errno = MYSQL_ERRNO, msg = MESSAGE_TEXT;
SELECT 'stacked DA before mapped insert' AS op, errno, msg;

-- Map attempted NULL insert to empty string insert
INSERT INTO t1 (c1) VALUES('');

-- Here the current DA should be empty (if the INSERT succeeded),
-- so check whether there are conditions before attempting to
-- obtain condition information
GET CURRENT DIAGNOSTICS errcount = NUMBER;
IF errcount = 0
THEN
SELECT 'mapped insert succeeded, current DA is empty' AS op;
ELSE
GET CURRENT DIAGNOSTICS CONDITION 1
errno = MYSQL_ERRNO, msg = MESSAGE_TEXT;
SELECT 'current DA after mapped insert' AS op, errno, msg;
END IF;
GET STACKED DIAGNOSTICS CONDITION 1
errno = MYSQL_ERRNO, msg = MESSAGE_TEXT;
SELECT 'stacked DA after mapped insert' AS op, errno, msg;
END;
INSERT INTO t1 (c1) VALUES('string 1');
INSERT INTO t1 (c1) VALUES(NULL);
END;

350 1 / Create an account to join the discussion.
q03242
Follow / 12 Jul 2016 at 6:29pm / Toad for MySQL

Show Window List Click Through

Expand content
Toad for MySQL 7.7.0.579 - Fixed in Toad for MySQL 7.9.0.637 The Windows Tabs (or maybe they are called editor tabs) toolbar has a drop down icon to "Show Window List" that is useful when there...

Toad for MySQL 7.7.0.579 - Fixed in Toad for MySQL 7.9.0.637

The Windows Tabs (or maybe they are called editor tabs) toolbar has a drop down icon to "Show Window List" that is useful when there are many tabs.

However, if one of the window tabs is under the "Show Window List" drop down icon, then left-clicking the icon acts like a right-click on the tab that is under it.

This isn't a big issue since I can scroll the tabs or select the tab from the "Window" menu.

Thank you.

304 0 / Create an account to join the discussion.
Joe12312312345
Follow / 14 Apr 2016 at 7:05pm / Toad for MySQL
Latest post by on 12 Jul 2016 at 5:12pm

Collations not showing up in the alter table gui

Expand content
Hi, I'm using Toad for Mysql 7.7.0.579. When i connection to a db, and right click on a table, and select alter table, and then go to the columns list, and click on a column, the collation property...

Hi,

   I'm using Toad for Mysql 7.7.0.579.  When i connection to a db, and right click on a table, and select alter table, and then go to the columns list, and click on a column, the collation property 1) does not show the current collation setting for that column  2) does not list the available collations when i click on the drop down on the combo box to show the contents of the combo box.

   Is this an unsupported operation, or am I missing something?

   Here's a screen shot.  You can see the collation is set to utf8_unicode_ci in the create table sql behind the dialog, but the alter table dialog shows nothing.

Thanks,

Joe

905 3 / Create an account to join the discussion.
Danneman
Follow / 8 Jul 2016 at 4:02am / Toad for MySQL
Latest post by on 9 Jul 2016 at 12:58am

How to add a key column?

Expand content
Hi, I just installed Toad and am excited about using it, Im using mysql, and just trying it out I created a database, table and some column that I link to my visual studio project. it connects fine to...

Hi,
I just installed Toad and am excited about using it,

Im using mysql, and just trying it out I created a database, table and some column that I link to my visual studio project. it connects fine to the database.

However, when adding some random data to the columns in Toad I get a warning/error saying I need to have a key column.

Sure, but in Toad under "Alter Table > Columns", I simply dont see where the option of adding a key column is to be found.

The complete error-text is:

"Dynamic SQL generation for the UpdateCommand is not supported against SelectCommand that does not return any key column information."

Answered 419 3 / Create an account to join the discussion.
lijingle
Follow / 14 Jun 2016 at 4:54am / Toad for MySQL
Latest post by on 1 Jul 2016 at 2:01am

new connection, password contains " character, report error as...

Expand content
new connection, password contains " character, report error as picture show System.ArgumentException 从索引 18 处开始,初始化字符串的格式不符合规范。 (-- trans to english: The format of the initialization string does...

new connection, password contains " character, report error as picture show

System.ArgumentException
从索引 18 处开始,初始化字符串的格式不符合规范。  (-- trans to english:  The format of the initialization string does not conform to the specification. )
Stack Trace:
在 System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
在 System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
在 System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
在 System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
在 MySql.Data.MySqlClient.MySqlConnectionStringBuilder..ctor(String connStr)
在 MySql.Data.MySqlClient.MySqlConnection.set_ConnectionString(String value)
在 MySql.Data.MySqlClient.MySqlConnection..ctor(String connectionString)
在 Quest.Toad.MySQL.MySQLConnection.CreateConnection()
在 Quest.Toad.MySQL.MySQLConnection.OpenInitialTestConnection()
在 Quest.Toad.MySQL.MySQLConnection.DoBeforeConnect()
在 Quest.Toad.Db.Connection.Connect(Boolean notify)
在 Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

587 3 / Create an account to join the discussion.
pstein
Follow / 26 Jun 2016 at 7:09am / Toad for MySQL
Latest post by on 26 Jun 2016 at 7:09pm

Where/how to download older versions of Toad for MySQL?

Expand content
When I go to web page http://www.toadworld.com/m/freeware/1469 then I can only download the newest version of Toad for MySQL. Since the newest version freezes (see other posting) at second start...

When I go to web page

http://www.toadworld.com/m/freeware/1469

then I can only download the newest version of Toad for MySQL.

Since the newest version freezes (see other posting) at second start I want to install an older version.

Is there a way to download older versions somewhere?

Peter

Unanswered 552 1 / Create an account to join the discussion.
romber
Follow / 10 May 2016 at 11:58am / Toad for MySQL
Latest post by on 8 Jun 2016 at 2:29am

can not show explain plan with toad for mysql

Expand content
when i try to show the explain plan of sql statement using toad for mysql, but it shows error blew: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign...

when i try to show the explain plan of  sql statement using toad for mysql,

but it shows error blew:

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

could anyone help me on this pb?

thanks in advance

870 7 / Create an account to join the discussion.