[peterlaursen]

They are of course both good and reasonable requests, but I also think you do not yourself fully understand the 'depth' of them.

#1:

This may seem rather simple when you type from an end but when you copy blocks of code into the editor it is not, because then everything will have to be recalculated. Also as long as there are matching “(” and “)” it is also far more simple than if they do not match! I think you would expect SQLyog to tell which one should be removed or where one should be added is case there are 16 “(” and 17 “)”. Basically the SQL-editor does not understand SQL (it does not even try) .. it lets the server decide what is right and what is wrong! SQLyog is not a 'stand-alone' program – it is a database client that is only thought to be operational when connected to a mySQL server. The MySQL server has no such integrated IDE functionality that we can query. Anyway this is something that we would like to do. The problem is not so much to identify matching “(” and “)” – but to find out what to do when they do not match!

2:

Here you first make a simple mistake. This “I have a dual core machine so I should be able to go to another query table” is basically wrong. It does not matter if you have one or 16 cpu's because no matter have many cpu's or cores you have it is the OS that gives cpu time to processes and threads. Hardware simply does not matter here – it is a software issue only!

Also again I think I will have to remind you that SQLyog is a client program. You cannot expect anything from SQLyog that the MySQL communication protocol does not support! With one connection you cannot send another query to the server before it has returned the result of the first query! What could be done was to create a connection for every query tab. But then you may equally well start 'a new connection using current connetion settings' (or another program instance for that sake). Note that this option is in the file menu allready (and you can use it with a single single core cpu – windows can handle it!) – it just will open connections in different windows and not different tabs! But an option to (transparently) start a new connection for a new query tab is worth considering! We have several requests for a 'tabbed connections' interface and this request may unite with it. And will will probably be easier to navigate than this:

[attachment=803:connections.gif]

Basically MySQL client-server communication is 'ping-pong-ping-pong' and cannot be 'ping-ping-ping-pong-pong-ping-pong-pong'. After one 'ping' is sent over a connection it is not possible to 'ping' again until after the 'pong' corresponding the first 'ping' has been received.

But you are right that there is no compelling need that you should not be able to start typing in another tab – that is lack of 'multithreadedness' in SQLyog alone that prevents it. But you will have to wait to execute it or establish another connection to the server!

In summary: both requests are not new. We would like to do both. But we also have to respect to 'rules' or client-server communication of the MySQL protocol. And the exact implementation for both is not so easy to find!

[peterlaursen]

“I just want to update a single column “

You cannot update a single column. SJA data sync will always sync complete rows!

The options defines what columns are used for generating checksums only. It is an optimization option! If you are able to specify a unique set of columns (for instance a single column defined as a Unique Key) you may do to improve performance!

Please read: http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

[peterlaursen]

sorry .. long time ago I used DB2. I shifted to DB2½ some years ago (and consider to shift to DB3½ soon) … 🙂

jokes apart .. but I think DB2 version is not without importance.

But nothing here you can use?:

http://www.google.com/search?client=opera&…-8&oe=utf-8

direct link to a Windows ODBC driver for DB2 v9:

ftp://ftp.software.ibm.com/ps/products/db…or_odbc_cli.zip

.. or just search on http://www.ibm.com! I am pretty sure that there is a free download.

[peterlaursen]

I think we increased the size of this dropdown not so long time ago (about 9 month if I remember correctly).

I also think there are some limitations with the Scintilla component that causes this linitation.

When we increased it was because it became possible after a new Scintilla version became available.

I also think a more recent one is now available again.

But I cannot tell exact details before beginning of next week (due to the weekend).

BTW: You may click a database in the Object Browser as well.

[peterlaursen]

In recent version the .ini is located at (on WIN 2K/XP/2003) C:doc…s and settings{user}application datasqlyog

('application data' folder may have a localized name)

It was moved recently for Vista compability.

Please try copying the .bak.ini to that location and rename to .ini

It should all have happened automatically, but sometimes failed.

changelog details:

**************

6.07:

— Files used by SQLyog that are not read-only (.ini, .log, .err) are now no longer created in 'program files' files tree (or what localized name it has). The storage follows Microsoft recommendations for the various Windows versions. Existing files will be moved when program is started first time and a backup created in the original position. Windows Vista has actualized this.

6.08:

— If user's 'AppData' path used special characters (due to a localized 'AppData' folder or a user name with special characters) program was not able to access sqlyog.ini for read and write operations.

6.13:

— Empty or incomplete lines in sqlyog.ini would cause stop reading from the file. As a consequence details that could not be read would not be written. Those details that could not be read were lost.

I really hope that you did not come across a new issue … but first please try copying manually and report result.

I think it is the issue fixed between 6.12 and 6.13 you have experienced!

[peterlaursen]

1) 'root' per default has ALL privileges.

2) on your host it seems that root is only allowed to connect from 'localhost'.

So either you will need to

1) define another user with appropriate privileges that is allowed to connect from remote hosts

2) allow 'root' to connect from remote hosts. This may be done for a specific IP or IP-range only

3) “Can I connect to a remote mysql server using Webyog, as the root user, and SSH?” most often YES. With a SSH connection connection to MySQL is from the host where the SSH daemon runs. And if that is the same computer as MySQL runs the answer is yes.

[peterlaursen]

about 2)

what I wrote in the first place was basically correct. However we are working on implementing zooming, and will consider ways of improved nagivation in this context!

[peterlaursen]

1) I think the request that tooltips should display shortcut (when there is one) is allready registered in our googlecode issue tracker. We will check again. I think everybody agree! It is a matter of priority only.

2) I will let Nithin comment too (as you also know, he knows best!) , but currently I think both the SD and QB canvas'es as well as the QB grid has a fixed size. It is not expanding dynamically. Only the full canvas (and QB grid) is not shown. Current display with scrollbars reflect that I think!

[peterlaursen]

yes, but only after 6.2 release we will be able to tell with what priority.

[peterlaursen]

SUPER privilege does not let user create a view!

See for yourself:

Code:

show grants;
/*
returns

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SUPER ON *.* TO 'mutex'@'localhost' WITH GRANT OPTION */

create view testview as select * from mytable;

/*
returns

Error Code : 1142
CREATE VIEW command denied to user 'mutex'@'localhost' for table 'testview'
(0 ms taken) */

This privilege setting is shown in SQLyog in image below.

[attachment=799:privs.gif]

There is a 'create view' and a 'show view' privilege that the user should have to be able to work with VIEWs.

With shared hosting you may not be able to use SQLyog for user managnement. But there should be some control panel from where you can!

Docs on MySQL privileges:

http://dev.mysql.com/doc/refman/5.0/en/pri…s-provided.html

[peterlaursen]

You are right that autocomplete currently does not support alias'es.

[peterlaursen]

First step is that we add the request here:

http://code.google.com/p/sqlyog/issues/detail?id=479

[peterlaursen]

It will come by itself when you type a tablename in the selected database followed by a “.” (dot).

A small window will appear from where to select. For every char you type if will change the selection and propose you 'best fit' (by highlighting). Insert with or .

There was a bug in some early 6.x builds (before 6.06) that disabled part of that functionality!

[peterlaursen]

It is implemented like that. Since 5.0. It is an ENTERPRISE feature (including the ENTERPRISE TRIAL).

Read the help file 'SQL window …Autocomplete'.

Was I missing some point?

[peterlaursen]

ok .. let me try to find out then if this is a bug with this Forums Software or if it can be configured somewhere !

[Author]

Posts