Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Where are the user settings saved?

radgh's profile image radgh posted 9 years ago in Installation Permalink
I just installed Windows 7 on an SSD, and I'm migrating my settings over. Most programs have saved their settings in %appdata%, heidisql does have a folder there, but it does not remember my connections and it does a "First time using heidi SQL?" thing when I open it.

Where are these user settings stored?
ansgar's profile image ansgar posted 9 years ago Permalink
In your registry, like many other applications do. Settings are located in HKEY_CURRENT_USER\Software\HeidiSQL\

If you are using the portable version, you have a portable_settings.txt in the directory besides heidisql.exe.
radgh's profile image radgh posted 9 years ago Permalink
That's pretty annoying, considering I've repurposed the harddrive for storage and wiped the Windows folder (still have users/program files for grabbing other stuff). I don't think I can access the old registry now.

Oh well, that just means I have to dig around in gmail to find my client's information again. Could be worse.

Thanks

Thanks.
radgh's profile image radgh posted 9 years ago Permalink
Did I really double thanks? Whatever, don't see an edit button

Triple thanks.
ansgar's profile image ansgar posted 9 years ago Permalink
Hehe, thanks, taking that as a compliment.

For the next time, remember to export settings to a backup file, using "File" > "Export settings", before wiping your Windows. Or, alternatively, always use the portable version, so you always have latest settings in a file.
timint's profile image timint posted 3 months ago Permalink

Me too having this issue. I have successfully migrated the settings for 50+ applications by copying the AppData folders, except for HeidiSQL. I have created a feature request for this as AppData is pretty industry standard 2021.

BubikolRamios's profile image BubikolRamios posted 3 months ago Permalink

I assume, looking at that exported file, it also contains saved queries ? So it actually sucks up everything from registry ?

ansgar's profile image ansgar posted 3 months ago Permalink

Most of it, yes. What is currently stored and restored from elsewhere:

  • query tab settings: C:\Users\[userid]\AppData\Roaming\HeidiSQL\tabs.ini
  • automatically stored query tab contents: C:\Users\[userid]\AppData\Roaming\HeidiSQL\Backups\
  • session logfiles: C:\Users\[userid]\AppData\Roaming\HeidiSQL\Sessionlogs\
  • snippet files: C:\Users\[userid]\Documents\HeidiSQL\Snippets\

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.