distal-attribute
distal-attribute
distal-attribute
distal-attribute

Import Servers from an older version

User, date Message
Written by paulb
2 years ago
Category: HeidiSQL portable
9 posts since Mon, 22 Oct 12
I installed HeidiSQLPortable7.0, and imported settings with the proper command. However, I see that my list of serers has not been imported from the previous version.
Hoq can I perform this?
I've got very plenty of Servers defined...
Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
Settings for the portable are placed into the portable_settings.txt file, with an additional, temporary folder in registry while the application runs. Probably the import does not work in portable mode.

What file did you try to import? Was it a .txt file or a .reg file? If you previously were using the portable version, you should just overtake the portable_settings.txt, nothing more.
Written by paulb
2 years ago
9 posts since Mon, 22 Oct 12
It's odd, I have the portable_seetings.txt in the newer version (7.0), ma I don't find it in the old version (4.0).
Despite this was a Portable Version (in fact, it is placed in the HeidiSQLPortable4.0 folder), I find a subfolder called "Registry" and a .reg file, which is the one I tried to import.
Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
HeidiSQL 4.0 portable used a different approach for storing its settings. Well, it's indeed too old to get settings imported. You should have made updates inbetween. However, you can do the following:
* exit all heidisql.exe instances (portable or not)
* start regedit.exe
* navigate to HKEY_CURRENT_USER\Software\HeidiSQL\
* I guess you see a subkey "Servers", imported from that .reg file, right?
* if yes, you just need to start HeidiSQL without the portable_settings.txt in place (just rename or move that file). Now click File > "Export settings", and chose "portable_settings.txt" in the HeidiSQL folder.
* that's it. Exit the non-portable instance of heidisql.exe, and restart, now in portable mode. You should see sessions now.
Written by paulb
2 years ago
9 posts since Mon, 22 Oct 12
I did it as you've suggested.
At last I've got a portable_settings.txt file with all my servers (dimension: 108kb).
However, if I run HeidiSQL (the portable 7.0 version) a second time, I mean after having created this file, it seems not to read it, because the list of servers is empty, and if I click "Cancel" the new portable_settings.txt is 3 kb and with no servers.
Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
Then, you did not export the portable_settings.txt to the directory where your portable Heidi resides, did you?
Written by paulb
2 years ago
9 posts since Mon, 22 Oct 12
Yes, I did.
I renamed the existing portable_settings.txt.
Then I ran HeidiPortable7.0 without this file, in fact it read servers from th register and I saw all them.
Then I exported settings to the portabl_setting.txt in the folder of the Portable Heidi 7-0 (the same place eherre there was the renamed file).
I saw that this file contained all my servers, in fact it grew till 108 kb.
I ran Heidi Portable 7.0 anther time, and this time it seemed not to read the settings, because it showed me no Servers.
I exited the program, and the portable_settings.txt became 3kb, losing all servers that were written in the export.
Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
Hm, if you want you could export again, and send me that 108k file, so I can analyze and probably fix what's wrong. Be aware that it contains encrypted passwords, but be sure I won't use any of them and I'll delete the file irreversible afterwards.
Written by paulb
2 years ago
9 posts since Mon, 22 Oct 12
I sent you the file by e-mail.
Is there another way to upload it in the post?
Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
No, this forum cannot handle uploaded files. However, the file you sent me was a .reg file. Please update your Heidi build.
Written by paulb
2 years ago
9 posts since Mon, 22 Oct 12
I downloaded the Portable version yesterday from this site......
This is the result of the download:
22/10/2012 14:35 3.263.963 HeidiSQL_7.0_Portable.zip

And this is the folder unzipped:
Directory di D:\Program Files\HeidiSQLPortable7.0

03/05/2006 19:58 18.330 gpl.txt
12/02/2012 14:07 5.300.224 heidisql.exe
06/12/2011 13:17 2.279.752 libmysql.dll
12/02/2012 13:15 1.905 license.txt
20/11/2010 18:56 0 portable_settings.txt
21/06/2011 06:29 3.601 readme.txt

Obviously, now in my folder there is the new portable_settings.txt that I have exported.
I created this selecting "File>Export Settings", the menu presented me ".reg" as default extension, I modified it in ".txt", selected the name of the file, and the result was the file I sent you.
What was wrong?
Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
The ZIP file does not have the latest build. You need to check for updates and click the button "Download and install build ...", within HeidiSQL > Help > "Check for updates". Or download the latest heidisql.exe build from the download page, see it in "Nightly builds". That's important as the export format has changed recently, from registry file to a homebrewn text format.
Written by paulb
2 years ago
9 posts since Mon, 22 Oct 12
Ok, it finally works!
Thank you very much for your support and the time you spent!
Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
Glad to hear that!

I'll go and delete your mail with the attached settings file now.
 

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