[peterlaursen]

@ron

I am totally aware of that!  I also considered deleting this post.  It is a difficult balance!

The problem is that there is software available that can register at the Forums, solve captchas, create topics and posts – and hundreds or thousands of them per hour fully automatically.  Those 'software's' even ship with databases where Forums, guestbooks, FAQs etc are sorted in categories and listed in the order of Google ranking.

The whole Forums/BB industry is struggling with solutions.  Basically I believe that there is only one solution: that DNS providers close the connection (without compensation!) of those that use their connection for such purposes.  That would actually be realistic in Europe (a lot of ISPs actually do allready), but not Russia, Brasil .. and not even the US!

We just updated the Forums software.  I have not studied every detail of the new administrative options yet. I hope to find some improvements in this respect here.  But I don't expect a complete solution 'in this shot'.

[peterlaursen]

A Forum is for use as a Forum!  You can ask your questions here.  That is the idea!

[peterlaursen]

This is not the way SQLyog backups work. With SQLyog you do not store the back up on the server, but on the client. SQLyog (as any other client of its type) does not use the 'mysqldump' program of any other server-side backup routine.

so just do like this:

1: connect to one server and perform the backup

2: connect to another server and restore (tools .. restore from SQLdump).

[peterlaursen]

I'll repeat that it is not a bug, it is a feature! <_< You can turn it off in 'preferences'. (enable/disable 'smart' keywords handling) Please refer to: http://webyog.com/faq/8_99_en.html

[peterlaursen]

Actually there was a detail that none of us had thought about. That is that we can have multiple queries.

So the solution for 5.22 will be.

1) When a RESULT tab is active status line will display the 'HISTORY-time' of that query.

2) When some other tab (not a RESULT tab) is active status line will display like MESSAGES tab does.

this need not be the final solution so just go ahead with the discussion …

[peterlaursen]

1) Word wrap is there allready (in 'preferences')

2) highlighting and executing browser and mail program from http:// and [email protected] type of links are planned.

3) there are no immediate plan for 'rich text editing' – however this is more a matter of resources and priorities that we do not want it ourselves.

[peterlaursen]

You should use the Forums and not PM individuals unless you have some PRIVATE message. That is the idea with Forum. And anyone bothering someone else with spam, advertisements etc., will be hung by his toenails and beaten with an organic carrot – and deleted as a user from this Forum of course! 😀

[peterlaursen]

I think you are talking about the 'BLOB-viewer' used for TEXT and BLOB variables?

[peterlaursen]

Starting from next release (will likely be named beta3) we will let the STATUS LINE display be identical to HISTORY. That is as close to SERVER EXECUTION TIME as we can get.

This need not be the final solution, so just keep on discussing. However we realize that when working on 'localhost' and not very big queries STATUS LINE display does not tell much at the moment!

[peterlaursen]

There is no ALTER TRIGGER statement in MySQL.

You do like this: DROP the TRIGGER and CREATE again with the new content.

You will not lose anything (such as data) with that as TRIGGERS do not hold any data themselves.

Do you see the CREATE TRIGGER statement in the table context menu now?

Have you updated the Server in between?

Some screenshots would be nice, so that we can see what you see!

[peterlaursen]

Quote:

I click right on a table and I don't see create trigger(it is inactive not active).

I think I understand now!

The server must by MySQL 5.x. Earlier versions do not support triggers. If you execute “select version()” you will have the exact server version.

In SQLyog if you right-click a table there is a 'Create trigger' option. Also if click the + sign left to the table there is a 'TRIGGERS' folder. And from the context menu of the trigger (if there is any) you can choose between options. But the options are only available when connected to MySQL servers that have this feature.

[peterlaursen]

I am afraid that I do not understand you.

Quote:

Sometimes i want to creat trigger not code

but a MySQL TRIGGER is code! Code that is stored as part of a table itslef.

Quote:

AND in mysql is there if Update(“columnname”) statement

I do not understand this either. You are not talking baout PHP (and not MySQL) here?

Quote:

how can I find the whether a column changed

By querying it, I would say. Did I miss something?

[peterlaursen]

don't you have a 'security center' icon then?

[peterlaursen]

Quote:

I send an email to support but have heard nothing back.

You should search the FAQ: http://webyog.com/faq/1_26_en.html

.. and you will understand why 'emails to supportare not replied to!

Use the ticket system and the Customer Portal instead!

What is the program version? Free? enterprise ??

You may also read this: http://webyog.com/faq/30_129_en.html

[peterlaursen]

After refreshing my memory I must change a little … 🙁

1) We recently fixed a regular bug. That was that the status line always displayed 0 (zero) when MESSAGES tab was active.

2) At the same time we changed so that the status line always displayed the same no matter what tab was active.

Basically the situation now is this:

1) HISTORY TAB displays the server execution time plus a little transmission 'overhead' to send the query and to get the status flag from the Server.

2) STATUS LINE + MESSAGES TAB displays (what is very close to) the transmission time for the RESULTSET plus a little 'overhead' for the client to format and display data.

Now it would be no big deal to display both in the status bar with (for instance) a slash in between (like “5/37 ms taken”), or we could display the sum of the two (like “5/42 ms taken”). So let us hear what people want (and the argumentation not at least)!

[Author]

Posts