[swampthang]

ChrisB wrote on Nov 13 2007, 01:55 PM:

two questions:

a. Where is this information normally stored? My sqlyog.ini file in AppData …

b. Is there any chance of recovering the old information?

Thought I'd help to clear this up for Vista and XP users. I got the following reply from support:

If the program version you were using earlier is less than 6.06 then in the installation folder sqlyog.ini will be renamed to sqlyog.bak.ini and that file will be copied to the Appdata folder.

Still You can copy a sqlyog.ini file to the following path

For vista: C:Users{user}AppDataRoamingSQLyog

For Xp: C:documents and settings{Users}Application datasqlyog.

What I found was this…

The data of the old file was kept in the new sqlyog.bak.ini file located in the SQLyog program folder (on my box it is in C:Program FilesSQLyog Enterprise)

Here's what I did to restore all:

1. Open the sqlyog.bak.ini file located in the new program directory using notepad (or I like Notepad++)

2. Select all and copy to the clipboard

3. Go to the directory listed above for your operating system. (Mine is: C:Users{user}AppDataRoamingSQLyog)

4. Open the sqlyog.ini file in notepad and replace the stuff that's in there with what you copied from the sqlyog.bak.ini file in the Program's directory.

5. Save it and close and you're good to go!

I noticed that there were some differences in the data for each connection in the new ini file so I didn't just want to save the old ini file into that directory. Hope that helps.

[Author]

Posts