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 Toad running on a Windows 7 machine (Host) and MySQL 5.6 running on Unbuntu on this same machine as a gues via Virtualbox.. I have DHCP on the guest disabled and static IPs assigned accordingly to match the host machine. The Virtual box iadaptor is configured as Bridge. I can ping from the guest to host and vice versa, but I can't get Toad to connect to the MySQL. I keep getting the error "The requested name is valid, but no data of the requested type was found"
Connection Type: TCP
I've also commented out bind address and skip-external-locking in the my.cnf file on the guest machine.
What am I doing wrong and how can I get it to work? Any help will be greatly appreciated. Thanks.
I am so thrilled to have found Toad and this forum!!!
First, a disclaimer: I am a novice at DB administration and everything I know is self taught through forums just like this one. That learning is out of necessity, but thank God I enjoy a challenge! My question may be "basic" and I apologize to the experts that may find my inquiry frustratingly simple. I have searched the forum and couldn't find the answer and thus, finally asking for help.
My Experience Level with Toad: maybe 6 hours of useMy DB Admin Skill Level: NoviceVersion of Toad: 188.8.131.5222Toad Feature I am have issues with: Compare SchemaError being encountered: Select command denied to user 'xxxx'@'yyyyy' for table 'db' Quest.Compare.Schema.MySQL.DBModelPrior to posting I made sure (using Toad)...
I also reviewed the "How to create multi-schema comparison" posted within the forum but that didn't help. As soon as I execute the compare, Toad returns the stated error. I suspect this is something truly simple and elementary but I, as I mentioned, I am a novice and would truly appreciate any guidance from anyone willing to point me in the right direction.
Thanks in advance!
Software vsersion: Toad for MySQL Freeware 184.108.40.20690 (released 2014-12-16)
Feature: Data Compare
I'm trying to compare two databases with identical schemas (one was originally generated from a schema and data dump of the other), but on some columns I get these errors:
Is this a bug, or is there something wrong with my databases?
I have a new installation on Win7 64bit.Mysql v220.127.116.11 (x86): ok
I install Toad for MySQL v18.104.22.16890 (x86) on the same computer: no problem with the installation.
When I open Toad for mysql, I have a series of error messages.
Toad for mysql is unusable.
How can I do?
I can not find anywhere the v7.5 beta or earlier version, the v6.7.
System.Security.VerificationExceptionOperation could destabilize the runtime.Stack Trace: at DevExpress.XtraEditors.ButtonPanel.BaseButtonsPanelViewInfo.SortButtonListCore(List`1 positiveList) at DevExpress.XtraEditors.ButtonPanel.BaseButtonsPanelViewInfo.SortButtonList(BaseButtonCollection buttons) at DevExpress.XtraEditors.ButtonPanel.BaseButtonsPanelViewInfo.EnsureButtons(Graphics g, Rectangle bounds, BaseButtonPainter buttonPainter) at DevExpress.XtraEditors.ButtonPanel.BaseButtonsPanelViewInfo.Calc(Graphics g, Rectangle bounds) at DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcButtons(BaseTabPageViewInfo info, Rectangle bounds) at DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcPageViewInfo(BaseTabRowViewInfo row, BaseTabPageViewInfo info, Point& topLeft) at DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcRowsViewInfo(Rectangle rect, Size buttonsSize) at DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcRowsViewInfo(Rectangle rect) at DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcViewInfo(Graphics g, Rectangle r, TabHeaderLocation hLocation) at DevExpress.XtraTab.ViewInfo.BaseTabControlViewInfo.CalcViewInfo(Rectangle bounds, Graphics g) at DevExpress.XtraBars.Docking2010.Views.Tabbed.DocumentGroupInfo.CalcCore(Graphics g, Rectangle bounds) at DevExpress.XtraBars.Docking2010.Views.BaseElementInfo.DevExpress.XtraBars.Docking2010.Views.IBaseElementInfo.Calc(Graphics g, Rectangle bounds) at DevExpress.XtraBars.Docking2010.Views.Tabbed.TabbedViewInfo.CalcGroups(Graphics g, Rectangle bounds, Int32 intervals, DocumentGroup groups, Int32 splitLengths, Rectangle& rects) at DevExpress.XtraBars.Docking2010.Views.Tabbed.TabbedViewInfo.CalculateCore(Graphics g, Rectangle bounds) at DevExpress.XtraBars.Docking2010.Views.BaseViewInfo.Calc(Graphics g, Rectangle bounds) at DevExpress.XtraBars.Docking2010.Views.BaseView.EnsureLayoutCalculated(GraphicsCache cache) at DevExpress.XtraBars.Docking2010.DocumentManager.PatchChildrenCore() at DevExpress.XtraBars.Docking2010.DocumentManager.PatchActiveChildren() at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
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?
I am having more than 6 fields in my table while I am giving inserting values coding I am getting error while i reficted that error and giving the values the dob column gets truncated error is shown in the table.pls tell how to receive that erroe
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 ?
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 22.214.171.124". I have the media for 7.1 but do not have the downloaded update for this to take it to 126.96.36.199.
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=188.8.131.52, 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=184.108.40.206, 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=220.127.116.11, 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 18.104.22.16850 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 22.214.171.12422 ".
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: 126.96.36.19950
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??