[Sibin A S]

Since we are unable to reproduce this at our end, please check if you have any anti-virus solution/tool that is causing it. If you have any AV tool, then please disable it temporarily and close all the opened applications and open only SQLyog and check if the problem occurs.

Regards,
Sibin

[Sibin A S]

This option isn’t supported in SQLyog currently. As an alternate solution, you can use ‘Ctrl+PgUp’ to switch to the previous tab and ‘Ctrl+PgDown’ to switch to the next tab.

Regards,
Sibin

[Sibin A S]

Hi,

The time taken displayed in the ‘Messages’ tab is the time taken by SQLyog to render the query result in the UI from the moment the query execution started from the client (SQLyog).

You may refer the documentation for more info, here

For the data displayed in the ‘Profiler’ tab, we execute a set of statements which can be viewed in the ‘History’ tab. The time shown in the ‘Profiler’ tab is just the time taken by the MySQL server to execute the respective query.

Regards,
Sibin

[Sibin A S]

Hi,

Can you please tell us if you had installed the trial version on the same machine where you have installed the ‘Enterprise’ version?

For importing/exporting connections in SQLyog, you may refer the documentation, here

Regards,
Sibin

[Sibin A S]

Hi,

Can you tell us in detail about the issue you are facing?

Please note, in the ‘Result’ tab, the ‘Duplicate current row’ is grayed out if it is in ‘(Read Only)’ mode. You will need to change the mode to make changes/edit the table data.

Regards,
Sibin

[Sibin A S]

Hi,

The ‘AUTO_INCREMENT’ option which you mentioned is an option provided by the MySQL Create table statement. You may refer the MySQL documentation, here

In SQLyog, we execute ‘SHOW CREATE TABLE’ to fetch the info. Hence, it is not SQLyog which sets the value, but MySQL.

Regards,
Sibin

[Sibin A S]

Hi,

We checked this at our end and it works fine as expected. Is there any specific case to reproduce this issue.

If you have any security software/anti-virus tool, then please close all the applications and disable the AV temporarily and then open only SQLyog and check if the issue still appears.

Regards,
Sibin

[Sibin A S]

Hi,

SQLyog as defualt uses utf8 internally (refer FAQ http://faq.webyog.com/content/8/148/en/do-i-need-to-set-names-to-display-characters-of-my-language.html – when it says “Actually you SHOULD NEVER issue any SET NAMES statement from the SQLyog GUI yourself” it does not apply to utf8_mb4) and refer documentation on INIT_COMMANDS in SQLyog at http://sqlyogkb.webyog.com/article/158-advanced-connection-settings.

You can enter “SET NAMES utf8mb4” in the ‘Init Command(s)’ field under the ‘Advanced’ tab of the Connection window.

Once the connection is established, you may execute “SHOW VARIABLES LIKE ‘char%’;” to verify the change.

Regards,
Sibin

[Sibin A S]

Hello,

Please find the keyboard shortcuts to switch the next, previous connections and even to a specific connection tab below.
Ctrl+Tab Switch to Next Connection
Ctrl+Shift+Tab Switch to Previous Connection
Ctrl+1 to 8 Select Connection (1 to 8)
Ctrl+9 Select Last Connection

We checked in Firefox and Notepad++ as well and found Ctrl+Tab does the same operation that SQLyog does.

To navigate between the query tabs inside a connection you may the shortcuts
Ctrl+PgUp Switch To Previous Tab
Ctrl+PgDown Switch To Next Tab

Regards,
Sibin

[Sibin A S]

Hi,

We can reproduce this issue at our end. We are fixing this, and the fix can be expected in the next release. We have also replied you in the ticket that you have created

Regards,
Sibin

[Sibin A S]

All session restore data are saved in a file named “connrestore.db” saved in you User Profile i.e, “C:UsersusernameAppDataRoamingSQLyogconnrestore.db”

 

In case of a system crash, you may restore “connrestore.db” from a backup or if you have Windows “System Restore” enabled for the volume – from a file system snapshot (right-click on it in Windows Explorer -> properties -> previous versions -> select the most recent version from before this happened.

 

Regards,

Sibin

[Sibin A S]

Hello Rob,

 

Was the ‘Session Restore’ enabled before your system shut down unexpectedly? Did you get any message pop-up mentioning a backup of the session that was unable to connect to the servers are saved?

 

If SQLyog cannot connect to the servers, then the session will be saved and can be found in the following file path >> “C:Users{user_name}AppDataRoamingSQLyogconnrestore_backup.ysav”

 

To restore that session, ensure the servers are up and running before restoring the sessions and in SQLyog, you may go to the menu >> File -> Open session savepoint -> {session_file}

 

Regards,

Sibin

[Sibin A S]

Hello,

 

Concerning your request, consider the job file being inside a sub-folder that has a long name. Then, it that case the textbox cannot be so long to include the entire file path.

 

Currently, you can click on the browse button and check the file path as well as the file name.

 

Regards,

Sibin

[Sibin A S]

Hi,

 

Can you please elaborate that if you are referring to the Object browser where this feature request needs to be implemented?

 

Regards,

Sibin

[Sibin A S]

Hello,

 

By default, the server writes OPTIMISE, ANALYZE and REPAIR TABLE statements to the binary log so that they replicate to replication slaves. To suppress logging, you may specify the optional NO_WRITE_TO_BINLOG keyword or its alias LOCAL. Please refer the official MySQL documentation for the syntax >> 

 

https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html

https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html

https://dev.mysql.com/doc/refman/5.7/en/repair-table.html

 

Regards,

Sibin

[Author]

Posts