[Sibin A S]

We have added this to our issue tracker, here

[Sibin A S]

We now understand and we see the behavior in Notepad++. But we don’t know other programs that do this. We will research into if it can be implemented.

Regards,
Sibin

[Sibin A S]

Hi,

Thank you for your feedback.

We already have this request in our wishlist, the priority for it is not decided though.

Regards,
Sibin

[Sibin A S]

Hi,

Can you please elaborate with a simple test case and what are you trying to achieve using the keyboard shortcut?

Regards,
Sibin

[Sibin A S]

Hi,

Please contact our Sales team at [email protected] and they would help you.

[Sibin A S]

Hi,

Please refer release notes http://blog.sqlyog.com/sqlyog-mysql-gui-13-0-released/ “Also note that the upgrade of Visual Studio means that Windows older than Vista (ie. WinXP/2003) and Wine older than version 2.0 are not supported any more”

The Wine webpage explains how to upgrade Wine https://wiki.winehq.org/Ubuntu. Current stable Wine version is 3.0 and development version is 3.6. But Ubuntu have always been behind as regards WIne as compared to other major distros (Fedora, OpenSuSE, etc.).

Regards,
Sibin

[Sibin A S]

Hi,

We have replied to you in the ticket created, and reply goes like,

Please refer release notes http://blog.sqlyog.com/sqlyog-mysql-gui-13-0-released/ “‘ROW_FORMAT’ parameter is now handled in the Schema Synchronization comparison.”

.. as well as MySQL documentation on
5.5: https://dev.mysql.com/doc/refman/5.5/en/innodb-row-format-specification.html
5.7: https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format-specification.html
.. in 5.5 InnoDB row_format default is ‘compact’ – in 5.7 it seems to be ‘dynamic’ (though I don’t see it clearly documented. However all my 5.7 InnoDB tables use ‘dynamic. even though I never specified it globally nor at table-level).

.. so this is a real difference on how the table are created and data stored on the two servers (you probably never specified this and servers applied different defaults). We just did not consider this parameter before (but we should have done, really).

To identify the InnoDB row_format default on a server execute “SHOW [GLOBAL] VARIABLES LIKE ‘innodb_default_row_format’;” (SHOW CREATE TABLE does not list this)
.. and to see this setting for tables in a specific database execute “SHOW TABLE STATUS FROM database_name;”.

You can execute the script generated by Schema Sync once, and next comparison does not find this difference. However, for large tables it may take some time to execute the ALTER TABLE statements, as data will be completely rewritten on the server)

Also note, that in the SQLyog CREATE/ALTER TABLE GUI we have (in the ‘advanced’ tab) an option to specify the ROW_FORMAT.

We have also added this request to exclude the ‘ROW_FORMAT’ comparison to our tracker, here

[Sibin A S]

Hi,

We have added the feature request to our tracker, here, but the priority is yet to be assigned.

Regards,
Sibin

[Sibin A S]

Hi,

1) Currently, there’ no option to add %% around the text, you need to manually type %% around the search text.

2) The “Filter” icon in the Result window refreshes the existing filter and provides an option to create a new filter.
In your case, once a filter is created, you can use the existing filter to add/modify it by selecting the corresponding cell in the table data and right-click on it and select the “Custom Filter” option from the option-list (“Filter -> Custom Filter”) to retain/use the filter. Please refer to the screenshot, here

3) We have added the feature request to our tracker, here, but the priority is yet to be assigned.

Regards,
Sibin

[Sibin A S]

This option is implemented in SQLyog v13.0. This option can be found at the following places,

• Under the ‘Edit’ menu
• Right-click on the root node of the server
• Using the keyboard shortcut ‘Shift+{-}’

You may refer our release notes from our blog, here

[Sibin A S]

We can reproduce it with Windows as well. Hence it’s not a wine-related issue.

I have added this issue to our issue tracker, here >> https://github.com/webyog/sqlyog-community/issues/2163, but the priority is not assigned yet.

[Sibin A S]

Can you please elaborate more. Please tell have you migrated Monyog from Windows to Debian?

Also, tell exactly what happened that should have not, and what does not happen that should?

For migrating Monyog, please verify if you have followed the steps below,

Install Monyog on the new system and copy the following folders from your old machine to the new machine,

• Data
• preferences.config
• MONyog.ini
• Counters.def
• Udo.def

The above files including the ‘Data’ folder can be found at the location in Windows OS,
\ProgramData\Webyog\MONyog\

Please note,
Ensure the MONyog service is stopped on the old machine before taking the backup of the files and also stop the Monyog service in the new machine before importing the backup to avoid conflicts/inconsistency between the files.

You may also refer the FAQ, here

[Sibin A S]

No. This option is not available.

[Sibin A S]

Hi,

Just to get it clarified, have you created the new jobs in SQLyog? Also, tell the OS of the new computer.

Also, you mentioned “I set up one previously which has been working fine.“. Was this job created in SQLyog or Windows task scheduler?

Regards,
Sibin

[Sibin A S]

Hi,

We have replied to the ticket that you created.

The solution was,

Please note, The AWS documentation here >> https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MariaDB.html#MariaDB.Concepts.SSLSupport mentions ” MariaDB 10.2 now uses OpenSSL for secure connections.”

Regards,
Sibin

[Author]

Posts