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 get this error which appears to reference a local host ip address and port 22 upon loading, 192.1...... :22
My connection manager has two entries, one local mysql database and a remote db both of which are valid.
The file is to compare local db with remote db and synchronize but because I get this error I have to redo the setup for the sync on the one table.
Any ideas or why ?
As far as I can see Toad stores its settings, layouts, session,.... preferences always in
C:\Users\P\AppData\Roaming\Quest Software\Toad for MySQL freeware 7.2\
I would prefer to store them in another folder where I can backup it better.
If possible in a subfolder of the installation folder e.g. in
Is this possible?
If not could this option be included in the next release?
Saludos Amigos! deseo encontrar un método de como programar Backups automáticos programados a ¨X¨ hora. como puedo hacer esto usando TOAD, Gracias!!
A new 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!
I am importing a CSV file that has roughly 12 columns and a little under 200 rows, so nothing large.
It's my first time using the Import tool under TOAD and although it seems to work fine it also seems to completely ignore NOT NULL constraints and UNIQUE INDEX.
For example, I have a table defined as follows:
CREATE TABLE `addresses_stg` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cust_email` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `line1` varchar(255) NOT NULL, `line2` varchar(255) DEFAULT NULL, `city` varchar(255) NOT NULL, `county` varchar(255) NOT NULL, `state` varchar(255) NOT NULL, `zip` int(11) NOT NULL, `billing` varchar(255) DEFAULT NULL, `delivery` varchar(255) DEFAULT NULL, `addr_notes` text, `error_msg` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE UNIQUE INDEX cust_addr_u1 on addresses_stg (cust_email,name,line1,line2,city,county,state,zip);
Based on the above, rows that have null email addresses or that are not unique across cust_mail, name, line1, line2, city, county, state and zip sould NOT load at all. But they do. Why is that? What is the point of having a NOT NULL constraint and/or unique index if the import ignores them? Is this normal behavior?
Ok this is a bit of a rant but it seems Toad MySQL has dropped to the bottom of the pit with the move to Dell, pity really.
I had a crash thought I would send in some data to help fix the product. Dont bother wasting your time as you cant create a support request and there appears no other way to securely upload any support data. If there is its well hidden and in fact when you select Toad for MySQL all you get given is a choice to watch a nice video to configure and install the software yah.
Sorry Quest did a better job
If anyone has any ideas on uploading support data happy to hear
I have a licenced copy of "toad for oracle professional 18.104.22.168". I have the media for 7.1 but do not have the downloaded update for this to take it to 22.214.171.124.
If there anywhere I can download this version ?
recently i installed TOAD FOR MYSQL on WINDOWS 7 64 bit, after installation when i am trying to connect MySQL 5.7 , its not allowing me to connect and it pop-up with below error message.
System.IO.FileNotFoundExceptionCould not load file or assembly 'MySql.Data, Version=126.96.36.199, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.Stack Trace: at Quest.Toad.MySQL.MySQLConnection.CreateConnection() at Quest.Toad.MySQL.MySQLConnection.OpenInitialTestConnection() at Quest.Toad.MySQL.MySQLConnection.DoBeforeConnect() at Quest.Toad.Db.Connection.Connect(Boolean notify) at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()
System.IO.FileNotFoundException Could not load file or assembly 'MySql.Data, Version=188.8.131.52, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.
Quest.Toad.Exceptions.BaseExceptionEncountered exception while processing exception
System.IO.FileNotFoundException Could not load file or assembly 'MySql.Data, Version=184.108.40.206, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified. Stack Trace: at Quest.Toad.MySQL.MySQLExceptionWrapper.HandleException(Object sender, ExceptionEventArgs args) at Quest.Toad.Notification.NotificationManager.ExceptionDelegate(Object sender, ExceptionEventArgs args)
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
i've a problem with Toad 220.127.116.1150 freeware for MySQL configured as mimicking MSSMS in Windows, related to strings highlighting.
i use a lot of dSql and noticed that text coloring is wrong when new lines are involved like this:
create procedure myProc ( myStrVal1, myStrVal2 );
set myExeStr = concat( "
where myStrFld1 = '" , myStrVal1, "'
and myStrFld2 = '" , myStrVal2 );
coloring is wrong, almost inverted:
if you move the select clause to the previous line, following the double quote, color is ok but just for the first line, i mean, coloring will continue failing after end of line.
set myExeStr = concat( "select *
i'm Toad rookie but a very long time sql server developer, looking for the right gui to work with MySql...
i've to do a lot of optimization in dSql in USPsto avoid " like '%' " kind of WHERE constructions
after testing a lot of freeware and commercial apps, i almost feel in developer's heaven when discovered your look alike configuration (you should highlight that on your overviews).
can you fix it?
I am Unable to connect Remote MySQL database using " Toad for MySQL ,Version 18.104.22.16822 ".
Server is listening on port 3306.I can access the same database remotely through MySQL Workbench 6.1 but can't access through Toad.
Also firewall is not blocking access to server.
I have attached error screen and telnet response on port 3306.Please help me to resolve problem.
Is it just me???
Whenever I leave my Toad for MySQL open on my desktop for a long time it becomes somewhat non-responsive.
"A long time" is roughly 1 hour, but I'm not sure exactly.
"somewhat non-responsive" means that I can type in the editor, click on menus/toolbars, but when I try to execute a query the program does not respond.
My work around is to use Windows Task Manager and end task the TOAD application.
I do this several times a day.
Any ideas, help, and/or workarounds would be appreciated.
I really enjoy using this product, but I'm really getting tired of using task manager.
Can someone explain to me how i can open a new Script editor via a keyboard shortcut? This is driving me insane. I tried to set my own shortcut using Tools>Options>Keyboard but 'New Script' command is not listed there. Hopefully i am missing something?
Toad for MySQL version: 22.214.171.12450
Just downloaded Toad for Mysql when I try to connect I get the following error:
"Unable to connect to any of the specified MySQL hosts."
release notes say you have to download Toad 7.0 to correct this error. Only Toad 7.3 is available for download, how do you find Toad for Mysql 7.0 for download??
There was an incident few days after i installed and used the MySql Version of ToadWorld. I am not telling that the issue is for sure related with this software (which i like). I used yesterday this software to synchronize the remote DB with my local DB. Early in the morning i synchronized the DB. After 2-3 hours, I tried to synchronized my local DB again, in order to check some settings of the software. It failed after 2-3 minutes due to connection error, and then i completely closed the software. Few hours later, the connection with the server was almost impossible. It seems that there was much traffic!!! There were not connections on the remote logs of MySql Server, during the time of the heavy traffic. Is there any chance that responsible for this incident was this software?
You can probably guess from the question that I'm new to this environment, so please bear with me.
I have my.ini including a reference to the windows authentication plugin, as below:
I've rebooted both my desktop and the server.
I have this both on my Windows 8 client install and the Windows Server 2012 server install. When I connect to the server and list plugins via the command below:
select *from information_schema.PLUGINSwhere plugin_name like '%mysql%';
I do get that the plugin is there and installed:
but when I try to create a login (below), it tells me that the plugin is not installed.
CREATE USER cust_login IDENTIFIED WITH authentication_windows AS 'domain\\MyWindowsName';
Plugin 'authentication_windows' is not loaded
Is my connection to MySQL using the my.ini file? If not, how can I set that in TOAD?
I have downloaded Taod for MySQL 7.3 and have a problem with the Autocomplete feature.
1. It does not pop up automatically. For example, when I type a table alias followed by a period(.) I would expect that autocomplete shows a list of columns of the table.
2. If I activate the autocomplete popup with CTRL+Period it pops up quickly and disappears right away. I am not able to select anything from it.
Is there a fix for this?
For people who require old installers they are now available at.
Toad for MySQL 126.96.36.1993
Toad for MySQL 188.8.131.522
Toad for MySQL 184.108.40.2064
Toad for MySQL 7.0.2038
Toad for MySQL 220.127.116.1122
The new version of Toad for MySQL 6.3 is now available for immediate downloadfrom www.toadformysql.com .Contains improved user interface for automation, query builder, editor and addsintegration to Sharepoint. Also features improvements in document recovery, CodeCompletion, Code Snippets, Report Designer, Project Manager, FTP andperformance./Henrik JohnsonQuest Software