You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Toad for MySQL great and have the most points for this month!
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??
I have re-posted this to try and get the answer posted for others who are still having this issue.System.OutOfMemoryExceptionException 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()
Hi,When I run some big queries (>20MB sql script) Toad throws an out of memory error message. System.OutOfMemoryExceptionException 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 188.8.131.522
Could anyone help me about this?
Thanks in advance
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.
After installer the Toad for MySQL 7.2 show the error message bellow.
Can anybody help-me?
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!
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?
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 184.108.40.20692, 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 1INTO @VAR1' at line 1.
Any suggestions on how to solve this issue?
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.NullReferenceExceptionMessage : 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
Is it possible to configure Toad for MySQL (Freeware) 220.127.116.1122 to use more than 4G physical memory?
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
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...
The new stable version of Toad for MySQL 7.2 is now available for immediate download.
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.ArgumentNullExceptionValue 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)
Toad for MySQL (freeware) 18.104.22.16822
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;
I've found a bug (?) in Toad for MySQL 22.214.171.1241 and 126.96.36.1998: 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!
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 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/
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.SocketExceptionThe system detected an invalid pointer address in attempting to use a pointer argument in a callStack 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