Forum Replies Created
-
AuthorPosts
-
ShadowMember
And do not use InnoDB because its engine has been changed in 4.1.1 by adding multiple namspace support!
ShadowMemberMS and the creators of Total Commander were able to create such feature, so it is absolutely not impossible. In fact it is a good idea, but in tunneled environment a rather tough job to accomplish. I would start by modifying SQLyog's tunneling PHP script…
ShadowMemberAnd there were quite a lot of changes in sub-versions of 4.1 series…
SHOW VARIABLES LIKE '%version%'; command will tell you more details about MySql.
ShadowMemberOr simply downgraded XP's display to W2K style 😀
ShadowMemberNo biting, just deleting 😀 Guess that was too much, sorry Ritesh! But still, you should change that link!
ShadowMemberThat damn W2K, right? 😛
ShadowMemberTable data view is not affected by this error.
ShadowMemberAlthough I see no reason for such option, another setting may be added. However, if you want to see the results of several queries, you may copy them to notepad…
ShadowMemberAnd finally, SQLyog crashed after clicking on the result pane (error message is in Hungarian)…
ShadowMemberScreenshot No. 2. shows SQLyog after execution of 2. SELECT. Note that the value of highlighted cell is still visible!
ShadowMemberBug confirmed with v4.06 on W2K!!!!!
Steps to reproduce the error:
-Execute a SELECT statement from SQL window
-Change to updatable resultset in the drop-down combo box
-Highlight the contents of a field
-Execute another SELECT query from SQL window (the highlighted cell remains highlighted!!!!!)
-Left click on the result pane and SQLyog crashes…
Highlighted cell after the first query:
ShadowMemberINSERTs are usually a lot faster than UPDATEs when BLOB fields are affected. Why? BLOB values are not stored in the table structure, only a pointer is placed there. Therefore MySql has to (1) locate the record to be updated, (2) get BLOB pointer(s), (3) locate BLOB value(s), update BLOB value(s). Inserting data is lot simpler…
ShadowMemberWell, theoretically thre's no need to reboot a computer to changes made to a firewall take effect. If it is possible, try to disable Outpost entirelly, then see if SQLyog connects. In case it does not, then it is not the firewall that interferes with SQLyog.
ShadowMemberThat certainly must not a be big deal! If you change your installer anyway, you could perhaps move the log files and personal folder out of SQLyog's install folder because we prefer to install all programs to Program Files folder but in an enterprise environment most users have only limited access to that folder!
ShadowMemberQuote:I cannot pass further a window “Provide details about your MySQL server”.That's why you didn't find any XML files, the wizard had not finished…
If you have firewall software running, that may prevent sja.exe from connecting to Internet. Did you check this possibility as well?
-
AuthorPosts