Toad for MySQL - General Forum - Toad for MySQL - Toad World

Toad for MySQL - General Forum

Community Discussion

romber
Follow / 30 May 2016 at 4:52am / Toad for MySQL

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

327 0 / Create an account to join the discussion.
ian_11344
Follow / 29 May 2016 at 8:49am / Toad for MySQL
Latest post by on 29 May 2016 at 8:55am

Comparison: Target Where clause lost on save

Expand content
Hello, when I make a comparison and set a Target Where clause, it works the first time. But when I save the comparison and re-open it, the Target Where clause disappear. Is this a bug? Toad for...

Hello,

when I make a comparison and set a Target Where clause, it works the first time.

But when I save the comparison and re-open it, the Target Where clause disappear.

Is this a bug?

Toad for MySQL 7.7.0.579

3406 1 / Create an account to join the discussion.
Bean8320
Follow / 17 May 2016 at 7:42pm / Toad for MySQL
Latest post by on 25 May 2016 at 8:12pm

Could not connect to MySQL

Expand content
I am getting this MySQL error while trying to access the site and and even while trying to log into administrator. Database Error: Unable to connect to the database:Could not connect to MySQL I have tried...

I am getting this  MySQL error while trying to access the site and and even while trying to log into administrator.

Database Error: Unable to connect to the database:Could not connect to MySQL

I have tried refreshing and accessing it a dozen times.

Can somebody please help me to restart MySQL?

Unanswered 211 2 / Create an account to join the discussion.
tim.vanderlois
Follow / 6 May 2016 at 8:31pm / Toad for MySQL
Latest post by on 19 May 2016 at 2:40am

Schema Compare - cannot connect

Expand content
Using Toad for MySQL 7.7.0.579 I select Schema Compare which prompts for Source and Target connections & defaults to current connection. Then clicking the Refresh button or Database dropdown pops...

Using Toad for MySQL 7.7.0.579

I select Schema Compare which prompts for Source and Target connections & defaults to current connection. Then clicking the Refresh button or Database dropdown pops up an alert error: 

"Can't connect to MySql server on '127.0.0.1' (10061):
No connection could be made because the target machine actively refused it 127.0.0.1:3360
Devart.Data.MySql
Can't connect to MySql server on '127.0.0.1' (10061):
No connection could be made because the target machine actively refused it 127.0.0.1:3360
Devart.Data.MySql"

I'm using root credentials - same results when selecting an alternate alias for the Target connection - I'm able to connect to each target and source connection within Toad for MySQL and modify database objects - I'm able to run the data comparison using these same credentials - connection type is SSH...

This a bug or are specific privileges possibly required for the schema comparison?

Unanswered 351 7 / Create an account to join the discussion.
romber
Follow / 10 May 2016 at 11:58am / Toad for MySQL
Latest post by on 17 May 2016 at 12:42am

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

233 5 / Create an account to join the discussion.
Oberonmeister
Follow / 16 May 2016 at 1:32pm / Toad for MySQL
Latest post by on 16 May 2016 at 6:38pm

Building script for Toad

Expand content
Greetings! I'm new to the society of this forum and SQL as well. Normally I would preemptively study the topic and look for existing examples, but unfortunately i have no time, i need the solution...

Greetings!

I'm new to the society of this forum and SQL as well. Normally I would preemptively study the topic and look for existing examples, but unfortunately i have no time, i need the solution ready literally in two days. About SQL I only know the most basic things like how to drop table or inject some value into it, and I never needed any deeper knowledge since it is not my expertise anyway, but now I have to build a script which would take some value from the *.txt file, apply some certain multiplier to it and place the result into other table. Unfortunately, none of my friends know anything about SQL as well, I was just suggested to use Toad for MySQL for my purposes. I'm not sure this is right place to ask about it, but if you can help I'd appreciate it. 

Unanswered 147 1 / Create an account to join the discussion.
charles.pritt
Follow / 26 Apr 2016 at 9:34pm / Toad for MySQL
Latest post by on 28 Apr 2016 at 2:46am

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

323 3 / Create an account to join the discussion.
romber
Follow / 25 Apr 2016 at 8:49am / Toad for MySQL
Latest post by on 26 Apr 2016 at 12:54pm

miss some data when copying rows to excel

Expand content
i tried to copy rows from result sets grid to excel with hot keys(ctrl+A ,ctrl+C, ctrl+V), there are 175rows in result sets grid,but only copied 104rows to excel, this pb exists in both v7.3 and v7...

i tried to copy rows from result sets grid to excel with hot keys(ctrl+A ,ctrl+C, ctrl+V),

there are 175rows in result sets grid,but only copied 104rows to excel,

this pb exists in both v7.3 and v7.7,

is this a bug?or did i miss configuring something?

thanks in advance.

342 7 / Create an account to join the discussion.
Joe12312312345
Follow / 14 Apr 2016 at 7:05pm / Toad for MySQL

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

321 0 / Create an account to join the discussion.
akar
Follow / 7 Apr 2016 at 1:11pm / Toad for MySQL

Unable to connect to a remote mySQL DB

Expand content
Well looks like this is a common problem. I am running a mySQL instance on a Linux Server (CentOS) and my mySQL DB is running at port 3306. When ever I try to configure a new connection from my ToadformySQL...

Well looks like this is a common problem. I am running a mySQL instance on a Linux Server (CentOS) and my mySQL DB is running at port 3306. When ever I try to configure a new connection from my ToadformySQL , it gives error saying "unable to connect to any of the mySQL host specified". I am using TCP as connection type , then I hv supplied the username and password and spefied the port. I have also checked that the port is not blocked in the server(remote) and the user I am trying to connect as is having all the required privilege. I am using WIn8 as my client machine.

