[peterlaursen]

1)

ALTER TRIGGER will open an editor tab. Here you edit what you want. Once done you execute the statements basically like you would execute a simple SELECT statement etc.

Just click the blue 'double arrow' icon (or press SHIFT+F9). This is 'execute all'. All statements on the TAB (The USE, the DROP and the CREATE statements) will be executed.

2)

I do not understand “But in this case it's recursive. You cannot re-use the trigger name in the edit once it's been created”. I think simply you are trying to operate the program as it was never designed to be operated.

[peterlaursen]

Well .. can you import into Access, Excel or whatever? I suppose you have installed a OBDC driver for this database and configured a DSN?

[peterlaursen]

It is not a bug. It is per design.

The name of any database object (database, table, column, index trigger .. whatever) will be pasted to the current open edditor window on doubleclick. You can turn off this from tools .. preferences .. 'general' tab .. uncheck 'paste object name in editor on doubleclick'.

What did you expect would happen when doubleclicking on the trigger name?

[peterlaursen]

How long time does it typically take for Putty to establish connection when this happens with SQLyog? As far as i remember we have a (client side) SSH timeout setting of 10 seconds?

[peterlaursen]

Atter some internal discussion the conclusion is that you cannot do this from the SQLyog connection manager. You will need to create the tunnel with an external program.

We will explain in detail shortly how you can use Putty in combination with SQLyog for this.

[peterlaursen]

Let me put the question another way: how would you do that with Putty or Plink for instance? As far as I can see this will have to be handled in the SSH configuration of Box1. You/SQLyog will authenticate against Box1 and Box1 will authenticate against Box2.

(and you cannot execute 'ssh' command on WIndows unless you have Cygwin or similar installed)

[peterlaursen]

It does not crash here. Basically same environment (Ubuntu 10.10 w. Wine 1.2.2).

Any idea?

It could be a memory-handling bug in Wine having only 'fatal effect' if some other program is also running. Maybe you could try with a minimal set of programs running? Also I wonder if you have more systems with same configuration to try with? Or maybe even you could try to remove Wine and reinstall it?

[peterlaursen]

1) I Don't know technical detals about shortcuts. Our developer team will update as regards this. But the next few days will be very busy here so I cannot promise a reply Monday.

2) Truncation etc. I believe we checked carefully for that. Also the program code contains some logic that will postion elements dynamically so that one element should not collide with another. Anyway if you find something please describe what you find

[peterlaursen]

Well .. we would be happy to have feedback on that. We use a professional translation agency, but they may not be too familiar with database terms etc.

I see three optitons

1) You can simply post here – structure it like this (for instance): 1) English term 2) Incorrect Chinese term we use 3) Correct Chinese term as you would prefer it.

2) You may also mail to [email protected]. This will create a support ticket that both you can SQLyog team (nad nobody else) can access.

3) .. or alternatively update the XML file that we use at compile time and give to us here or in a ticket. Read here how to access it:: http://www.webyog.com/blog/2011/10/17/how-to-localize-sqlyog/ : “To check out the localization kit for the latest SQLyog GA release use the link https://sqlyog.googlecode.com/svn/branches/stable_ga/localization/”

[peterlaursen]

We have not scheduled any plans for this currently. Our scheduled tasks reach 3-4 months into the future.

I know basically what Galera is but I never used it myself. Are you sure that you cannot create 'Custom SQl Objects' yourslef for this?

For 'Custom SQl Objects' Please refer:

http://www.webyog.com/blog/2011/12/16/monitor-your-mysql-servers-like-never-before-use-csos/

http://www.webyog.com/blog/2011/12/19/how-to-add-a-simple-custom-object-in-monyog/

If Galera adds status variables and/or populates Information_Schema tables you can create 'Custom SQl Objects'.

[peterlaursen]

@Mitch. The dump does not have a usable stack trace and we cannot reproduce the crash either.

Does it happen consistently on your environment?

Desktop environment? Gnome?

Have you tried to restart the system?

[peterlaursen]

There is no way currently. Except for closing it manually for every connection so that it will not open again.

Also I do not understand that it worked in 9.33. What did you do wirh 9.33 to achieve this?

[peterlaursen]

Yes .. both are online.

SQLyog: http://www.webyog.com/faq/content/33/7/en/sqlyog-version-history.html

MONyog: http://www.webyog.com/doc/MONyog/Version_History.htm

[peterlaursen]

And finally please read:

http://www.webyog.co…y-language.html

“However if you execute a SQL-script from a file you may include a SET NAMES statement in that file. You will need to do if character data in the file are not encoded with the server default charset. When SQLyog executes an external file, a separate connection is created for that and SET NAMES in that file will not affect the connection that the GUI uses. SQL scripts generated by SQLyog are UTF8-encoded and the file contains a “SET NAMES utf8″ statement. But if the script is generated with another program it is not necessarily the case.”

So does the script/dump contain a SET NAMES statement on top matching how data are encoded in the file?. As far as I remember SQLyog before 6.0 did not add a SET NAMES statement to SQL-dumps and the data in the dump was encoded 'as returned by the server' and the file was ANSI encoded. (unlike from 6.0 where file and data are always UTF8 encoded in SQLyog dumps and there is a SET NAMES UTF8 on top).

Please share a complete table dump with us to [email protected] (you may strip a lot of data as long as only one row is there where the problem is reproducible).

[peterlaursen]

We also need the result of “SHOW GLOBAL VARIABLES LIKE '%char%';” from the server.

[Author]

Posts