Import SQL

BubikolRamios posted 6 years ago in General
1.In explorer/open sql file with HSQL
2. It says it is big / want to open directy / no loading into editor
3. Problem: The encoding of file did not get recognized, hence strange characters are getting into db, duplicate key violation, etc. Although sql file is perfectly OK.

1.Inside HSQL:
Import/load sql file ---> window with dropdown pops up, with manual encoding settings.

The same thing should be under A somewhere.
kalvaro posted 6 years ago
Open from within HeidiSQL, rather than Windows explorer. The program's dialogue allows to pick an encoding.

Either go to "Tools-> Load SQL file" or click the appropriate button in the toolbar.
BubikolRamios posted 6 years ago
Point beeing: once user gets used to do it from explorer , and bump against 'not readable encoding', user wastes a lot of time to convert encoding with various things, of which none works.

Heidi has a solution, but is kind of hidden.
ansgar posted 6 years ago
"normal" UTF-8 or Latin1 files should get auto-detected correctly. I wonder why it does not detect your file encoding already.
BubikolRamios posted 6 years ago
The thing was transported over the net , around the corners. But that kind of thing was obviously detected by you also. As it is said , opening .sql from within heidi: Encoing: Autodetect(may fail).
Krammig posted 7 months ago

"Tools-> Load SQL file"

This no longer appears in v9 of Heidi, is there a replacement for this ?


ansgar posted 7 months ago

Yes, this menu item was moved to File : Load SQL file

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