Show SQL LOAD DATA option, removed?

ahamilton's profile image ahamilton posted 3 years ago in General Permalink

Maybe I'm crazy, but I specifically remember one of the main things I use HeidiSQL for is going to a CSV file, selecting my table and columns, selecting server side (so LOAD DATA), and using HeidiSQL to generate the SQL command that I need to use in my python scripts.

In the latest version, I don't see this option anymore? Has it moved? Been removed, etc? I've looked through all the options, and sadly it's been a while since I've had to do it, but I'm pretty sure it was just on the import CSV screen before. I can't find anything similar now, and it's a very useful tool (to be able to run HeidiSQL on my Windows machine, generate the load data script, and then run it on my clustered linux boxes where the file sizes are sometimes dozens of GB large.

Can someone help? Is this just gone or am I just not seeing it?

--Andy

ansgar's profile image ansgar posted 3 years ago Permalink

See

  • Tools > Import CSV file
  • or the next but one button right besides the refresh button on the main toolbar

Description

ahamilton's profile image ahamilton posted 3 years ago Permalink

Thank you for that. The problem isn't that I can't find the screen, the problem is that the screen doesn't show me the SQL command it's running anymore.

I get any errors back from MySQL in the command window, but, whether it just showed it normally, or there was a checkbox to generate the SQL but not run it before, I KNOW this used to be a thing, because it's how I generated all the SQL for my Python scripts. I can't find it now, sadly.

--Andy

ansgar's profile image ansgar posted 3 years ago Permalink

The generated SQL should be visible in the log panel at the very bottom, at least if you did not disable logging of "Internal SQL queries" in Preferences > Logging. And please note that the import dialog uses that LOAD DATA syntax only for the "Server parsing" method, not when you select client side parsing.

There was never a checkbox for previewing the generated SQL commands before it was executed.

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