Toad for MySQL - General

Community Discussion

savoym
Follow / 3 Mar 2015 at 3:56pm / Toad for MySQL

Difference between Rows value under the Information tab for the selected...

Expand content
Working on Version: 7.3.1.3290. 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...

Working on Version: 7.3.1.3290.

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.

36 0 / Create an account to join the discussion.
simarjeet
Follow / 12 Feb 2015 at 10:23am / Toad for MySQL
Latest post by on 27 Feb 2015 at 7:21pm

how I can speed up mysql query with group by

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

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** seconds

When I have checked the query with explain
query 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 filesort

What should I do in this case?



671 3 / Create an account to join the discussion.
lucho
Follow / 25 Mar 2014 at 12:34pm / Toad for MySQL
Latest post by on 27 Feb 2015 at 2:04am

Dump SQL Database for re-import in phpmyadmin

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

Hi everyone,

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? 

1015 2 / Create an account to join the discussion.
NioZero
Follow / 12 Feb 2015 at 7:17pm / Toad for MySQL
Latest post by on 26 Feb 2015 at 7:01pm

Download Older version

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

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?

Unanswered 745 4 / Create an account to join the discussion.
Scott M. Sanders
Follow / 25 Feb 2015 at 6:47pm / Toad for MySQL

Uninstall Manually

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

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.

Unanswered 174 0 / Create an account to join the discussion.
Enric_Naval
Follow / 25 Feb 2015 at 10:18am / Toad for MySQL

"Format code" doesn't understand SEPARATOR?

Expand content
"Format code" refuses to format any query containing GROUP_CONCAT + SEPARATOR: For example: SELECT level , GROUP_CONCAT(code SEPARATOR ' ' ) FROM Logs GROUP BY level; SEPARATOR...

"Format code" refuses to format any query containing GROUP_CONCAT + SEPARATOR:

For example:

SELECT
level
, GROUP_CONCAT(code SEPARATOR ' ')
FROM Logs
GROUP BY level;

SEPARATOR is valid since at least MySQL 4.1: http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html#function_group-concat

This bug exists since beta 7.0 http://www.toadworld.com/products/toad-for-mysql/toad_for_mysql_beta_program/f/90/t/20717.aspx

Unanswered 163 0 / Create an account to join the discussion.
Alex Canário
Follow / 13 May 2014 at 1:28am / Toad for MySQL
Latest post by on 16 Feb 2015 at 11:18pm

Quest.Licensing.LicenseException

Expand content
Hi Guys After installer the Toad for MySQL 7.2 show the error message bellow. Can anybody help-me? Thanks Alex Canario

Hi Guys

After installer the Toad for MySQL 7.2 show the error message bellow.

Can anybody help-me?


Thanks

Alex Canario

2377 20 / Create an account to join the discussion.
olivierdemeijer
Follow / 7 Oct 2014 at 8:20pm / Toad for MySQL
Latest post by on 12 Feb 2015 at 5:18am

SSH tunnel Connection and mysql_clear_password.dll

