1.try to import sql file
2.breaks due to duplicate
3. as consequence the table is locked somehow -->
if I run another instance of hsql I see:
Waiting for table metadata lock
4. Problem: if I try to export onto that table with export dialog, hsql freezes.
Realy bad,as there is no auto query tab save (-:
kill the processses in another instance, not all can be killed, then you can close (but not cancel) export dialog in first instance, close connection to target db in firts instance.
BTW: not cler to me, how can I get duplicate problem at importing sql file which was created with sqldump, but having no prob exporting that table with heidi.
Not to mention that I also see no problem with that record that heidi report as problematic at sql file import.
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.