Toad for MySQL Forum - Toad for MySQL - Toad World
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

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

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.  

16671 18 / Create an account to join the discussion.
red888
Follow / 19 Jan 2017 at 12:17pm / Toad for MySQL
Latest post by on 19 Jan 2017 at 5:17pm

Creating a team wide settings file?

Expand content
I want to create a team wide toad settings file that all team members can import and use. Basically the import thing it needs to have is connections to all of our DB servers. Seems like Toad makes...

I want to create a team wide toad settings file that all team members can import and use.

Basically the import thing it needs to have is connections to all of our DB servers.

Seems like Toad makes this impossible because connections have user creds stored with them?

Can I just have a settings file will all the DB connections without user creds attached to them?

27 1 / Create an account to join the discussion.
romber
Follow / 9 Oct 2016 at 7:22am / Toad for MySQL
Latest post by on 16 Jan 2017 at 11:37pm

how to cancel the pop up of table hint?

Expand content
a new feature was added in the new release(7.9.0.637),that is table hint,in the release note,there is a describe of this feature: In the Editor, you can place the cursor over a table name in a SQL...

a new feature was added in the new release(7.9.0.637),that is table hint,in the release note,there is a describe of this feature:

  • In the Editor, you can place the cursor over a table name in a SQL statement to display the list of columns in the table.

BUT, i really do not want this feature, is there anyway to forbid this?

931 5 / Create an account to join the discussion.
Zlatko.G
Follow / 14 Jan 2017 at 10:45am / Toad for MySQL
Latest post by on 16 Jan 2017 at 11:35pm

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
89 1 / Create an account to join the discussion.
Wendy.Schafer-Colvin
Follow / 9 Jan 2017 at 2:48pm / Toad for MySQL
Latest post by on 16 Jan 2017 at 11:31pm

Beta program

Expand content
Is the Toad for MySQL Beta program still active?

Is the Toad for MySQL Beta program still active?

Unanswered 140 3 / Create an account to join the discussion.
mcars
Follow / 11 Jan 2017 at 10:34pm / Toad for MySQL
Latest post by on 14 Jan 2017 at 4:05am

Receiving error message when using Quick Export to Excel - Object...

Expand content
The quick export feature was working perfectly until a week ago which happened to coincide when Visio 2013 was installed on my desktop. Now.. I am unable to use the quick export feature for my query...

The quick export feature was working perfectly until a week ago which happened to coincide when Visio 2013 was installed on my desktop.

Now.. I am unable to use the quick export feature for my query result sets.

Is there a quick fix for this other than uninstalling Visio ??

I'm using Toad for MySQL ver 7.5; Windows 7 OS, MS Office 2010

Thanks!

104 1 / Create an account to join the discussion.
vijay.paskanti
Follow / 6 Jan 2017 at 8:43pm / Toad for MySQL
Latest post by on 13 Jan 2017 at 10:04pm

Restore .sql into MySQL

Expand content
I have .sql dump file which is 300 MB file. I need help in restoring this .sql dump into a database. I tried to open the .sql file from File->open, but it is throwing out of memory exception. Appreciate...

I have .sql dump file which is 300 MB file. I need help in restoring this .sql dump into a database.

I tried to open the .sql file from File->open, but it is throwing out of memory exception.

Appreciate if someone give detailed steps to perform this activity.

Unanswered 159 3 / Create an account to join the discussion.
Mark.Snowshall
Follow / 22 Dec 2016 at 1:11pm / Toad for MySQL
Latest post by on 9 Jan 2017 at 2:55pm

Automated script getting "Connection failed"

Expand content
I am having a problem with setting up a script to run a Toad Data Report in that when I set it up within Toad and run it will logged into Toad it works fine, however when the automation script is scheduled...

I am having a problem with setting up a script to run a Toad Data Report in that when I set it up within Toad and run it will logged into Toad it works fine, however when the automation script is scheduled and run it comes up with the following and fails:-

-- 22/12/2016 12:48:58: AdCard Transactions.log: Connection description was not found in Connection Manager
-- 22/12/2016 12:48:58: AdCard Transactions.log: Connection failed


I am using version 7.9.0.637 for MySQL on a windows server.  Any help would be appreciated.

Unanswered 145 2 / Create an account to join the discussion.
Francesco
Follow / 19 Dec 2016 at 6:24pm / Toad for MySQL
Latest post by on 4 Jan 2017 at 3:11am

HTTP Tunnel connection

Expand content
Hi, I want to set an http tunnel connection with a remote MySQL database, these kind of connections are normally established with a PHP file with the connection parameters to the database on the remote...

Hi,

