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

Toad for MySQL - General

Community 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

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

154 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

161 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 198 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 231 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 255 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

311 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 318 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
10010 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

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

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

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

554 0 / Create an account to join the discussion.
working...
Follow / 12 Feb 2016 at 11:55pm / Toad for MySQL

Disable Toad options environment Grid data type formatting - Date...

Expand content
Using Toad for MySQL 7.7.0.579: Is there a way to turn off or disable the toad option: environment - Grid - Data formatting such that the automatic data formatting will not apply? I want an need to use...

Using Toad for MySQL 7.7.0.579:  Is there a way to turn off or disable the toad option: environment - Grid - Data formatting such that the automatic data formatting will not apply?   I want an need to use the format options that SQL commands have available to format the data into different presentations for similar data in the same query.  For example date, I have say 4 different date time fields that I want to display in a single query.  I want to be able to use DATE_FORMAT to display the date of one column in one format, then a different format for second column and a third format for a the third column.  I just need to be able to turn off or disable the drid data formation function so that I can apply the SQL command format output.

Unanswered 554 0 / Create an account to join the discussion.
stephlocke
Follow / 11 Feb 2014 at 11:58am / Toad for MySQL
Latest post by on 11 Feb 2016 at 12:40am

Using Toad with MariaDB when it has PAM authentication

Expand content
I am currently trying to integrate Linux services into my Windows environment and have installed MariaDB with PAM authentication following the guidance from MariaDB . I have tested successfully on the...

I am currently trying to integrate Linux services into my Windows environment and have installed MariaDB with PAM authentication following the guidance from MariaDB.

I have tested successfully on the box (using putty) that I can authenticate using my AD credentials, however when I try to login via Toad I get the following error:

Client does not support authentication protocol requested by server; consider upgrading MariaDB client

I have tried adding the line pam-use-cleartext-plugin to the conf file and restarting the server but no joy. I have downloaded HeidiSQL and confirmed that its use of libmysql.dll means that it can use the PAM authentication. It looks like toad for MySQL utilises myodbc.dll - any ideas how to work around this? I love toad and would much rather be able to use it

11848 8 / Create an account to join the discussion.
Kim Opus
Follow / 8 Feb 2016 at 9:33pm / Toad for MySQL
Latest post by on 9 Feb 2016 at 1:23pm

Query Builder

Expand content
Why am I getting the table name duplicated when I build a simple SELECT statement with the Query Builder? SELECT film.title, film.description FROM film film It also happens when I do a join: SELECT...

Why am I getting the table name duplicated when I build a simple SELECT statement with the Query Builder?

SELECT film.title, film.description
  FROM film film

It also happens when I do a join:

SELECT film.title,
       film.description,
       actor.last_name,
       actor.first_name
  FROM (film_actor film_actor
        INNER JOIN actor actor ON (film_actor.actor_id = actor.actor_id))
       INNER JOIN film film ON (film.film_id = film_actor.film_id)

It's annoying! Using TOAD for MySQL 7.7.0.579

Thanks in advance...

Unanswered 629 1 / Create an account to join the discussion.
mike_angel
Follow / 8 Feb 2016 at 10:13am / Toad for MySQL

Variable 'MySqlDatatype_Bit' does not exist in the resource...

Expand content
Hello! Is somebody knows, how to cover this bug in the "Schema compare"? Current version is "Toad for MySQL 7.7.0.579", and i faced it every time i used "Schema compare"...

Hello!

Is somebody knows, how to cover this bug in the "Schema compare"?

Current version is "Toad for MySQL 7.7.0.579", and i faced it every time i used "Schema compare" last two years.

Unanswered 515 0 / Create an account to join the discussion.
pstein
Follow / 1 Feb 2016 at 7:08am / Toad for MySQL

How to make Toad for MySQL portable/put an USB flash drive?

Expand content
I would like to use Toad for MySQL from USB flash drive. It should run on various (Win 7 based) computer even those where it was originally NOT installed. This seems to be currently not possibly...

I would like to use Toad for MySQL from USB flash drive.

It should run on various (Win 7 based) computer even those where it was originally NOT installed.

This seems to be currently not possibly.

Why?

Are there some missing driver installations or Registry entries?

Is there a way to make it portable?

Thank you

Peter

Unanswered 622 0 / Create an account to join the discussion.
Josh4000
Follow / 27 Jan 2016 at 9:53pm / Toad for MySQL

Missing field list and properties toolbar in data report

Expand content
While messing with the field list (explorer) and properties toolbars in the report design view they both disappeared and I cannot find a way to restore them. I tried uninstal/reinstal but that didn't...

While messing with the field list (explorer) and properties toolbars in the report design view they both disappeared and I cannot find a way to restore them. I tried uninstal/reinstal but that didn't work. If anyone could give me some tips it'd be much appreciated.

It looks like I unpinned the field and properties toolbars on the right of the report preview and closed the windows. Unfortuantely I'm not seeing a way to re-enable them - none of the view or tool options restore them.

Steps to reproduce:

1. Make connection

2. go to tools -> Reports -> Data Report

3. Standard Report -> Enter simple query -> Move fields over to "Fields to Display" and click the "finish" button

4. On the right side of the report you should see a field list and properties menu. This is what's missing - not sure how to get them back.

Any help would be appreciated. Thanks..

Unanswered 627 0 / Create an account to join the discussion.