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

448 0 / Create an account to join the discussion.
gowtham_chandra
Follow / 22 Feb 2017 at 9:38am / Toad for MySQL
Latest post by on 24 Feb 2017 at 5:19am

How to Save Database Diagram as an Image file ?

Expand content
I have created database diagram for my schema using toad. It was done and fine. While saving by default, it is .ter format. And accepting no other formats. How can I save my diagram as an Image file (for...

I have created database diagram for my schema using toad. It was done and fine. While saving by default, it is .ter format. And accepting no other formats. How can I save my diagram as an Image file (for ex .jpg) ?  

Thanks in advance ! :) 

Answered 80 2 / Create an account to join the discussion.
milosilic1
Follow / 18 Feb 2017 at 2:31pm / Toad for MySQL

Toad for MySQL freeware licensing

Expand content
Hi, is Toad for MySQL freeware free for commercial use? Thanks, Milos

Hi,

is Toad for MySQL freeware free for commercial use?

Thanks,

Milos

Unanswered 85 0 / Create an account to join the discussion.
ihristov
Follow / 31 Aug 2016 at 9:08am / Toad for MySQL
Latest post by on 17 Feb 2017 at 1:15am

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

1474 6 / Create an account to join the discussion.
Zlatko.G
Follow / 14 Jan 2017 at 10:45am / Toad for MySQL
Latest post by on 13 Feb 2017 at 4:25pm

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
398 10 / Create an account to join the discussion.
wjb
Follow / 22 Jan 2017 at 7:01am / Toad for MySQL
Latest post by on 7 Feb 2017 at 8:47am

edit exception

Expand content
I clicked edit, but nothing happens, including some buttons that open the edit

I clicked edit, but nothing happens, including some buttons that open the edit

Answered 294 5 / Create an account to join the discussion.
nazman_junior
Follow / 3 Feb 2017 at 9:34am / Toad for MySQL
Latest post by on 7 Feb 2017 at 8:16am

Issue with case sensitive (Upper case/Lower case/Title case and etc...

Expand content
Hi, I have a question, how do i turn off case sensitive feature on toad for mysql v 7.0? Cause it seems like I can't search/query data with different type of cases, let say "Azman/aZman/azMan...

Hi, I have a question, how do i turn off case sensitive feature on toad for mysql v 7.0? Cause it seems like I can't search/query data with different type of cases, let say "Azman/aZman/azMan/azmAn/azmaN/AZMAN" or any other type of cases will give me different results. It's like it checks base on case sensitive. Hope someone can help me.

Thank you so much.

196 3 / Create an account to join the discussion.
savoym
Follow / 20 Oct 2014 at 6:49pm / Toad for MySQL
Latest post by on 2 Feb 2017 at 4:20pm

How to terminate a query that is displayed in Session Monitor

Expand content
I had 2 queries in the editor window. I cancelled it 2X as I had the wrong info in my query. I stopped the background process and thought I was terminating the query. I went into the Session Monitor and...

I had 2 queries in the editor window.  I cancelled it 2X as I had the wrong info in my query.  I stopped the background process and thought I was terminating the query.  I went into the Session Monitor and see those 2 queries in the Query status under the Activity column.  My question is, are these 2 queries still running as they are NOT in sleep mode?  If they are how can I terminate them?

Thanks.

22577 5 / Create an account to join the discussion.
jtelleriar@gmail.com
Follow / 2 Feb 2017 at 2:35pm / Toad for MySQL

TOAD for MySQL: Stop Processes Fails to Stop Query

Expand content
If you are running a query in TOAD for MySQL and you press "Stop Processes" button or "Cancel Executing Query" sometimes TOAD fails to stop the query: If you are running a SELECT...

If you are running a query in TOAD for MySQL and you press "Stop Processes" button or "Cancel Executing Query" sometimes TOAD fails to stop the query:

  • If you are running a SELECT query is properly stopped and you remain in current session. So the behavior of TOAD is similar of that "KILL QUERY processlist_id".
  • But if you are running a INSERT INTO ... SELECT command for example, instead of stopping the query:
    • TOAD opens a new session (Loosing all the temporary tables we had in such session).
    • And continues executing in the backside the INSERT INTO ... SELECT statement, blocking the used tables.

The second behavior forces us to:

  • Re-execute Temporary Table Scripts.
  • And use a "KILL CONNECTION  processlist_id" for being able to stop the query.

So  "Cancel Executing Query" does not always have a good performance. Some sort of Option for having control over these behaviour would be appreciated.

Thank you.

109 0 / Create an account to join the discussion.
jtelleriar@gmail.com
Follow / 2 Feb 2017 at 2:23pm / Toad for MySQL

TOAD for MySQL: Add official support for MariaDB 10.1

Expand content
Hi! I would like to suggest that TOAD for MySQL offers Official support for MariaDB 10.1. Thank you.

Hi!

I would like to suggest that TOAD for MySQL offers Official support for MariaDB 10.1.

Thank you.

109 0 / Create an account to join the discussion.
mn2project
Follow / 31 Jan 2017 at 5:26pm / Toad for MySQL

how to connect mysql toad to mysql rds on amazon

Expand content
Tried to delete... ref post: www.toadworld.com/.../demystify-mysql-on-amazon-rds-with-toad-for-mysql

Tried to delete...

ref post:

www.toadworld.com/.../demystify-mysql-on-amazon-rds-with-toad-for-mysql

Unanswered 105 0 / Create an account to join the discussion.
Vincent P
Follow / 27 Jan 2017 at 11:03am / Toad for MySQL
Latest post by on 28 Jan 2017 at 1:52am

Compare an online Database and an local Database

Expand content
Hello, i've tried but i failed to connect a online BD please help me i'm lost, look at what i've do : I don't know but i think i use a bad connection type... does anyone have an exemple...

Hello, i've tried but i failed to connect a online BD please help me i'm lost, look at what i've do :

I don't know  but i think i use a bad connection type... does anyone have an exemple of how to connect to an online Database ????

178 1 / Create an account to join the discussion.
headingwest
Follow / 20 Jan 2017 at 10:26pm / Toad for MySQL
Latest post by on 23 Jan 2017 at 8:02pm

MySQL how do I create snapshot

Expand content
Hi, I'm trying to compare schemas with 2 MySQL databases using a snapshot. How do I create a snapshot? According to the help file I click on an icon/button that I'm unable to find. Thanks for...

Hi, I'm trying to compare schemas with 2 MySQL databases using a snapshot.

How do I create a snapshot? According to the help file I click on an icon/button that I'm unable to find.

Thanks for your help.

228 1 / 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.  

16975 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?

202 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?

1095 5 / 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 278 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!

272 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 297 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 272 2 / Create an account to join the discussion.