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

Command Line option missing? 7.0.0.4053

arrow_runner posted 2 years ago in General
I just discovered HeidiSQL today and am still learning MySQL so I may have made a simple mistake. Anyway I installed the app and wanted to use the command line function to follow along in the textbook I'm using but I don't see the option listed in the menu. The text below from this site says that I can change where Heidi looks for the mysql.exe file, but I don't see anything in the Misc tab either.

"After having established a MySQL or MariaDB connection, HeidiSQL offers to launch a command line window (located in the "Tools" menu). This executes mysql.exe from the directory which is set in Tools > Preferences > Miscellaneous."

There is nothing pertinant to what I'm looking for in that tab. I installed HeidiSQL and then MySQL workbench (which appears to have the command line)
arrow_runner posted 2 years ago
Well I tried using the standalone version of the files and they're working fine. I was having the problem above when using the installation file with Windows 7 64. I can just use it like it is.
ansgar posted 2 years ago
The directory input is definitely there. If not you have an older build running. Please verify with Help > Check for updates.
arrow_runner posted 2 years ago
I definitely installed 7.0.0.4053. Just checked.
ansgar posted 2 years ago
So you did NOT check Help > "Check for updates" - r4053 does not have that, and it is not the latest build, which is r4160.
Mlkrehl posted 2 years ago
I did check for updates and am currently running the latest version.

It's saying that in order to launch mysql.exe shell I need to tell HeidiSQL the path to MySQL command line bianaries. Since I do not have a filename running a search will be near impossible. I've tried a general search of .bin files but I still have no idea which files I'm looking for.
jfalch posted 2 years ago
the mysql command line client is called mysql.exe on windows, and mysql on unix-like systems.
what kind of system are you running ?
Mlkrehl posted 2 years ago
Operating System: Windows 7 Home Premium 64-bit (6.1, Build 7601) Service Pack 1 (7601.win7sp1_gdr.120503-2030)
jfalch posted 2 years ago
Ok. Do you have installed the MySQL server locally (ie on this same windows), or on another (eg unix) machine ? If installed locally, mysql.exe should be in the server installation┬┤s bin\ directory.

If not, download the 5.5.25 windows server MSI installer package (x86 64bit) from mysql or mariadb, and temporarily install it. Copy from its bin\ directory mysql.exe, then uninstall the server again.
Also, copy the libmysql.dll found in the Heidisql installation directory to where you put mysql.exe.
That should do it.

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