I want to set an http tunnel connection with a remote MySQL database, these kind of connections are normally established with a PHP file with the connection parameters to the database on the remote server, every MySQL client has it's own PHP file for this purpose.

I'm just wondering if there is any PHP template for http tunnel connections in Toad for MySQL.

Unanswered 222 5 / Create an account to join the discussion.
Yoni Sade
Follow / 23 Nov 2016 at 8:37am / Toad for MySQL
Latest post by on 28 Dec 2016 at 5:29pm

Formatter breaks on "LIMIT" clause with variables

Expand content
Tried formatting stored procedure code which has a query with "LIMIT v_param1,v_param2" syntax, and it breaks because of the variables. Using Toad for MySQL 7.9.0.637

Tried formatting stored procedure code which has a query with "LIMIT v_param1,v_param2" syntax, and it breaks because of the variables.

Using Toad for MySQL 7.9.0.637

286 2 / Create an account to join the discussion.
nevd
Follow / 24 Dec 2016 at 1:49am / Toad for MySQL

Connection problem on Toad Mac Edition

Expand content
Just installed Toad Mac Edition v2.4.2 and attempted connection to MySQL database but getting "Access denied for user 'root'@'localhost' ". Connection string is: "jdbc...

Just installed Toad Mac Edition  v2.4.2 and attempted connection to MySQL database but getting "Access denied for user 'root'@'localhost' ".

Connection string is: "jdbc:mysql://localhost:3306/test1?characterEncoding=latin1" and various other encoding attempts.

Unsure about "Encoding" field, tried a few Latin 1, UFT8, but the issue here seems to be authentication.  

New to Toad but I'm able to access MySQL from the Terminal command line and using Python PyCharm.

146 0 / Create an account to join the discussion.
Aaron Lil
Follow / 8 Dec 2016 at 5:23pm / Toad for MySQL
Latest post by on 22 Dec 2016 at 1:47pm

Excessive spacing when using formatter

Expand content
I'm facing an issue with excessive spacing between selected columns list and its aliases when formatting the SQL. I've already searched on every option in settings but I couldn't find a fix...

I'm facing an issue with excessive spacing between selected columns list and its aliases when formatting the SQL.

I've already searched on every option in settings but I couldn't find a fix for that.

Below is an example of SQL:
Before format:
SELECT CASE WHEN t.columncase = 0 THEN 1 WHEN t.columncase = 1 THEN -1 END AS total, t.col1 AS column1, t.col2 AS column2, t.col3 AS column3, t.col4 AS column4, t.col5 AS column5, t.col6 AS column6
FROM table t

After format:


How it should be:


I'm using these formatter settings:
<FormatterOptions>
<Version>252</Version>
<LegacyOptionsGUI>5.290.0</LegacyOptionsGUI>
<QP5>5.295</QP5>
<RightMargin>150</RightMargin>
<VarDeclAlignment>0</VarDeclAlignment>
<ParamDeclAlignment>0</ParamDeclAlignment>
<PassedParamAlignment>0</PassedParamAlignment>
<CommaStyle>2</CommaStyle>
<AndOrOperatorPos>2</AndOrOperatorPos>
<ParenthesizedQueryAsBlock>1</ParenthesizedQueryAsBlock>
<GroupByArrangement>W</GroupByArrangement>
<OrderByArrangement>W</OrderByArrangement>
<ColumnArrangement>W</ColumnArrangement>
<ExprArrangeOnCol>99</ExprArrangeOnCol>
<DmlKeywordsLeftAligned>1</DmlKeywordsLeftAligned>
</FormatterOptions>

Could someone help please?

Thanks.

Unanswered 174 2 / Create an account to join the discussion.
desai.mayank
Follow / 30 Nov 2016 at 7:34am / Toad for MySQL
Latest post by on 20 Dec 2016 at 3:43am

Issue in adding file from "import wizard".

Expand content
Hi, When I click on Add File option in Import Wizard(Send to ->Import Wizard->Add Files) it simply greyed out . Nothing happened. Add file pop-up is not opening. Please help!!!

Hi,

When I click on Add File option in Import Wizard(Send to ->Import Wizard->Add Files)  it simply greyed out . Nothing happened. Add file pop-up is not  opening.

Please help!!!

Unanswered 194 1 / Create an account to join the discussion.
alfredudu
Follow / 15 Dec 2016 at 11:36am / Toad for MySQL
Latest post by on 19 Dec 2016 at 7:15pm

Can't connect to MySQL named pipe

Expand content
Hello I'm trying to connect to a local database using settings: But, i receive this error: In HeidiSQL software, works... How to resolve this error in toad? Thanks


Hello

I'm trying to connect to a local database using settings:

But, i receive this error:

In HeidiSQL software, works...

