Toad for MySQL - General

Community 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 59 0 / Create an account to join the discussion.
pstein
Follow / 17 Dec 2014 at 7:32am / Toad for MySQL

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

Unanswered 49 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 43 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!

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

90 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

213 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 59 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.

149 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).
1014 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

424 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.

91 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.

                 

165 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!

1875 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!

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

312 11 / Create an account to join the discussion.
johnantoniou
Follow / 18 Nov 2014 at 6:40am / Toad for MySQL

Massive Traffic

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

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?

thanks 

Unanswered 122 0 / Create an account to join the discussion.
aquitta
Follow / 12 Nov 2014 at 9:00pm / Toad for MySQL
Latest post by on 12 Nov 2014 at 9:41pm

Toad for MySql to recognize my.ini ?

Expand content
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: [mysqld] plugin...

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:

[mysqld]
plugin-load=authentication_windows.dll

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.PLUGINS
where plugin_name like '%mysql%';

I do get that the plugin is there and installed:

PLUGIN_NAMEPLUGIN_VERSIONPLUGIN_STATUSPLUGIN_TYPEPLUGIN_TYPE_VERSION
mysql_native_password 1.0 ACTIVE AUTHENTICATION 1.0
mysql_old_password 1.0 ACTIVE AUTHENTICATION 1.0

.

.

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?

Thanks

Andre

Unanswered 117 1 / Create an account to join the discussion.
alexander.sitte
Follow / 22 Oct 2014 at 3:00pm / Toad for MySQL
Latest post by on 12 Nov 2014 at 2:55pm

[Bug] Autocomplete disappearing instantly (7.3 Stable)

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

Hi,

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?

Unanswered 146 1 / Create an account to join the discussion.
Henrik Johnson
Follow / 12 Nov 2014 at 1:23am / Toad for MySQL

Old Toad for MySQL installers

Expand content
For people who require old installers they are now available at. Toad for MySQL 6.0.1.1723 Toad for MySQL 6.3.0.642 Toad for MySQL 6.7.0.1524 Toad for MySQL 7.0.2038 Toad for MySQL 7.2.0.2922...

For people who require old installers they are now available at.

Toad for MySQL 6.0.1.1723

Toad for MySQL 6.3.0.642

Toad for MySQL 6.7.0.1524

Toad for MySQL 7.0.2038

Toad for MySQL 7.2.0.2922

Enjoy!

130 0 / Create an account to join the discussion.
Henrik Johnson
Follow / 29 Mar 2012 at 8:20pm / Toad for MySQL
Latest post by on 11 Nov 2014 at 8:54pm

Toad for MySQL 6.3 is released!

Expand content
The new version of Toad for MySQL 6.3 is now available for immediate download from www.toadformysql.com . Contains improved user interface for automation, query builder, editor and adds integration to...

The new version of Toad for MySQL 6.3 is now available for immediate download
from www.toadformysql.com .

Contains improved user interface for automation, query builder, editor and adds
integration to Sharepoint. Also features improvements in document recovery, Code
Completion, Code Snippets, Report Designer, Project Manager, FTP and
performance.

/Henrik Johnson

Quest Software

601 2 / Create an account to join the discussion.