Toad for MySQL - General

Community Discussion

deeturagit
Follow / 30 Sep 2014 at 12:34am / Toad for MySQL

Toad for MySQL 7.3 Tools menu missing

Expand content
I have just installed 7,3 and have no tools menu. I have checked under customization and there is no menu listed, there is a set of tools icons, shame I cannot use it to do imports of data from csv as...

I have just installed 7,3 and have no tools menu. I have checked under customization and there is no menu listed, there is a set of tools icons, shame I cannot use it to do imports of data from csv as 7.2 does. Is this one of the paid for features?? 

10 0 / Create an account to join the discussion.
njorger
Follow / 11 Sep 2012 at 8:14pm / Toad for MySQL
Latest post by on 29 Sep 2014 at 11:13am

System.OutOfMemoryException thrown when running big queries

Expand content
I have re-posted this to try and get the answer posted for others who are still having this issue. System.OutOfMemoryException Exception of type 'System.OutOfMemoryException' was thrown. Stack...

I have re-posted this to try and get the answer posted for others who are still having this issue.

System.OutOfMemoryException
Exception of type 'System.OutOfMemoryException' was thrown.
Stack Trace:
at System.String.Replace(String oldValue, String newValue)
at ActiproSoftware.SyntaxEditor.Document.GetText(LineTerminator lineTerminator)
at ActiproSoftware.SyntaxEditor.SyntaxEditor.get_Text()
at Quest.Toad.Editor.EditorForm.CheckConnection()
at Quest.Toad.Editor.EditorForm.DoExecuteSqlScript()
at Quest.Toad.Editor.EditorForm.ExecuteSqlScript()

719 1 / Create an account to join the discussion.
hugovzky
Follow / 3 Sep 2012 at 6:13am / Toad for MySQL
Latest post by on 29 Sep 2014 at 11:12am

System.OutOfMemoryException thrown when running big queries

Expand content
Hi, When I run some big queries (>20MB sql script) Toad throws an out of memory error message. System.OutOfMemoryException Exception of type 'System.OutOfMemoryException' was thrown. Stack Trace...

Hi,

When I run some big queries (>20MB sql script) Toad throws an out of memory error message.

System.OutOfMemoryException
Exception of type 'System.OutOfMemoryException' was thrown.
Stack Trace:
at System.String.Replace(String oldValue, String newValue)
at ActiproSoftware.SyntaxEditor.Document.GetText(LineTerminator lineTerminator)
at ActiproSoftware.SyntaxEditor.SyntaxEditor.get_Text()
at Quest.Toad.Editor.EditorForm.CheckConnection()
at Quest.Toad.Editor.EditorForm.DoExecuteSqlScript()
at Quest.Toad.Editor.EditorForm.ExecuteSqlScript()

I'm using Toad for MySQL 6.3.0.642

Could anyone help me about this?

Thanks in advance

1900 5 / Create an account to join the discussion.
dmikester1
Follow / 23 Sep 2014 at 5:44pm / Toad for MySQL
Latest post by on 24 Sep 2014 at 3:17pm

Please add option to ask to delete record!

Expand content
This is the third time now that I have deleted a record mistakenly by hitting my delete key and it updates the changes immediately without me hitting the checkmark. This is very frustrating. Something...

This is the third time now that I have deleted a record mistakenly by hitting my delete key and it updates the changes immediately without me hitting the checkmark.  This is very frustrating.  Something like deleting a record should ask "are you sure??"  Please add this into Toad.

Thanks

Mike

83 3 / Create an account to join the discussion.
Alex CanĂ¡rio
Follow / 13 May 2014 at 1:28am / Toad for MySQL
Latest post by on 24 Sep 2014 at 1:10pm

Quest.Licensing.LicenseException

Expand content
Hi Guys After installer the Toad for MySQL 7.2 show the error message bellow. Can anybody help-me? Thanks Alex Canario

Hi Guys

After installer the Toad for MySQL 7.2 show the error message bellow.

Can anybody help-me?


Thanks

Alex Canario

810 19 / Create an account to join the discussion.
Steven Soto
Follow / 23 Sep 2014 at 3:12am / Toad for MySQL

Toad for MySQL 7.3 is released!

Expand content
The new stable version of Toad for MySQL 7.3 is now available for immediate download. Just head over to the download section and get it right now!

