[peterlaursen]

Will be like that in next release. 11.21 beta1 by beginning of next week probably. You are not the first user being a little annoyed with the dialog.

There will be no dialog on startup. Instead a 'preferences' setting whether user wants to open connections from previous session or not.

[peterlaursen]

The BLOB-viewer in SQLyog will open for both BLOB and TEXT types. This is per design.

TEXT is the MySQL implementation of the standard SQL datatype “CLOB” (character long object). For plain strings and if you don't want the BLOB-viewer to open use VARCHAR datatype instead. Refer MySQL documentation http://dev.mysql.com/doc/refman/5.5/en/string-types.html

This in particular confuses people who are used to Microsoft Access. What is a 'TEXT' in Access is similar to a 'VARCHAR' in MySQL. And what is a 'TEXT' in MySQL is similar to a 'NOTE' in Access

Was that the problem?

[peterlaursen]

Please elaoraborate WHERE it 'shows up a BLOB. Maybe a screenshot and a SHOW CREATE TABLE will clarify? first of all e need to figure out if it is happening on the server or the client (SQLyog).

And also please tell your MySQL server version and if this haapened after moving from one version to another.

[peterlaursen]

.. and we have received it.

[peterlaursen]

Please mail to [email protected]

[peterlaursen]

Confirmed as I wrote in my last post.

When running SJA 32 bit from default installation folder folder (program files (x86)) on a 64 bit Win7 and Win8 system and if UAC is turned on you will need to specify -l and -s parameters to a directly writable folder.

(program files (x86)) is not directly writable unless a program is running with elevated admin privileges. In other cases UAC virtualizes fhe files to be written to user's User Profile. Why it fails to write there I really don't know at the moment!

[peterlaursen]

We have a few Win8 systems as well and for us it works fine in program files. I am not sure about program files (x86). I believe all our Win8 systems are 64 bit and we are using SQLyog 64 bit on those.

We will try installing (if we did not alredy) the 32 bit version.

Could you please tell your UAC (User Account Control) setting? (from Control Panel .. User Accounts). The are 4 levels for UAC. Which one do you use? 32 bit programs will use UAC virtualization if UAC is on.

Anyway SJA has a -l option. Refer: http://faq.webyog.co…agent_-sja.html

Quote:

“

…

sja “jobfile.xml” –l”log.txt” –s”session.xml”

The -s and -l parameters for specifying the session file and the log file are optional. A complete file path can be specified (using the quotes is necessary if there are spaces or a ‘:’ in the path). That is useful if you don’t have write privilege to the installation folder. If not specified default values logfile.txt and session.xml are used and file are placed in the directory from where SJA runs.”

.. so I believe that you can install to program files (x86) but need to specify the -l and -s parameters for sja.

[peterlaursen]

1) Is there any way to speed up the application in a Windows Roaming Profile senario?

yes .. the option to move the SQLite database to a local location ('tags' setting)

2) Is there any control over where SQLyog puts its files e.g. temp files?

we do not create any temp files at all as far as I am aware

3) Is there anything we can amend or add to the configuration file(s) to instruct sqlyog to use local storage (for non-settings/unimportant files)?

yes .. the '-dir' switch

4)Is there any documented explanation of each the sqlyog.ini file settings?

no .. it should also be quite intuitive.

If we shall comment further we will need to see what is happening as first step. A shared seesion will be necessary. Please create a private ticket by sending a mail to support@webyog com so that we can continue in privace.

[peterlaursen]

I have added this request to our issue-tracker here: http://code.google.c…/detail?id=1956

[peterlaursen]

The option is there already! Please see image.

[attachment=1902:dup.jpg]

And also refer 8.5 release notes (http://faq.webyog.co…on-history.html): Added an option to 'duplicate row' from DATA tab GRID context menu. Tables with auto_increment columns are handled. Note that handling all other CONSTRAINTs is user's responsibility.

[peterlaursen]

You have also ceated a ticket. It is non-practical to have the discussion partly her in Forums and partly in a support ticket.

We will continue discussion in the support ticet (unless you prefer otherwise). My best idea currently is that this is a server or networking issue (the HTTP response getting distored) and unrelated to SQLyog. But please wait till after te weeked and we will check the test case(s) you provided in the ticket.

[peterlaursen]

Maybe you could expalin teh context? I do not understnad what log file you are referring to.

[peterlaursen]

I have replied here: http://forums.webyog.com/index.php?showtopic=7217

For the future I request that you only post ONCE for a specific issue. Multiple posts about same issue are considered 'bad netiquette' – and also a childish/juvenile behavior. It will also be more difficult to communicate if discussion is shattered over multiple posts.

http://en.wikipedia.org/wiki/Etiquette_(technology)

[peterlaursen]

Please use the option in menu .. tools .. preferences .. 'powertools' tab . . and specify a local 'tags' directory.

The 'tags' directory specifies where files related to teh autocomplete feature are stored. If you use a Windows domain server to store user profiles connecting to the domain server can be a significant overhead. This option was introduced in version 6.52. Please refer release notes at http://faq.webyog.com/content/33/7/en/sqlyog-version-history.html “Added an option to specify (in preferences .. powertools) storage position for TAGS files (used by Autocomplete). On networks where 'roaming profiles' are stored on a domain server specifying a local folder will reduce network traffic and save storage on the server.”

BTW: could I request that you read the program documentation (help .. help -menu)?

[peterlaursen]

Well the option to backup views is there. menu, tools, backup database ….,select a database and check only VIEWs checkbox. You can take 'structure only' or 'structure and data'.

'rename view' is possible since early 5.0x versions, but refer http://dev.mysql.com/doc/refman/5.0/en/rename-table.html what privileges are required.

” Any privileges granted specifically for the renamed table or view are not migrated to the new name. They must be changed manually.

When you execute RENAME, you cannot have any locked tables or active transactions. You must also have the ALTER and DROP privileges on the original table, and the CREATE and INSERT privileges on the new table.”

And here we have a similar request for a stored procedure: http://bugs.mysql.com/bug.php?id=27793. And is not working. The request for SAFE ALTER is equally relevant here.

[Author]

Posts