How to resolve this error in toad?

Thanks

188 4 / Create an account to join the discussion.
billc63
Follow / 2 Apr 2014 at 10:53am / Toad for MySQL
Latest post by on 4 Dec 2016 at 8:07pm

SQL Script formatting

Expand content
I have installed Toad For MYSQL 7.0.0.2038 and I am experiencing a problem with SQL formatting Toad puts all my SQL into one line. When I open a VIEW and go to the Script tab my SQL appears as in the...

I have installed Toad For MYSQL 7.0.0.2038 and I am experiencing a problem with SQL formatting

Toad puts all my SQL into one line.

When I open a VIEW and go to the Script tab my SQL appears as in the sample below.

CREATE VIEW  `database`.`table_v` AS select `field`.`id` AS `id`,`field`.`user_id` AS `user_id`,`ua`.`display_name` AS `display_name`,`field`.`user_type_id` AS `user_type_id`,`uta`.`name` AS `user_type`,`field`.`source_id` AS `source_id`,`tst`.`name` AS `source`,`field`.`author_id` AS `author_id`,(case when (`field`.`user_type_id` = 1) then `ua`.`display_name` when (`field`.`user_type_id` = 2) then `taa`.`name` else `ua`.`display_name` end) AS 'author'

When I use Notepad or NaviCat my SQL appears as

CREATE VIEW table_v AS

SELECT

field.id,
field.user_id,
ua.display_name,
field.user_type_id,
uta.name AS user_type,
field.source_id,
tst.name AS source,
field.author_id,

CASE
      WHEN field.user_type_id = 1
      THEN ua.display_name
      WHEN field.user_type_id = 2
      THEN taa.name
      ELSE ua.display_name
END AS author,

Toad has managed to convert SELECT, CASE, WHEN, THEN, ELSE and END to lower case. It has also added '' around object names and added AS 

I would like Toad to display the SQL as it appears in Navicat and notepad. I have altered Editor settings to no avail. 

Can anybody shed any light on How to do this?

Many thanks,

Bill

10501 1 / Create an account to join the discussion.
Guy_M
Follow / 16 Feb 2011 at 11:56am / Toad for MySQL
Latest post by on 4 Dec 2016 at 8:02pm

Format SQL in script editor doesn't work with "non SELECT"...

Expand content
Hi, I don't know if it's a bug or if I miss something. The "Format SQL" command works fine with SELECT script (like SELECT FROM WHERE) but doesn't work with other SQL script (like...

Hi,

I don't know if it's a bug or if I miss something.

The "Format SQL" command works fine with SELECT script (like SELECT FROM WHERE) but doesn't work with other SQL script (like CREATE/ALTER VIEW ... AS SELECT ...).

It's very annoying when I have to alter a view with a huge SELECT statement.

I hope that help
Guy
PS: please apologize my poor English.

10873 2 / Create an account to join the discussion.
Guy_M
Follow / 9 May 2012 at 4:55pm / Toad for MySQL
Latest post by on 4 Dec 2016 at 7:59pm

Editor formatter seems to not work

Expand content
Hi, I wrote this sample of code in the editor : SELECT @OneVar; -- A comment CALL OneProc(); then I apply the editor formatter (default) I get this SELECT @OneVar;-- A commentCALL OneProc(); It's seems...

Hi,

I wrote this sample of code in the editor :
SELECT @OneVar;
-- A comment
CALL OneProc();

then I apply the editor formatter (default) I get this
SELECT @OneVar;-- A commentCALL OneProc();

It's seems there is a bug or I put a wrong option in the formatter, which one ?

Best regards
Guy

10648 1 / Create an account to join the discussion.
Valerie Cahill
Follow / 29 Nov 2016 at 10:26pm / Toad for MySQL
Latest post by on 30 Nov 2016 at 3:51pm

Tutorial on how to learn Toad

Expand content
Hi Can anybody please tell me where I can get step by step instrusction on how to operate Toad , learn how to use toad to build queries and save views etc. Nothing is working for me. I have learned some...

Hi Can anybody please tell me where I can get step by step instrusction on how to operate Toad , learn how to use toad to build queries and save views etc. Nothing is working  for me. I have  learned some MySQL but nothing working for me?

290 2 / Create an account to join the discussion.
yonisade
Follow / 1 Nov 2016 at 9:46pm / Toad for MySQL
Latest post by on 5 Nov 2016 at 12:48am

Trying to save options gives error "Object reference not set...

Expand content
For example, try changing "show line numbers" in editor options and click "Apply". I'm using v7.9.0.637

For example, try changing "show line numbers" in editor options and click "Apply".

I'm using v7.9.0.637

491 1 / Create an account to join the discussion.