Expand content
Hi Communiity, I set up a SSH tunnel connection following these steps , which works fine, except that TOAD complains about [ Authentication method 'mysql_clear_password' not supported by any...

Hi Communiity,

I set up a SSH tunnel connection following these steps, which works fine, except that TOAD complains about [Authentication method 'mysql_clear_password' not supported by any of the available plugins]

I fixed the very same problem with HeidiSQL by putting mysql_clean_password.dll and dialog.dll in a plugin folder, but I can't figure where to put those two dll's in TOAD in order to make it find them.

Can  anyone help ? Looks like most of the dll are somehow "declared"  in *.pck file if it can help.

Thank in advance !

942 1 / Create an account to join the discussion.
savoym
Follow / 10 Feb 2015 at 2:19pm / Toad for MySQL

Question on column lists

Expand content
I have what I hope is an easy question. I would like to know how to TURN OFF the column list automatically showing up after I key in SELECT and press the keyboard spacebar? I would like to control what...

I have what I hope is an easy question.  I would like to know how to TURN OFF the column list automatically showing up after I key in SELECT and press the keyboard spacebar?  I would like to control what shows up in the editor.  Hope this makes sense.  Any help would be appreciated.

Thanks.

625 0 / Create an account to join the discussion.
Kalle L
Follow / 26 Apr 2012 at 9:10pm / Toad for MySQL
Latest post by on 6 Feb 2015 at 4:23pm

Can not open SQL files while connected

Expand content
I have recently discovererd toad and I am very impressed so far. I have however one problem: Toad hangs if I open a SQL file while I have an active connection. If I open the SQL file before i open the...

I have recently discovererd toad and I am very impressed so far.

I have however one problem: Toad hangs if I open a SQL file while I have an active connection. If I open the SQL file before i open the connection to the database server, it works OK.

I spent some time googling about this problem, but have'nt found anything. Does anyone have any suggestions?

I am using Toad 6.3.0.642 on Windows 7 Ultimate 64-bit.  

2754 8 / Create an account to join the discussion.
veliecer
Follow / 30 Jan 2015 at 9:42pm / Toad for MySQL
Latest post by on 6 Feb 2015 at 2:31am

Critical not conect to DB MySQL Toad 7.3

Expand content
Hi I have one problem. I trai to open database Mysql 5.6.17,but Toad show the error: --/// System.Net.Sockets.SocketException El sistema detectó una dirección de puntero no válida...

Hi

I have one problem. I trai to open database Mysql 5.6.17,but Toad show the error:

--///

System.Net.Sockets.SocketException
El sistema detectó una dirección de puntero no válida al intentar utilizar un argumento de puntero en una llamada
Stack Trace:
   en System.Net.Sockets.Socket.GetSocketOption(SocketOptionLevel optionLevel, SocketOptionName optionName)
   en System.Net.Sockets.NetworkStream.get_ReadTimeout()
   en MySql.Data.MySqlClient.TimedStream..ctor(Stream baseStream)
   en MySql.Data.MySqlClient.MySqlStream..ctor(Stream baseStream, Encoding encoding, Boolean compress)
   en MySql.Data.MySqlClient.NativeDriver.Open()
   en MySql.Data.MySqlClient.Driver.Open()
   en MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   en MySql.Data.MySqlClient.MySqlConnection.Open()
   en Quest.Toad.MySQL.MySQLConnection.OpenInitialTestConnection()
   en Quest.Toad.MySQL.MySQLConnection.DoBeforeConnect()
   en Quest.Toad.Db.Connection.Connect(Boolean notify)
   en Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()
--///

I need suport, because I Need follow work my Projects 

Regart

Eliecer Vargas.

807 1 / Create an account to join the discussion.
nuttynibbles
Follow / 10 Apr 2010 at 9:44am / Toad for MySQL
Latest post by on 4 Feb 2015 at 9:26am

Unable to install Toad MySQL on windows 7

Expand content
Hi, i downloaded the latest copy of toad for mysql. when i run it, it shows the blue "initialising wise installation wizard" box followed by the "welcome to the toad for mysql freeware installation...
Hi, i downloaded the latest copy of toad for mysql. when i run it, it shows the blue "initialising wise installation wizard" box followed by the "welcome to the toad for mysql freeware installation wizard". once i click next, it just disappear. i've already set its compatibility level to window xp sp2 but still unable to install.

any help will be appreciated.

Thanks.
2829 6 / Create an account to join the discussion.
andyd01
Follow / 6 Jan 2011 at 1:49pm / Toad for MySQL
Latest post by on 3 Feb 2015 at 10:33pm

Toad Hangs - has to be terminated

Expand content
I have an ongoing problem with Toad for MySql where if I leave it running, but don't use it for a period of time, when I come back to it it's basically hung. I can't do anything in the software...

I have an ongoing problem with Toad for MySql where if I leave it running, but don't use it for a period of time, when I come back to it it's basically hung.  I can't do anything in the software, and I can't quit and I have to terminate the process.  This happens several times a day.

Running on Windows 7 x64.  Anybody know what's going on and how to fix this/

4380 21 / Create an account to join the discussion.
thamarai
Follow / 4 Jan 2015 at 1:55pm / Toad for MySQL
Latest post by on 2 Feb 2015 at 4:44pm

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

855 1 / Create an account to join the discussion.
jakpan
Follow / 30 Jan 2015 at 5:06pm / Toad for MySQL
Latest post by on 2 Feb 2015 at 4:32pm

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 840 1 / Create an account to join the discussion.
vz69
Follow / 8 Jan 2015 at 12:17pm / Toad for MySQL
Latest post by on 30 Jan 2015 at 10:09pm

Error create a connection

Expand content
I just installed Toad for MySql Freeware 7.3.1.3290 on Windows 7 Professional 64 bits. I got many error message windows successively when I try to create a connection or try to connect or just click...

I just installed Toad for MySql Freeware 7.3.1.3290 on Windows 7 Professional 64 bits.

I got many error message windows successively when I try to create a connection or try to connect or just click on Window | Windows... menu.

The error message is the following::

System.InvalidOperationException
Az objektumot jelenleg már máshol használják. (The object has already used elsewhere)
Stack Trace:
   a következő helyen (in following location) : System.Drawing.Image.get_Width()
   a következő helyen: System.Drawing.Image.get_Size()
   a következő helyen: DevExpress.Skins.SkinImage.GetImageSize()
   a következő helyen: DevExpress.Skins.SkinImage.GetImageBounds(Int32 index)
   a következő helyen: DevExpress.Skins.XtraForm.FormPainter.get_SizeGripBounds()
   a következő helyen: DevExpress.Skins.XtraForm.FormPainter.WMNCHitTest(Message& msg)
   a következő helyen: DevExpress.Skins.XtraForm.FormPainter.DoWndProc(Message& msg)
   a következő helyen: DevExpress.XtraEditors.XtraForm.WndProc(Message& msg)
   a következő helyen: System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   a következő helyen: System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   a következő helyen: System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Can anyone help?

Thanks in advance.

786 1 / Create an account to join the discussion.
dlevielle
Follow / 23 Jan 2015 at 10:18pm / Toad for MySQL
Latest post by on 23 Jan 2015 at 10:28pm

Version Software

Expand content
Does Toad recommend a particular version software to use?

Does Toad recommend a particular version software to use?

795 1 / 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 2184 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 846 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()

965 4 / Create an account to join the discussion.