Toad for MySQL - General

Community Discussion

jakpan
Follow / 30 Jan 2015 at 5:06pm / Toad for MySQL

Connecting to MySQL Server on Ubuntu running on a VirtualBox

Expand content
Hi, 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...

Hi,

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

Host: 192.168.2.70

User: john

Password: *******

Database: mysql

Port: 3306

 

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.

Unanswered 24 0 / Create an account to join the discussion.
davek
Follow / 21 Jun 2014 at 9:39pm / Toad for MySQL
Latest post by on 23 Jan 2015 at 8:43pm

Compare Schema - ERROR: Select command denied to user 'xxxx'...

Expand content
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...

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 use
My DB Admin Skill Level: Novice
Version of Toad: 7.2.0.2922
Toad Feature I am have issues with: Compare Schema
Error being encountered: Select command denied to user 'xxxx'@'yyyyy' for table 'db' Quest.Compare.Schema.MySQL.DBModel
Prior to posting I made sure (using Toad)...

  1. I have successfully connected to each of the DBs for which I am trying to compare the schemas for.
  2. I have been able to successfully run queries against each of the targeted DBs.
  3. I have verified the stored user name and password for each connection.
  4. I have verified that the UID has select authority for each of the DBs.  Actually, the UID has all permissions.
  5. I have verified that remote connection is authorized for the UID on each DB.
  6. I have reviewed the list of tables within each of the target DBs....  neither has a table named 'db'.

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!

Unanswered 730 5 / Create an account to join the discussion.
Mr Frosch
Follow / 20 Jan 2015 at 7:33pm / Toad for MySQL
Latest post by on 21 Jan 2015 at 11:31pm

Comparison errors: Datatype is not supported

Expand content
Software vsersion: Toad for MySQL Freeware 7.3.1.3290 (released 2014-12-16) Feature: Data Compare I'm trying to compare two databases with identical schemas (one was originally generated from a...

