[Shadow]

Perhaps you should fine tune the settings in my.cnf/my.ini to get better performance. The default settings are not optimised to support large dbs. SQLyog does not have any setting that would affect query performance.

Increase read_buffer_size and configure the query cache, first of all.

[Shadow]

MySql clients do not read my.cnf or my.ini directly, those settings must be propagated by MySql server. No matter what related settings you configure in my.cnf, they are not reflected in the session variables of MySql . I belive, this rather an issue with MySql rather than an issue with SQLyog. Unfortunately, it is Ritesh only, who can tell for sure which side is fault in this particular case.

[Shadow]

Which version of MySql and SQLyog do you use? How did you configure your MySql server?

[Shadow]

First of all, it is MySql and not SQLyog that honors this setting (it is not SQLyog that enforces this option). Interesting, however, if you set the safe-update option in the config file and you connect via mysql's command line utility, then select @@sql_safe_updates; command yields to 1 (set), while the same command in SQLyog's SQL window yields to 0 (not set). Hopefully, Ritesh will be able to explain this behaviour.

Quote:

I can select more than 1000 rows and update without a where clause

If you use SQLyog's GUI to retrieve and manipulate data, then this behaviour is understandable: SQLyog uses PKs to update or delete rows, and adds explicit LIMIT clauses to its SELECT statements that override the default setting.

Unfortunately, I was unable to start the server with this option, so currently you have no other option othar than adding these statements to the personal folder in SQLyog and issuing them every time you start working.

[Shadow]

SQLyog – currently – supports via its GUI the creation and retrieval of table level comments only. By issuing appropriate SQL command you can create and retrieve field level comments as well.

If you select a table in the object browser, then the comments belonging to the fields of the given table will be displayed in the object pane.

[Shadow]

Increase bulk_insert_buffer_size (previously myisam_bulk_insert_tree_size) to a higher value to get better results.

[Shadow]

SQLyog is written in C++. .NET is not that commonly used, so it would be very inconvenient to force customers to install .NET framework for the sake of this program.

Using the built-in log of win is not a bad idea, this was requested before, I believe.

[Shadow]

Minimum requirement: fields separated by ',' and lines terminated by 'rn'. Escape characters depend on your data (I use none). It might be useful to add column names to the export file as well.

[Shadow]

Why does your solution offer more control over directly importing to MySql?

I see no cause why a textfile should be transferred through 3 apps to get to MySql…

[Shadow]

If you are writing a web based app, then most likely you'll need some server-side technology such as PHP, CGI, ASP to query (and not export) data from MySql and render it to the user.

[Shadow]

Then most of the Hungarian providers will not be included in the list…

Anyway, we kept telling people with such problems to resolve it with their ISP first!

[Shadow]

Actually, you are the first who has problems with the naming of this feature. If you need such extensive sync options, then you have to turn to MySql's built in replication feature because it is the only one that can detect and handle changes so extensively using the binary log.. As I have mentioned preciously, SQLyog changes constantly and may once have such a feature that satisfies you taste.

[Shadow]

There are two separate tools to achieve that purpose. I'm sure SQLyog will further develop as time passes.

[Shadow]

Quote:

username:[email protected] or username:[email protected]

Why do you want to enter such data to the connection window?

No database (not just MySql) is ever exposed directly to the whole internet because some “good-willed' people could take the db server down in minutes. It's a fact, not a fairy tale. They might grant you direct access based on IP or host name but even this is not common. This is exactly why SQLyog's team is working on a PHP-tunnel. Besides tunneling can be done easily with separate programs, this issue has already been extensively discussed in this forum.

[Shadow]

Are you going to contribute some useful advices or keep playing with words? Who cares what syncronization 'usually' means as long as we understand what the other person is talking about!

Quote:

that after a sync of 2 tables / databases every of those 2 tables/databases have the same data — as You have at a replication after a “sync”

SQLyog's data sync tool does exactly that!

[Author]

Posts