Forum Replies Created
-
AuthorPosts
-
RiteshMember
He 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.
RiteshMemberConfirmed. Will be fixed in BETA 2.
RiteshMemberThis 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.
RiteshMemberThis 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.
RiteshMemberYou will have to click on Fill Excel Friendly Values button. Otherwise, it will have the last used values.
RiteshMemberIts 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
RiteshMemberThere was a typo. Thanks for catching that! It has been fixed now.
RiteshMemberIs 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.
RiteshMemberNow 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 😮
RiteshMemberAre your SQL dump as BULK INSERTS or INDIVIDUAL INSERTs?
Can you try importing the dump from the mysql command line tool?
RiteshMemberVery strange that its so slow on a direct connection. Do you find any sluggishness with other options?
BTW, whats your connection speed?
RiteshMemberThanks 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.
RiteshMemberAre you using HTTP Tunneling or Direct Connection?
-
AuthorPosts