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 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
With Toad for MySQL 7.3 I am now unable to connect to a DB (ssh) which I was able to connect to with the 7.2 version and no details have changed. I keep getting the following error:
"Attempted to read past the end of the stream".
Can someone please help to resolve this issue
taking too much time to execute sql join query in toad for mysql
I created a procedure and when I went to view it in the object explorer tab for procedures, it wasn't visible in the list. This is the only procedure in this particular database, but if I do a select from information_schema.routines it shows up, along with the list of procedures in other databases.I've dropped and created the procedure a number of times, each time it says executed successfully, and shows up in information_schema, just not in the object explorer.
Hi, i want to download an older version of Toad for MySql. I installed the last version but when i try to connect to one of our databases it shows the message "Authentication with old password no longer supported, use 4.1 style passwords". Older version of Toad has no problem connecting to the database
What is the last version when old password where supported and if possible to have a download link please?
Is there any way to change the colors used in the Database Diagrams? With the default color scheme, I cannot even read the names of the tables on a printout.
When extract DDL from a schema, Is there a way to separate between the table and its foreign keys?
I would want the create Foreign Keys to be separate since I would want to create all the tables first
and then create all the foriegn keys without worrying that FK create may fail since the ref table was not created first ?
In a very specific case, Toad for MySQL will prompt for variables when it should not, and then return an incorrect result. The following test will reproduce the bug
Execute the following SQL
SELECT 'Test \' to show incorrect variable prompt?';
Test ' to show incorrect variable prompt?
Prompt for a variable named @f0, which should not be shown at all, and then regardless of whether you click OK or Cancel, and regardless of whether or not you enter a value for the variable the following result (the question mark replaced with "@f0")
Test ' to show incorrect variable prompt@f0
Note that if you use two quotes instead of \' to escape the quote then Toad works correctly, so
SELECT 'Test '' to show incorrect variable prompt?';
Gives the expected result:
Hi there, I hope you can help, as I'm almost pulling my hair out!!I've set up a MySQL database through my host tsohost and tried to connect to it via TOAD but am constantly getting the error message "Unable to connect to any of the specified MySQL hosts."I've checked all my details and entered them correctly. I've also checked that my Port 3306 is open. I'm at a loss as to what is wrong... These are the details I have from my host: Hostname: 10.168.1.** (also tried the default localhost)Connection Method: TCPDatabase Version: MySQL 5Database Name: amd_****Database Username: amd_****PAssword: ****Can you please help?
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)
How do I uninstall if the entry is missing from Programs and Features?
I found and carefully removed everything Toad from the Registry, it took some hours and worked, but I bet there’s an easier way.
mit MySQL Workbench funktioniert die Verbindung, bitte um hilfe:
Fehler bei Handshake wegen eines unerwarteten Paketformats.
bei System.Net.Security.SslState.StartReadFrame(Byte buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)
bei System.Net.Security.SslState.StartReceiveBlob(Byte buffer, AsyncProtocolRequest asyncRequest)
bei System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
bei System.Net.Security.SslState.StartSendBlob(Byte incoming, Int32 count, AsyncProtocolRequest asyncRequest)
bei System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte buffer, AsyncProtocolRequest asyncRequest)
bei System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)
bei System.Net.Security.SslStream.AuthenticateAsClient(String targetHost, X509CertificateCollection clientCertificates, SslProtocols enabledSslProtocols, Boolean checkCertificateRevocation)
bei MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
bei Quest.Toad.Db.Connection.Connect(Boolean notify)
On the 'new compare'-window if I try to select a database from the dropdown error popup says: "Keyword not supported 'ts;pooling' Devart.Data.MySql "
This used to work in previous versions.
Toad for MySQL version: 18.104.22.16890
hi - recently when i save a file in toad - other users cannot view the files that i save. When i go to view the files by going thorugh my computer into the folder they are saved in they do not appear. however when i log into toad i can see them.
has anyone else experienced this issue?
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
All documentation online is for Toad for DB2 and the menus they talk about are nonexistent in Toad for MYSQL. Why is the most basic command so obtuse to perform?
Working on Version: 22.214.171.12490.
I am looking at 2 very different values on a table I'm trying to get a true row count on.
In Toad when I select the TABLE and then on the right side of my display I have multiple tabs such as Columns, Data Information, Indexes, Constraints , etc. Under the Information tab there is a Rows value that shows: 1952388
However, when I execute a SELECT COUNT(*) FROM tableA I see a COUNT(*) = 731826.
What is the difference? Which one is the true row count?
Any help/direction would be appreciated. Thank you.
I have simple MyISAM table for search, where I indexed fulltext search ion "search_text" for search text table structure : CREATE TABLE IF NOT EXISTS `product_search` ( `dept_id` int(11) unsigned NOT NULL DEFAULT '0', `product_id` int(11) NOT NULL DEFAULT '0', `search_text` longtext, FULLTEXT KEY `search` (`search_text`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;Query : SELECT p.product_id , p.dept_id FROM product_search p WHERE (MATCH(search_text) AGAINST('fathers day') AND 1 ) GROUP BY product_id LIMIT 50**With group by** it took around **10-12** seconds**Without group by** it took **0.0086** secondsWhen I have checked the query with explainquery explain : id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE p fulltext search search 0 1 Using where; Using temporary; Using filesortWhat should I do in this case?
I change my web server and i need export my database for re-import in my phpmyadmin server. But how make to let only 1 file?