Toad for MySQL Forum - Toad for MySQL - Toad World

Toad for MySQL Forum

Community Discussion

gowtham_chandra
Follow / 6 Aug 2015 at 6:24am / Toad for MySQL
Latest post by on 24 Sep 2016 at 7:23am

Facing Issue while Importing Data into Tables from .xls/.csv files...

Expand content
Hi there , I'm using Toad for MySQL product for the past the few months. Its fine when working with queries. But, whenever i want to insert data of 2k or more records, I'm going for Import...

Hi there , 

I'm using Toad for MySQL product for the past the few months. Its fine when working with queries.

But, whenever i want to insert data of 2k or more records, I'm going for Import Wizard. I tried to import from both .XLS and .CSV files. But Import doesn't processed. Showing "Object Reference Error". 

Please help ASAP.

Unanswered 2495 1 / Create an account to join the discussion.
oliveranthony
Follow / 17 Jul 2013 at 12:11pm / Toad for MySQL
Latest post by on 20 Sep 2016 at 10:59pm

Import Folder greyed out?

Expand content
Hey Guys I'm using TOAD for MySQL v6.7 and I wondered why Import Multiple files is not possible? The Button "Open Folder" is greyed out! Is that a bug or something? Many thanks for...

Hey Guys

I'm using TOAD for MySQL v6.7 and I wondered why Import Multiple files is not possible? The Button "Open Folder" is greyed out! Is that a bug or something?

Many thanks for your time

Unanswered 10545 3 / Create an account to join the discussion.
Kariadill
Follow / 3 Apr 2013 at 2:10pm / Toad for MySQL
Latest post by on 20 Sep 2016 at 6:01pm

Unable to load file

Expand content
In the Data Import wizard I can select a range in a xlsx format excel file but when I highlight and accept the input range, I get, "error reading from data file, check the file format and file encoding"...

In the Data Import wizard I can select a range in a xlsx format  excel file but when I highlight and accept the input range, I get, "error reading from data file, check the file format and file encoding" "Unable to Loadfile".

Grateful if someone would help me on working through this.

I am a total newbie and have so far just created a new database with the above as first step undertaken.

11631 2 / Create an account to join the discussion.
yonisade
Follow / 14 Sep 2016 at 9:41am / Toad for MySQL
Latest post by on 18 Sep 2016 at 8:19am

Error when saving settings

Expand content
When trying to change "Database Timeouts" in Toad options window getting: "object reference not set to an instance of an object" Using Toad for MySQL 7.9.0.637

When trying to change "Database Timeouts" in Toad options window getting:

"object reference not set to an instance of an object"

Using Toad for MySQL 7.9.0.637

Unanswered 140 2 / Create an account to join the discussion.
romber
Follow / 30 May 2016 at 4:52am / Toad for MySQL
Latest post by on 18 Sep 2016 at 4:15am

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

1237 5 / Create an account to join the discussion.
yonisade
Follow / 15 Sep 2016 at 10:27am / Toad for MySQL
Latest post by on 17 Sep 2016 at 1:39am

Error when using Export Wizard

Expand content
When trying to export table rows using Export Wizard (SQL Script) getting this error at the end of the wizard: "object reference not set to an instance of an object. Export is cancelled." ...

When trying to export table rows using Export Wizard (SQL Script) getting this error at the end of the wizard:

"object reference not set to an instance of an object. Export is cancelled."

Using Toad for MySQL 7.9.0.637

Unanswered 122 1 / Create an account to join the discussion.
Zlatko.G
Follow / 16 Sep 2016 at 9:39am / Toad for MySQL

Reports import template for labels error

Expand content
I noticed that there i no option for importing template for labels in meny Reports -Data reports - Label Report. Man can making and saving template for label but when need import label template there is...

I noticed that there i no option for importing template for labels in meny Reports -Data reports - Label Report. Man can making and saving template for label but when need import label template there is no option for importing. I use Toad for mysql v 7.9.0.637

106 0 / Create an account to join the discussion.
chad.gayken@gmail.com
Follow / 6 Sep 2016 at 6:10pm / Toad for MySQL
Latest post by on 16 Sep 2016 at 5:16am

Isn't there a download for mysql on osx?

Expand content
I visited the downloads page but I didn't see an option for (mysql mac) I tried the mysql and downloaded but could not execute because it is for windows.

I visited the downloads page but I didn't see an option for (mysql mac) I tried the mysql and downloaded but could not execute because it is for windows.

