Import Of Connections From Previous Version

[bcrumrin]

I just upgraded to 8.53 from 5.15. Is there a way to load my connections into the new version (without doing it by hand)?

Thanks,

Brian

[Mahesh]

Hi,

You need to copy the 'sqlyog.ini' file from v5.15 installed folder to Application Data folder where new .ini is created.

Note: If you install v8.5 on the same path of v5.15, “sqlyog.bak” will be created in installed folder and all the connections would have been moved to AppData folder.

The file position is:

Windows 2K/XP/2003:

C:Documents and SettingsUserApplication DataSQLyog

Windows Vista/2008/7:

C:Users{user}AppDataRoamingSQLyog

Note that 'AppData' folder is a hidden folder (you unhide from Control Panel … Folder Options) and also note that some folders may have localized names.

Please feel free to ask any questions.

[bcrumrin]

'Mahesh' wrote on '08:

You need to copy the 'sqlyog.ini' file from v5.15 installed folder to Application Data folder where new .ini is created.

Note: If you install v8.5 on the same path of v5.15, “sqlyog.bak” will be created in installed folder and all the connections would have been moved to AppData folder.

The file position is:

Windows 2K/XP/2003:

C:Documents and SettingsUserApplication DataSQLyog

Windows Vista/2008/7:

C:Users{user}AppDataRoamingSQLyog

Mahesh,

Thank you very much for this. I was able to find and merge my configs perfectly with this help.

Turned out my v5.15 sqlyog.ini was in this directory (running 7 now, but the path maybe related to my upgrade to Vista from XP [or maybe from Vista to 7]):

C:Users{user}AppDataLocalVirtualStoreProgram FilesSQLyog Enterprise

Any my v8.5 (now 8.6) config files were stored where you indicated for 7:

C:Users{user}AppDataRoamingSQLyog

I did combine two configs, so I only added the [Connection X] sections from the v5.15 ini and renumbered them into the sequence for the new 8.6 config. Much easier than recreating the 20 entries by hand (I didn't have all the passwords anyways). Now I can remove the old SQLyog v5.15 from my machine.

Cheers,

Brian

[Author]

Posts