Request: A cancel button when running an SQL Export from the mass table editor

[expired user #5084]'s profile image [expired user #5084] posted 14 years ago in Feature discussion Permalink
Hi,
When I export a large database and it begins to error on some tables, there's no cancel button to stop the operation. I understand if you can't cancel a query, but it would be great if we could stop the batch from executing further.
Code modification/commit bec6422 from ansgar.becker, 14 years ago, revision 6.0.0.3774
Turn close button into cancel button for processing time, and break loop in TfrmTableTools.Execute when clicked. See http://www.heidisql.com/forum.php?t=8238
ansgar's profile image ansgar posted 14 years ago Permalink
Yes, reasonable, and doable since every status update calls Application.ProcessMessages which is required to catch any user click on buttons. Close button is now a cancel button in r3774. Just breaks the main loop if clicked.
-PSi-'s profile image -PSi- posted 2 years ago Permalink

Hello!

What happened to this feature request? I'm currently exporting a table using "Table tools" "insert ignore..." to another server. HeidiSQL is apparently doing this in lots of 4,096KB.

I realised that I had just renamed the target table so all (1.5GB) will be exported, as new table was created by the batch. Pressing "Cancel" won't help. New "Insert ignore..." rows keep on appearing on the command list screen...

I wonder why it is, that the "Table tools" could not just stop the batch, just let the ongoing lot of 4,096KB go, and then stop.

Is the batch operation done by sending a batch command of some sort to MySQL server and HeidiSQL has no way of touching the batch run, or what? Why HeidiSQL is not in charge of the batch run?

ansgar's profile image ansgar posted 2 years ago Permalink

The cancel button produces a log message saying:

Processing cancelled by user, waiting for current object to finish ...

So it's not possible to cancel the export of the currently processed object. The code would need some more careful adjustments to do that.

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