Forum Replies Created
-
AuthorPosts
-
Shadow
MemberAnd do not use InnoDB because its engine has been changed in 4.1.1 by adding multiple namspace support!
Shadow
MemberMS 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…
Shadow
MemberAnd 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.
Shadow
MemberOr simply downgraded XP's display to W2K style 😀
Shadow
MemberNo biting, just deleting 😀 Guess that was too much, sorry Ritesh! But still, you should change that link!
Shadow
MemberThat damn W2K, right? 😛
Shadow
MemberTable data view is not affected by this error.
Shadow
MemberAlthough 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…
Shadow
MemberAnd finally, SQLyog crashed after clicking on the result pane (error message is in Hungarian)…
Shadow
MemberScreenshot No. 2. shows SQLyog after execution of 2. SELECT. Note that the value of highlighted cell is still visible!
Shadow
MemberBug 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:
Shadow
MemberINSERTs 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…
Shadow
MemberWell, 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.
Shadow
MemberThat 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!
Shadow
MemberQuote: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