[Sibin A S]

Since you mentioned its working fine when connected to a remote connection directly and the issue occurs only when connected vis SSH tunnel. This will be an issue/delay caused by the SSH server. You may also refer our FAQ for the same, here >> http://faq.webyog.com/content/22/185/en/sqlyog-takes-long-time-to-connect-when-using-ssh_tunnel.html

 

Regards,

Sibin

[Sibin A S]

Hi,

 

We have replied to you in the ticket that you have created. 

 

Regards,

Sibin

[Sibin A S]

Hi,

 

Great hearing from you. Thanks for your kind words.

 

Regards,

Sibin

[Sibin A S]

Hi Mitch,

 

SQLyog currently store only the tab contents that are kept open while closing SQLyog. As a workaround, you may save the session using the menu “File -> Save Session” or even a save only the required tab contents using the menu “File -> Save” which you can later open through SQLyog.

 

Regards,

Sibin

[Sibin A S]

Hi,

 

Not sure. But it could be a problem with the Windows user account the job is running with. Have you been managing users on the system? 

 

 

We have this FAQ http://faq.webyog.com/content/27/34/en/why-is-my-scheduled-job-not-running.html, but it was actually written for Windows 2K (that we do not support anymore) where such issues were common with the scheduler.

 

 

My best idea is that you, from the Scheduler interface (in Control panel) re-schedule the jobs affected.

 

 

Can you try enabling/check the option “Run whether user is logged on or not” under “Control PanelSystem and SecurityAdministrative ToolsTask Scheduler” and select ’Task Scheduler Library’ from the left pane and select the respective job file and enable “Run whether user is logged on or not” option. This also depends on the Windows versions.

 

Can you please check if you have set whether the system goes to sleep after a certain time. If so, please check the setting and select the option as ‘Never’ under “Control PanelHardware and SoundPower OptionsEdit Plan Settings” for the option ‘Put the computer to sleep’.

 

Regards,

Sibin

[Sibin A S]

“Lowering the responsiveness of yog while the search is happening is fine. I wouldn’t mind just waiting for my search to finish.” >>  We will also need to consider the interest of all the users and not all the users will be fine if there is a lag in the response.

 

Currently it is not possible inside SQLyog and we store the session data into the SQLite database (i.e, ‘connrestore.db’ file) which can be found at the location “C:UsersAppDataRoamingSQLyog“.

 

Regards,

Sibin

[Sibin A S]

Hi Mitch,

 

We are aware of this warning issue. We are working on it. Thanks for taking time to report this.

 

Regards,

Sibin

[Sibin A S]

Hi,

 

“When using scheduled backups, if a table name in the database ends with a number, the backup will crash.” >> Please elaborate what exactly do you mean by the term crash here. Does the backup run successfully with not backing up only the table that ends with a number or does the backup not take place at all.

 

Regards,

Sibin

[Sibin A S]

Hi, 

 

SQLyog does not support this option. You have the option to check the contents of each tab by selecting the respective tab.

 

Implementing this will cause an overhead if the opened connections are very large (probably 80-100 connections) and also if the opened tabs in each connection also is very large (probably 50-60 tabs). Then searching in all the tabs in all the opened connection tabs will take a toll on the responsiveness of SQLyog.

 

Regards,

Sibin

[Sibin A S]

Hi,

 

The saved job will remember the connection details that were entered while saving the job. But only the connection name is not displayed while you edit the saved job. This is because, there can be some instances/cases where you may change/rename the connection name in the Connection Manager after saving the job. Therefore, this may cause an overhead to check for the connection name everytime from the connection manager.

 

“So I can not edit the job, I have always to enter all the data again” >> You can edit the job and save the changes as there is no issues as we have checked it ourself and works fine.

 

Regards,

Sibin

[Sibin A S]

Hi,

 

We have replied to you in the ticket that you have created. 

 

Regards,

Sibin

[Sibin A S]

All the connections (out of the saved connections) that were open before SQLyog is closed will be saved in the ‘connrestore.db’ file and will be restored sequentially while re-opening SQLyog.

 

Please note, the connections will be saved and restored only if ‘Restore session on startup’ option is selected.

 

Regards,

Sibin

[Sibin A S]

Hi Mitch,

 

We currently do not have any value set for defining the connection timeout for establishing connection. For SSH connections though, the timeout is set to 30 sec from SQLyog. For the rest, it is api default. We are looking into setting it to a lower value but many things have to be taken care for that. Changes have to be made in ini file (for maintaining it during restore) and connection details, if we provide the connection level timeout setting.

 

We have added your request into our request/issue tracker, here >> https://github.com/webyog/sqlyog-community/issues/2120

 

Regards,

Sibin

[Sibin A S]

Hi,

 

You may create a ticket by sending a mail at ‘[email protected]‘ and send the dump files for security reasons. By telling crash, does SQLyog just close/vanish or do you get any pop-up that displays that SQLyog has crashed along with the file path where the dump is saved? Please elaborate in the ticket and also mention any specific step which you perform that causes the crash if any.

 

Regards,

Sibin

[Sibin A S]

Hi,

 

The Encryption works fine at our end. Can you please try the following steps,

 

1. Reboot Windows. Note that on Windows10 shutting down the system and starting again is not a reboot (the system will hibernate instead). You will need to select ‘reboot’ explicitly.
2. When system has rebooted, turn your AV and similar software off temporarily.
3. Try to start SQLyog and do not start other programs. Does this still happen?

Regards,

Sibin

[Author]

Posts