248 3 / Create an account to join the discussion.
robin.raiszadeh_562
Follow / 13 Jul 2010 at 12:31am / Toad for MySQL
Latest post by on 9 Sep 2016 at 8:27am

TOAD is Too Slow..

Expand content
Help! If I open more than 4 query tabs, TOAD becomes extremely slow. I am using TOAD for MySQL version 4.6.0.531 on a new DELL Vostro 3500 Laptop running Windows 7 Professional (32 bit mode) with 4 gigs...
Help!

If I open more than 4 query tabs, TOAD becomes extremely slow.
I am using TOAD for MySQL version 4.6.0.531 on a new DELL Vostro 3500 Laptop running Windows 7 Professional (32 bit mode) with 4 gigs of memory and Intel Core i5 CPU.

Thanks,

Robin
3240 3 / Create an account to join the discussion.
ihristov
Follow / 31 Aug 2016 at 9:08am / Toad for MySQL
Latest post by on 9 Sep 2016 at 2:46am

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 ч.]

314 4 / Create an account to join the discussion.
Laro88
Follow / 25 Aug 2016 at 6:39am / Toad for MySQL
Latest post by on 7 Sep 2016 at 6:39am

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.

308 5 / Create an account to join the discussion.
KeithGray
Follow / 1 Sep 2016 at 10:32pm / Toad for MySQL
Latest post by on 6 Sep 2016 at 1:53am

Unknown MySQL error

Expand content
Hello everyone. When i open MySQL database i recieve the following error message: Unknown MySQL error Does anyone have an idea as to what may be causing this?Please suggest me something for mysql...

Hello everyone.

When i open MySQL database i recieve the following error message:

Unknown MySQL error

Does anyone have an idea as to what may be causing this?Please suggest me something for mysql fix ?

Regards,

Keith

Unanswered 267 4 / Create an account to join the discussion.
Danneman
Follow / 8 Jul 2016 at 4:02am / Toad for MySQL
Latest post by on 5 Sep 2016 at 12:18am

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 614 4 / Create an account to join the discussion.
charles.pritt
Follow / 26 Apr 2016 at 9:34pm / Toad for MySQL
Latest post by on 5 Sep 2016 at 12:16am

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

1218 6 / Create an account to join the discussion.
JuniorSantana
Follow / 1 Sep 2015 at 2:43pm / Toad for MySQL
Latest post by on 29 Aug 2016 at 11:55am

Default '' is not recognized in the Schema Comparer

Expand content
I'm trying to use the "Schema Comparer" utility on Toad for MySQL 7.5.0.966. We have several fields (varchar not null) with default '' (empty) but the generated script doesn't...

I'm trying to use the "Schema Comparer" utility on Toad for MySQL 7.5.0.966.

We have several fields (varchar not null)  with default '' (empty) but the generated script doesn't contains the "default" part in this fields.

My statament:

Create table ecleticaloja.teste (id int(11) not null primary key, descricao varchar(100) not null default '');

Script by Toad:

CREATE TABLE `ecleticaloja`.`teste` (
 `id` int(11) NOT NULL,
 `descricao` varchar(100) NOT NULL,
 PRIMARY KEY  ( `id` )
)
ENGINE = InnoDB
CHARACTER SET = latin1
ROW_FORMAT = COMPACT;

How can I fix this?

1906 1 / Create an account to join the discussion.
cybera
Follow / 27 Aug 2016 at 10:21pm / Toad for MySQL

I need some clarification on the the constrains window in TOAD

Expand content
I had the foreign key constraint concept explained to me today, after that I started rummaging though Toad and found this Constraints tab. I have a few questions. Does the source columns represent the...

I had the foreign key constraint concept explained to me today, after that I started rummaging though Toad and found this Constraints tab. I have a few questions.

Does the source columns represent the primary keys and the destination columns the foreign keys or is it the other way around? Or does it work just plain differently?

Second why is there an option to select multiple columns for both source and destination? Isn't a single source and destination column enough to slave one of the tables to the other? Or do those do something else in Toad?

Lets say I have 3 tables people, pictures and stats. And I wanna constrain a column named id from people with columns named people_id in pictures and stats. In this case I should select the table people. create a new constraint for it and mark the source column as id, the destination as table pictures column people_id, than do another separate constrain for the stats table?

Would this act the same way as a foreign key constraint and while I have cascading allowed, allow me to delete a line from table people and automatically deleting lines from pictures and stats as well?

Unanswered 177 0 / 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 264 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

10596 3 / 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?
4524 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

311 0 / Create an account to join the discussion.