A query that I've used for years in HeidiSQL no longer works -- since I upgraded to Windows 10, from Windows 8.1. HeidiSQL now uploads only about 39,000 records, and then goes dormant, but the entire dataset actually contains about 120,000 records. There are no error messages; the progress bar just stops.
For further testing, I've reverted to the exact HeidiSQL version (9.5.0.5196, 64 bit) and dataset that I used successfully last December, but even that fails. (I'm using SSH tunneling to upload tab-delimited text data to a MyISAM table on a remote Linux web server.)
My other queries run fine on the remote server. It's just the LOAD DATA LOCAL INFILE query that doesn't complete. I wonder if something is timing out. In the Session Manager, I've set the plink.exe timeout to 30, and "Ping every X seconds" to 5.
Are there any other settings I should check? Is there a way to diagnose this?
I would sincerely appreciate any suggestions about how to get my upload query working again.
Thanks.