The new stable version of Toad for MySQL 7.3 is now available for immediate download.

Just head over to the download section and get it right now!

125 0 / Create an account to join the discussion.
soapergem
Follow / 22 Sep 2014 at 4:56pm / Toad for MySQL
Latest post by on 22 Sep 2014 at 5:09pm

Where do I buy a license for Toad for MySQL?

Expand content
And how much does it cost? I downloaded the Freeware version, but cannot for the life of me find where one can go to purchase the full version. Can anyone provide a link please?

And how much does it cost? I downloaded the Freeware version, but cannot for the life of me find where one can go to purchase the full version. Can anyone provide a link please?

106 2 / Create an account to join the discussion.
rlgh60
Follow / 18 Sep 2014 at 4:27pm / Toad for MySQL

Error with SELECT ... INTO ... FROM syntax.

Expand content
I have some sql that does a " SELECT col1 INTO @col_value FROM db1 ". It executes ok when running from the command line on the server. But running from the Editor tab in Toad for MySql version...

I have some sql that does a "SELECT col1 INTO @col_value FROM db1".   It executes ok when running from the command line on the server.  But running from the Editor tab in Toad for MySql version 7.2.0.2992, it fails with an error..  This command  worked in the previous version of Toad.

Even if I try to do a simple SELECT 1 INTO @VAR1; , it fails. with an error message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT
    1
INTO
    @VAR1' at line 1.

Any suggestions on how to solve this issue?

Unanswered 70 0 / Create an account to join the discussion.
flokocha
Follow / 17 Jan 2013 at 4:57pm / Toad for MySQL
Latest post by on 18 Sep 2014 at 10:35am

SSH using RSA keys

Expand content
Hello! I'm trying to set up a connection through a ssh tunnel requiring a pair of rsa keys. But I can't see any option in the connection settings to select the location of my private key. Is this...
Hello!

I'm trying to set up a connection through a ssh tunnel requiring a pair of rsa keys. But I can't see any option in the connection settings to select the location of my private key.

Is this kind of ssh connection impossible?

Thank you

Flo
1078 3 / Create an account to join the discussion.
kulasart
Follow / 13 Aug 2014 at 11:10am / Toad for MySQL
Latest post by on 10 Sep 2014 at 3:45pm

[ERROR] While trying to create group execute script

Expand content
I cant select multiple database schemas, from single server while creating Group Execute script. More than that - list with avalible schemas can not be created in Group Execute window. Exception: System...

I cant select multiple database schemas, from single server while creating Group Execute script.

More than that - list with avalible schemas can not be created in Group Execute window.

