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 10 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 10 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 10 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 10 years ago Permalink
Did I really double thanks? Whatever, don't see an edit button

Triple thanks.
ansgar's profile image ansgar posted 10 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 7 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 7 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 7 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\
timint's profile image timint posted 3 months ago Permalink

Hey guys, just wanted to step in and say I reinstalled Windows. All my appdata is still there but I completely forgot about HeidiSQL and the regedit entries of hosts. Windows do save the user appdata in a folder but not the divorced registry. :(

ansgar's profile image ansgar posted 3 months ago Permalink

If you have the old Windows installation in a backup, then there's a way to restore settings from registry, including your sessions and general application setup. But your question reads as if you have no backup, or?

timint's profile image timint posted 3 months ago Permalink

The problem is that backup software like Backblaze don't backup the Windows folder. I read the registry is stored in %SystemRoot%\System32\config.

But some user related registry is in %UserProfile%\Ntuser.dat

Do you think HeidiSQL uses the records in ntuser.dat?

timint's profile image timint posted 3 months ago Permalink

Wohoo.. I did it! 😃

Windows stores ntuser.dat in the Windows.old\Users\Username folder. I managed to extract HKEY_CURRENT_USER\Software\HeidiSQL\Servers\ using MiTeC Windows Registry Recovery. Good to have a solution to fall back to.

It does not affect my opinion in stop using the Windows registry for the server profiles. There are times when it's a benefit being the odd man sticking out. And there are times when it's just better to blend in with the others. Honouring the %appdata% folder as one solid place for all userdata, instead of having storage spread around would be convenient I think, for most. 😉😁

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.