Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberHe had sent a mail to [email protected] too asking about how to add comments to a column using SQLyog GUI.
It is not currently possible but we plan to implement this feature in one of the future versions of SQLyog.
Ritesh
MemberConfirmed. Will be fixed in BETA 2.
Ritesh
MemberThis is due to the fact that MySQL returns the SP, Function, Trigger definition with database name in it. Thus it looks like:
create procedure db.table.xxxxxx ( …. )
It is very difficult to correctly strip out the database name and execute it in a different context automatically.
We have had a discussion with MySQL AB people and they said that they address this issue in v5.x. As of now, all the three options will be enabled when you copy the database to a different database with the same name.
Ritesh
MemberThis is very strange as we dont keep passwords for any wizards in sqlyog.ini. If you open up the wizard again, you will see that all the fields keep their last values except the password.
I have forwarded it to my development team.
BTW, we keep the password in plain text in the XML job file.
Ritesh
MemberYou will have to click on Fill Excel Friendly Values button. Otherwise, it will have the last used values.
Ritesh
MemberIts funny but Excel requires two different set of SEPARATORS when you open a CSV file and when you copy-paste data from clipboard.
SQLyog takes care of both of them accordingly. You will will just need to change the separators to proper format before exporting to a file or to clipboard.
We give you best of both the worlds 🙂
HTH
Ritesh
MemberThere was a typo. Thanks for catching that! It has been fixed now.
Ritesh
MemberIs this a common rant among sqlyog customers?
No.
Am I alone in this?
Kind of – Yes.
Are there any plans to support this?
Currently there are no plans to implement this but I have added it in the TO-DO list.
Ritesh
MemberNow I am really at lost of ideas. Starting from v4.05, we have vastly improved the Import data from SQL dump module and our profiling shows that its as fast as the MySQL command line tool (in some cases even better).
The most strange fact is that all other options work as expected 😮
Ritesh
MemberAre your SQL dump as BULK INSERTS or INDIVIDUAL INSERTs?
Can you try importing the dump from the mysql command line tool?
Ritesh
MemberVery strange that its so slow on a direct connection. Do you find any sluggishness with other options?
BTW, whats your connection speed?
Ritesh
MemberThanks for the bug report.
A patch has been commited to our v4.2 repository. This bug will be fixed in v4.2 BETA 1 which will be released shortly.
Ritesh
MemberAre you using HTTP Tunneling or Direct Connection?
-
AuthorPosts