Connection List Disappeared

[Justmade]

The Connection List (and all custom settings) suddenly disappear and become like new installation today.

The computer become busy and I want to reboot the computer. I close sqlyong and it is closed normally thought slow. Then I close my computer and force close some non-responding applications.

After the reboot and starting up SQLYog, it appear to be newly installed and lost all setting and connections. As I was using 10.4.0-1 and it had prompt me serveral time to update already, I updated to the latest version of 10.5.1-0 and try again and all setting still gone.

I search “sqlyog” in my harddisk and did not see any ini backup.

Is it possible for me to restore the connection and settings?

Thank you in advance for your kind help.

[peterlaursen]

If you don't find the sqlyog.ini it could be because it is stored in a hidden folder (user's 'AppData' folder) with Windows default setting.

It is/should be here (on Windows Vista or higher): {System_drive}:Users{user}AppDataRoamingSQLyogsqlyog.ini. To unhide the AppData folder go to control panel .. folder settings and check 'show hidden folders'.

However since SQLyog cannot display connections, the file is either not there or it is corrupted/unusable. If you are using WIndows 7 or higher and have 'System Restore' turned on you may restore the complete folder C:UsersPeterAppDataRoamingSQLyog. Just navigate to it from WIndows explorer, right-click, select 'properties', go to 'previous vesions' tab and select a 'shadow copy' from before this happened for restore (make a copy of the existing folder first just in case ..) for restore. If you have a backup of the complete system or of your 'user profile' you may of course also restore from there.

As the sqlyog ini is user-specific it will not be found it you login to the system with another user account than what was used when it was created.

One possible reason for this could be that some 'security software' has quarantined or deleted the file. Or some 'malware' could have deleted or corrupted it. If you find the file in its position you may send us to us privately to [email protected] as we would then like to know why SQLyog is not able to use it.

[Justmade]

'peterlaursen' wrote:

However since SQLyog cannot display connections, the file is either not there or it is corrupted/unusable. If you are using WIndows 7 or higher and have 'System Restore' turned on you may restore the complete folder C:UsersPeterAppDataRoamingSQLyog. Just navigate to it from WIndows explorer, right-click, select 'properties', go to 'previous vesions' tab and select a 'shadow copy' from before this happened for restore (make a copy of the existing folder first just in case ..) for restore. If you have a backup of the complete system or of your 'user profile' you may of course also restore from there.

I can find sqlyog.ini but it is newly created and do not contain any former settings. It is just that I cannot find the ini backup (which when I search the forum I saw other mentioning). Anyway, your solution work very well and I am happily having all the former connections (up to last restore point) appear again.

Thank you very much for your prompt help.

[Author]

Posts