Software vsersion:  Toad for MySQL Freeware 7.3.1.3290 (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:

  • Some columns of source table have datatypes that are not compatible with corresponding columns of target table.
    • Datatype "binary(32)" is not supported.
    • Datatype "varbinary(255)" is not supported.

Is this a bug, or is there something wrong with my databases?

Unanswered 88 1 / Create an account to join the discussion.
downsoft
Follow / 21 Jan 2015 at 2:46pm / Toad for MySQL
Latest post by on 21 Jan 2015 at 8:23pm

Error message series : Toad for mysql is unusable.

Expand content
Hello, I have a new installation on Win7 64bit. Mysql v5.6.22.0 (x86): ok I install Toad for MySQL v7.3.1.3290 (x86) on the same computer: no problem with the installation. When I open Toad for mysql...

Hello,

I have a new installation on Win7 64bit.
Mysql v5.6.22.0 (x86): ok

I install Toad for MySQL v7.3.1.3290 (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.

example:

System.Security.VerificationException
Operation 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()

163 4 / Create an account to join the discussion.
pstein
Follow / 17 Dec 2014 at 7:32am / Toad for MySQL
Latest post by on 7 Jan 2015 at 10:34pm

Settings folder moveable to another user customized directory?

Expand content
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...

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

D:\databases\toadmysql\mysettings\

Is this possible?

If not could this option be included in the next release?

Thank you

Peter

Answered 158 1 / Create an account to join the discussion.
thamarai
Follow / 4 Jan 2015 at 1:55pm / Toad for MySQL

I have a doubt in inserting values in mysql

Expand content
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...

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

92 0 / Create an account to join the discussion.
dh2014
Follow / 18 Dec 2014 at 5:10am / Toad for MySQL

Getting odd error upon loading a file and not sure how to get rid...

Expand content
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...

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 ?

Unanswered 251 0 / Create an account to join the discussion.
blackdesign30
Follow / 16 Dec 2014 at 6:59pm / Toad for MySQL

Backup for data bases.

Expand content
Saludos Amigos! deseo encontrar un método de como programar Backups automáticos programados a ¨X¨ hora . como puedo hacer esto usando TOAD , Gracias!!

Saludos Amigos! deseo encontrar un método de como programar Backups automáticos  programados a ¨X¨ hora. como puedo hacer esto usando TOAD, Gracias!! 

Unanswered 143 0 / Create an account to join the discussion.
Steven Soto
Follow / 16 Dec 2014 at 6:58pm / Toad for MySQL

Toad for MySQL 7.3.1 is released!

Expand content
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!

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!

453 0 / Create an account to join the discussion.
DaveInFL
Follow / 9 Dec 2014 at 6:47pm / Toad for MySQL
Latest post by on 15 Dec 2014 at 11:20pm

Importing CSV files ignores unique index

Expand content
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...

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?

188 1 / Create an account to join the discussion.
deeturagit
Follow / 27 Nov 2014 at 5:42am / Toad for MySQL
Latest post by on 15 Dec 2014 at 4:27pm

Dell Support and uploading Bug information

Expand content
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...

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 

Cheers

362 4 / Create an account to join the discussion.
GSM
Follow / 15 Dec 2014 at 2:22pm / Toad for MySQL

download of 9.7.2.5

Expand content
I have a licenced copy of "toad for oracle professional 9.7.2.5". I have the media for 7.1 but do not have the downloaded update for this to take it to 9.7.2.5. If there anywhere I can download...

I have a licenced copy of "toad for oracle professional 9.7.2.5". I have the media for 7.1 but do not have the downloaded update for this to take it to 9.7.2.5.

If there anywhere I can download this version ?

 

 

Unanswered 136 0 / Create an account to join the discussion.
anil.bezawada
Follow / 4 Dec 2014 at 1:25am / Toad for MySQL
Latest post by on 4 Dec 2014 at 2:06am

issue with TOAD for MYSQL while connecting to MYSQL 5.7 or 5.6

Expand content
Hi Friends, 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....

Hi Friends,

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.

ERROR1:

System.IO.FileNotFoundException
Could not load file or assembly 'MySql.Data, Version=6.8.3.0, 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=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

ERROR2:

Quest.Toad.Exceptions.BaseException
Encountered exception while processing exception

System.IO.FileNotFoundException
Could not load file or assembly 'MySql.Data, Version=6.8.3.0, 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)

System.IO.FileNotFoundException
Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

thanks

AK.

311 1 / Create an account to join the discussion.
don-psu
Follow / 9 May 2010 at 12:05am / Toad for MySQL
Latest post by on 1 Dec 2014 at 11:58pm

Access denied for user . . . . . can not connect

Expand content
Using TOAD on WinXP client and can not connect to mysql on remote linux (redhat) server. Error: Access denied for user 'dlw27'@clientname . Why does error msg show 'client' machine name...
Using TOAD on WinXP client and can not connect to mysql on remote linux (redhat) server. Error: Access denied for user 'dlw27'@clientname. Why does error msg show 'client' machine name instead of host server name I typed in?
Verified dlw27@servername valid user in mysql (user table within mysql DB).
Verified port 3306 listening for TCP (used portqry utility).
1155 5 / Create an account to join the discussion.
kulasart
Follow / 13 Aug 2014 at 11:10am / Toad for MySQL
Latest post by on 28 Nov 2014 at 1:19pm

[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

500 3 / Create an account to join the discussion.
cesarf
Follow / 27 Nov 2014 at 7:31pm / Toad for MySQL

Syntax highlighting error?

Expand content
hi all, i've a problem with Toad 7.3.0.3250 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...

hi all,

i've a problem with Toad 7.3.0.3250 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( "

select *

  from myTable

 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?

br,

cesar.

145 0 / Create an account to join the discussion.
Toad_User_123
Follow / 21 Nov 2014 at 10:51am / Toad for MySQL
Latest post by on 27 Nov 2014 at 7:12am

Unable to connect remote MySQL database.

Expand content
I am Unable to connect Remote MySQL database using " Toad for MySQL ,Version 7.2.0.2922 ". Server is listening on port 3306.I can access the same database remotely through MySQL Workbench 6...

I am Unable to connect Remote MySQL database using " Toad for MySQL ,Version 7.2.0.2922 ".

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.

                 

277 1 / Create an account to join the discussion.
SQL_Jockey
Follow / 15 Nov 2012 at 11:00pm / Toad for MySQL
Latest post by on 24 Nov 2014 at 11:24pm

Unresponsive TOAD for MySQL

Expand content
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...

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.


Thanks!

1990 19 / Create an account to join the discussion.
imal
Follow / 21 Nov 2014 at 8:56pm / Toad for MySQL

Shortcut for 'Edit SQL' or File>New>Editor menu command...

Expand content
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'...

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: 7.3.0.3250

Thanks!

165 0 / Create an account to join the discussion.
armzak6
Follow / 11 Nov 2014 at 1:05pm / Toad for MySQL
Latest post by on 18 Nov 2014 at 11:52pm

Connection error question

Expand content
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...

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??

404 11 / Create an account to join the discussion.