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 5 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 4 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 4 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 2 weeks 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 2 weeks 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 2 weeks 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 2 weeks 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.