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

Export data to SQL, problems?

User, date Message
Written by westmatrix
7 years ago
Category: Import/Export
82 posts since Wed, 11 Apr 07
Hi
I tried for the third time today to export the database to SQL files and it freezes.

Version 3 Revision 572

I thinks it's the latest, but export function works on single tables but not entire database.

Any ideas why or how to fix?
Cheers
Written by rosenfield
7 years ago
127 posts since Wed, 24 Jan 07
Some code paths in HeidiSQL still use blocking SQL calls. There are non-blocking versions, but those are not safe for reentry (yet), so there are some places where they cannot be used. Until that's fixed, the blocking version might make the GUI stop repainting, which would make it seem like HeidiSQL is completely frozen.

Or you may be looking at a real bug.

Either way, just open a bug on http://bugs.heidisql.com/, where you can upload test data to the developers so they can reproduce and fix the problem.
Written by westmatrix
7 years ago
82 posts since Wed, 11 Apr 07
Thanks have done it now.

Cheers
Written by rosenfield
7 years ago
127 posts since Wed, 24 Jan 07
You forgot to upload a copy of the failing table ;-).

(If private data like passwords are involved, you might want to take a copy of the frm+MYD+MYI files, run UPDATE tblogin2 SET password='' or similar to clear out personal stuff. Remember to verify that the copy also causes a failure.)
Written by rosenfield
7 years ago
127 posts since Wed, 24 Jan 07
I wanted to give you a link to a place where you can upload files to the developers privately, but in persona messaging seems to be disabled in this phpBB. Could you leave an email address here?:
http://sourceforge.net/support/tracker.php?aid=1728104
Written by westmatrix
7 years ago
82 posts since Wed, 11 Apr 07
How do I upload a file afte I submitted the data?
Also how did you get the link?

Cheers
Written by rosenfield
7 years ago
127 posts since Wed, 24 Jan 07

westmatrix wrote: How do I upload a file afte I submitted the data?


Not sure you can, unless you create an account. Or you can just open a new bug (leave your email address) if you don't want to create a sf.net account.

westmatrix wrote:
Also how did you get the link?


Picked up the syntax somewhere within the sf.net tracker system...
Written by westmatrix
7 years ago
82 posts since Wed, 11 Apr 07
Ok cool but that SF.net system wont allow me to view my email address?
Will resubmit later as busy coding mail scripts for site now.
Thanks
 

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