Has anybody ran into same issue? what may be the probable solution?

Arindam

Unanswered 356 0 / Create an account to join the discussion.
Guillermo Garcia
Follow / 31 Mar 2016 at 5:03pm / Toad for MySQL

Function for field with multiple iterations?

Expand content
When you have multiple iterations of the same field and you want to query only on the most current one, is there a specific function or command that can help me with this?

When you have multiple iterations of the same field and you want to query only on the most current one, is there a specific function or command that can help me with this?

Unanswered 380 0 / Create an account to join the discussion.
walter_singer
Follow / 31 Mar 2016 at 12:30am / Toad for MySQL

Schema compare error

Expand content
Hello everybody, I have this problem since version 6 on windows 7, I thought it would be resolved but I've tried with the newest version and I'm still having the same problem. I've already...

Hello everybody,

I have this problem since version 6 on windows 7, I thought it would be resolved but I've tried with the newest version and I'm still having the same problem.

I've already change some options but nothing happens.

Is there any solution to this?


I attach a screen capture of the error, I hope some one could resolve or something like that. I'd be very very thankful to someone who has been able to resolve this problem.

Unanswered 413 0 / Create an account to join the discussion.
Newbie123
Follow / 21 Mar 2016 at 6:02am / Toad for MySQL

Connecting to Raspberry Pi 2

Expand content
Hi all, I am new to this software and would like to know how to connect it to a Raspberry Pi 2. Thanks

Hi all,

I am new to this software and would like to know how to connect it to a Raspberry  Pi 2.

Thanks

468 0 / Create an account to join the discussion.
korazy
Follow / 18 Mar 2016 at 2:37pm / Toad for MySQL

Change database on report

Expand content
I created a report using report manager. I have multiple databases that are the same schema, but have data for different companies. I need to run this report on each company, but I can't find where...

I created a report using report manager.  I have multiple databases that are the same schema, but have data for different companies.  I need to run this report on each company, but I can't find where the report has the connection information.  When I created the report, it was pulling data from one company, but now each time I open it, it pulls the data from another company.

How can I change the database source on the report?

Unanswered 476 0 / Create an account to join the discussion.
shikarishambu70_781
Follow / 12 Nov 2010 at 7:59pm / Toad for MySQL
Latest post by on 16 Mar 2016 at 3:46pm

Toad for MySQL 5 - SVN integration - commit pre-hook - comments r...

Expand content
I am trying to use the Version control integration feature to put my database objects in version control. We use Subversion and it is configured to require comments as part of commit. I can't find...
I am trying to use the Version control integration feature to put my database objects in version control. We use Subversion and it is configured to require comments as part of commit.

I can't find a way to provide commit comments in the Version control wizard screen. Is there a way to get comments included while using the Version control wizard?

TIA
10169 1 / Create an account to join the discussion.
UTTAM POWAR
Follow / 2 May 2015 at 10:01am / Toad for MySQL
Latest post by on 29 Feb 2016 at 2:06pm

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

6659 1 / Create an account to join the discussion.
Dogboy
Follow / 17 Feb 2016 at 2:26pm / Toad for MySQL

Warning/error logging using load data local infile

Expand content
Hello, I am using load data to import several csv files. These imports will eventually be scheduled to run every night, so I was wondering if there is a way to log ALL the warnings/errors that might...

Hello,

I am using  load data to import several csv files. These imports will eventually be scheduled to run every night, so I was wondering if there is a way to log ALL the warnings/errors that might occur. When I run the scripts maually, I can see (some of) the erros/warnings int the messages tab, but I would need to store this in a table.

Thanks !

664 0 / Create an account to join the discussion.
Dogboy
Follow / 17 Feb 2016 at 11:42am / Toad for MySQL

Warning/error logging using load data local infile

Expand content
Hello, I am using load data to import several csv files. These imports will eventually be scheduled to run every night, so I was wondering if there is a way to log ALL the warnings/errors that might...

Hello,

I am using  load data to import several csv files. These imports will eventually be scheduled to run every night, so I was wondering if there is a way to log ALL the warnings/errors that might occur. When I run the scripts maually, I can see (some of) the erros/warnings int the messages tab, but I would need to store this in a table.

Thanks !

639 0 / Create an account to join the discussion.
Dogboy
Follow / 17 Feb 2016 at 8:53am / Toad for MySQL

Toad Automation - Rows that cannot be imported are reported twice

Expand content
Hi, I'm setting up import automation scripts. In my template, I have checked the option "If error occurs, save unimported rows to a discard file". Now, each row that cannot be imported...

Hi,

I'm setting up import automation scripts. In my template, I have checked the option "If error occurs, save unimported rows to a discard file". Now, each row that cannot be imported (e.g. because of data type conversion errors) gets reported twice in the output csv file.

Any idea how this can be fixed?

Thanks

Unanswered 647 0 / Create an account to join the discussion.
fajar3083
Follow / 17 Feb 2016 at 3:09am / Toad for MySQL

Can't Connect to Mysql Server "Mysql Database error Attempted...

Expand content
Hi All, need your help i got some error when try connect to mysql server via Toad Mysql, i got error "Mysql Database error Attempted to read past the end of the stream." also i included...

Hi All,

need your help i got some error when try connect to mysql server via Toad Mysql, i got error "Mysql Database error Attempted to read past the end of the stream."

also i included with capture error from toadmysql.

thanks your time for answer my question.

Fajar

711 0 / Create an account to join the discussion.