Exception: System.NullReferenceException
Message  : Object reference not set to an instance of an object.
Stack Trace:
    Quest.Toad.Grouping.GroupExecutionControl.AddTreeNode(TreeListNode parentTreeNode, ObjectTrl trl)
    Quest.Toad.Grouping.GroupExecutionControl.FetchDatabasesAndAdd(TreeListNode treeNodeParent, Connection conn)
    Quest.Toad.Grouping.GroupExecutionControl.PopulateDatabases(List`1 nodes)

 

Operating System
  Microsoft Windows 7 Professional  6.1.7601 AMD64
  Manufacturer: Microsoft Corporation

206 2 / Create an account to join the discussion.
hsheng
Follow / 2 Sep 2014 at 8:50pm / Toad for MySQL
Latest post by on 2 Sep 2014 at 11:03pm

How to setup Toad for MySQL (Freeware) to use more physical memory

Expand content
Hi, Is it possible to configure Toad for MySQL (Freeware) 7.2.0.2922 to use more than 4G physical memory? Thanks

Hi,

Is it possible to configure Toad for MySQL (Freeware) 7.2.0.2922 to use more than 4G physical memory?

Thanks

Unanswered 143 1 / Create an account to join the discussion.
Rrralec
Follow / 29 Aug 2014 at 2:32pm / Toad for MySQL

Trouble connecting locally...

Expand content
Hello, I have been trying to connect to my own computer to simply learn and write queries for, at the moment, simple data sets in CSV format. My issue: regardless of which SQL program I use, be it mySql...

Hello, 

I have been trying to connect to my own computer to simply learn and write queries for, at the moment, simple data sets in CSV format. 

My issue: regardless of which SQL program I use, be it mySql WorkBench, HeidiSQL, SQLyog, Toad for MySQL, I cannot connect locally. 

I use the standard 

127.0.0.1

localhost

root

port 3306 

setttings and to no avail. 

I have created an exception in my Windows Firewall for port 3306, 

I cannot find Toad in the list of Services. 

I have tried every combination of the above settings in fields Host, Username, Password.

Is there anything I am missing? I'm almost beginning to think I misunderstand entirely what it means to connect locally... I have not set up a server, or have any previous database ready. 

A colleague of mine uses SequelPro on her Mac and simply imports CSV files to query them. 

Also, I have now attempted to connect locally using an SQL program using both of my computers... making it feel as if there really is something wrong with the way I'm attempting to connect. 

If anyone would be able to help, it would be much appreciated. I have never hit a roadblock so early in my attempts to learning a computer software, I am barely making it past the installation... 

Thank you. 

Alec

140 0 / Create an account to join the discussion.
Henrik Johnson
Follow / 14 Apr 2014 at 9:20pm / Toad for MySQL
Latest post by on 28 Aug 2014 at 7:49pm

Toad for MySQL 7.2 is released!

Expand content
The new stable version of Toad for MySQL 7.2 is now available for immediate download. Just head over to the download section and get it right now!

The new stable version of Toad for MySQL 7.2 is now available for immediate download.

Just head over to the download section and get it right now!

1807 9 / Create an account to join the discussion.
pstein
Follow / 24 Feb 2011 at 3:54pm / Toad for MySQL
Latest post by on 28 Aug 2014 at 3:39pm

How to change password for database aaa and user uuu?

Expand content
How can I change the password for (existing) database aaa and existing user uuu? is it only possible through cmdline or through Toad GUI as well? Peter
How can I change the password for (existing) database aaa and existing user uuu?

is it only possible through cmdline or through Toad GUI as well?

Peter
3044 2 / Create an account to join the discussion.
snolan_484
Follow / 9 Aug 2013 at 5:18pm / Toad for MySQL
Latest post by on 19 Aug 2014 at 7:25pm

Error Message prevents Toad from closing

Expand content
I get an error disconnecting from time to time and when the error occurs it prevents Toad from closing. Once that happens, the only way to close Toad is to go to the Windows Task Manager and end the process...

I get an error disconnecting from time to time and when the error occurs it prevents Toad from closing. Once that happens, the only way to close Toad is to go to the Windows Task Manager and end the process. The error message is as follows:

System.ArgumentNullException
Value cannot be null.
Stack Trace:
at System.Threading.Monitor.ReliableEnterTimeout(Object obj, Int32 timeout, Boolean& lockTaken)
at Quest.Toad.Debugger.DebugProviderBase.Cancel()
at Quest.Toad.Debugger.DebugProviderBase.Dispose(Boolean disp)
at Quest.Toad.Debugger.DebugProviderBase.Dispose()
at Quest.Toad.Debugger.DebugClient.CloseDebugging(Connection connection)
at Quest.Toad.Debugger.DebugClient.ConnectionClosingHandler(Object sender, ConnectionClosingEventArgs e)
at Quest.Toad.Notification.NotificationManager.InternalConnectionClosing(Object sender, ConnectionClosingEventArgs args)
at Quest.Toad.Notification.NotificationManager.ConnectionClosing(Object sender, Connection connection)
at Quest.Toad.Gui.MainForm.OnFormClosing(FormClosingEventArgs e)
at System.Windows.Forms.Form.WmClose(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at DevExpress.XtraEditors.XtraForm.WndProc(Message& msg)
at Quest.Toad.Gui.MainForm.WndProc(Message& msg)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Unanswered 826 7 / Create an account to join the discussion.
hsheng
Follow / 14 Aug 2014 at 3:22pm / Toad for MySQL

Comparing replicated table contents

Expand content
Toad for MySQL (freeware) 7.2.0.2922 Get the following error while trying to compare a replicated table content on master and slave: Unknown type found during storing data. Type: System.UInt64 The...

Toad for MySQL (freeware) 7.2.0.2922

Get the following error while trying to compare a replicated table content on master and slave:

Unknown type found during storing data. Type: System.UInt64

The following is the table definition, identical on master and slave:

CREATE TABLE `inmemoryconfigproperties` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `MODULE_NM` varchar(64) DEFAULT NULL,
  `FUNCTION_NM` varchar(64) DEFAULT NULL,
  `NAME` varchar(128) NOT NULL,
  `VALUE` varchar(1024) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `inmemoryconfigproperties_unique_index_name` (`NAME`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

85 0 / Create an account to join the discussion.
pascal_jay_828
Follow / 3 Apr 2014 at 11:44am / Toad for MySQL
Latest post by on 8 Aug 2014 at 12:32pm

Bug: Manual submit auto submits when statement is executed again

Expand content
Hey there. I've found a bug (?) in Toad for MySQL 4.6.0.531 and 7.0.0.2038: Manual submit auto submits when statement is executed again. Steps to reproduce: 1. Select "Manually submit row...

Hey there.


I've found a bug (?) in Toad for MySQL 4.6.0.531 and 7.0.0.2038:  Manual submit auto submits when statement is executed again.

Steps to reproduce:

1. Select "Manually submit row changes as batch" in "Tools->Options->Environment->Grid->Submitting Changes to the Database".

2. SELECT * FROM any.table; -> Change a value but do not submit the change

3. Re-execute SELECT * FROM any.table; (in the same editor)

4. Now the previous change to the value has been submitted without hitting the "Submit" button at the bottom the grid.

Hope you can fix this behaviour. Thanks!

Best regards.

Pascal

Unanswered 225 1 / Create an account to join the discussion.
pstein
Follow / 21 Sep 2011 at 12:27pm / Toad for MySQL
Latest post by on 8 Aug 2014 at 12:31pm

Can I download older (v5.x) versions of Toad for MySQL?

Expand content
I prefer to use older version (v5.x) of Toad for MySQL. Can I download them somewhere? on the main download page there is only the newest GA version available. Peter

I prefer to use older version (v5.x) of Toad for MySQL.

Can I download them somewhere?
on the main download page there is only the newest GA version available.

Peter

1358 5 / Create an account to join the discussion.
andyd01
Follow / 6 Jan 2011 at 1:49pm / Toad for MySQL
Latest post by on 7 Aug 2014 at 5:38pm

Toad Hangs - has to be terminated

Expand content
I have an ongoing problem with Toad for MySql where if I leave it running, but don't use it for a period of time, when I come back to it it's basically hung. I can't do anything in the software...

I have an ongoing problem with Toad for MySql where if I leave it running, but don't use it for a period of time, when I come back to it it's basically hung.  I can't do anything in the software, and I can't quit and I have to terminate the process.  This happens several times a day.

Running on Windows 7 x64.  Anybody know what's going on and how to fix this/

2491 19 / Create an account to join the discussion.
John Wilson
Follow / 31 Jul 2014 at 5:12pm / Toad for MySQL
Latest post by on 1 Aug 2014 at 11:08am

Toad for MySql 7.2.0.20.22 (freeware) not connecting to database

Expand content
Hi I am a novice using Toad so any help resolve this issue will be very welcome. Just yesterday my Toad has decided not to connect to my database. It is giving the following error message: System.Net...

 Hi I am a novice using Toad so any help resolve this issue will be very welcome.

Just yesterday my Toad has decided not to connect to my database. It is giving the following error message:

System.Net.Sockets.SocketException
The system detected an invalid pointer address in attempting to use a pointer argument in a call
Stack Trace:
   at System.Net.Sockets.Socket.GetSocketOption(SocketOptionLevel optionLevel, SocketOptionName optionName)
   at System.Net.Sockets.NetworkStream.get_ReadTimeout()
   at MySql.Data.MySqlClient.TimedStream..ctor(Stream baseStream)
   at MySql.Data.MySqlClient.MySqlStream..ctor(Stream baseStream, Encoding encoding, Boolean compress)
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at Quest.Toad.MySQL.MySQLConnection.DoBeforeConnect()
   at Quest.Toad.Db.Connection.Connect(Boolean notify)
   at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

I have uninstalled and reinstalled and still get the same message.

The MySql server is running as I can connect to it using my Alpha Any Where and MySql Workbench but I mych prefer to use Toad.

Can anybody help resolve this.

Thanks in advance

John Wilson

Unanswered 346 1 / Create an account to join the discussion.