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!
Working on Version: 188.8.131.5290.
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.
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** secondsWhen I have checked the query with explainquery 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 filesortWhat should I do in this case?
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, 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?
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.
"Format code" refuses to format any query containing GROUP_CONCAT + SEPARATOR:
SELECT level , GROUP_CONCAT(code SEPARATOR ' ')FROM LogsGROUP 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
After installer the Toad for MySQL 7.2 show the error message bellow.
Can anybody help-me?
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 !
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.
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 184.108.40.2062 on Windows 7 Ultimate 64-bit.
I have one problem. I trai to open database Mysql 5.6.17,but Toad show the error:
System.Net.Sockets.SocketExceptionEl sistema detectó una dirección de puntero no válida al intentar utilizar un argumento de puntero en una llamadaStack 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
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/
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 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 just installed Toad for MySql Freeware 220.127.116.1190 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.InvalidOperationExceptionAz 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.
Does Toad recommend a particular version software to use?
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: 18.104.22.16822Toad 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 22.214.171.12490 (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 v126.96.36.199 (x86): ok
I install Toad for MySQL v188.8.131.5290 (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()