[shubh]

Hi,

Quote:

How can I make the connection secure? Is there a way to setup SSH, SSL, or other means?

You can connect to MySQL server using SSH and SSL. Please refer SQLyog's help documentation here: http://static.webyog.com/docs/SQLyog/#SSH_Tunneling_SQLyog_MySQL_Client.html and http://static.webyog.com/docs/SQLyog/#SSL_encryption_SQLyog_MySQL_Client.html

Quote:

Can I control the port on which SJA works? say 443 or 22?

We can't clearly understand what you are exactly referring to? If you want SJA to connect to any specific port while making SSH connection, Yes you can mention that particular port number where SSH server is listening. If you want SJA's MySQL client to connect to MySQL server using user defined port, that can't be done.

Quote:

Can I define multiple databases in the XML configuration file?

No, while synchronizing databases you can't define multiple databases in single job file. You will have to create multiple job files for synchronizing each database and you can execute them in one go by scheduling batch script.

Regards,

Shubhansh

[shubh]

Hi,

Currently, SQLyog read themes from %appdata%/SQLyog/themes folder only.

I have added a request to read theme files from folder specified in -dir switch in our issue tracker here: http://code.google.c…/detail?id=1898

Further, quoting from help documentation on -dir switch here: http://static.webyog…g_MySQL_GUI.htm

Quote:

“The -dir parameter tells where SQLyog will look for and create files that are not read-only. This option can be used to specify the path where SQLyog will create these files.”

With -dir switch, SQLyog will create/read files for Favorites, Saved Connections, other UI details and dump files in the specified directory.

Regards,

Shubhansh

[shubh]

Hi,

We have added your request to support REGEXP in Object Browser filter here: http://code.google.com/p/sqlyog/issues/detail?id=1895

Further, with current OB Filter, as you type in edit box, first matching table name(word%) will be filled in filter text box. You can type table name unless you get the table you want and press enter, this will show only desired table in Object Browser.

Regards,

Shubhansh

[shubh]

Hi,

Bug is reproducible in v10.5. We will fix it at priority. Fix will be available in next public release.

Regards,

Shubhansh

[shubh]

Hello,

Please let us know what SQLyog version you are using as we are unable to reproduce.

What type of SQLyog connection you are using (HTTP/SSH/Direct)?

You can attach screen-shots by clicking on “More reply options” in the right bottom corner close to “Post” button.

Regards,

Shubhansh

[shubh]

Hi,

Quoting from documentation here: http://static.webyog…I_for_MySQL.htm

“If a WHERE clause is specified then it syncs all columns of the table that satisfy the WHERE clause.”

As case specified by you, by giving “id_server = 2” will sync only those rows of the table that have “id_server = 2”. It will not sync any other rows of the table.

We have “Don't delete extra rows in target database” option in Database Sync wizard. Quoting from documentation here: http://static.webyog…SQL_Manager.htm

“The extra rows present in the target database are deleted if you keep the checkbox 'Don't delete extra row(s) in Target database' unchecked.”

[shubh]

Hi,

Issue is fixed in v10.5 Beta1. Please refer our release blog: http://blog.webyog.com/2012/11/30/sqlyog-mysql-gui-10-5-beta-1-released/

[shubh]

Hi,

We have released 10.5 Beta1 with the fix.

[shubh]

Hi,

We are not able to reproduce the case when DB objects don't have spaces in their names. It will be really helpful, if you could provide us structure of your database (for table names and column names) by simply sending mail with file attached to [email protected]

You can export structure by using SQLdump utility in SQLyog and selecting “structure only” option. Please refer screen-shot.

[shubh]

Hi,

We are looking into this. Issue is reproducible for some cases. We have added issue here: http://code.google.com/p/sqlyog/issues/detail?id=1885

Please confirm, do you have some tables/columns beginning with space.

Regards,

Shubhansh

[shubh]

Hi,

SQLyog now has Object Browser Filter from v10.4 Beta 1.

It filters Databases, Tables, Stored Procedures, Views, Events, Functions and Triggers.

Regards,

Shubhansh

[shubh]

Hi,

SQLyog now has Object Browser Filter from v10.4 Beta 1.

It filters Databases, Tables, Stored Procedures, Views, Events, Functions and Triggers.

Regards,

Shubhansh

[shubh]

Request has been implemented in v10.2 Beta1

[shubh]

One can do square selection in text view of Result/Table Data Tab by Alt + Selection of area.

[shubh]

The request has been implemented in v10.1 Beta1

We now have detailed option in Tools->Preferences->Fonts & Editor Settings, to change editor and canvas colors.

[Author]

Posts