Command Line option missing? 7.0.0.4053

[expired user #6458]'s profile image [expired user #6458] posted 12 years ago in General Permalink
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)
[expired user #6458]'s profile image [expired user #6458] posted 12 years ago Permalink
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's profile image ansgar posted 12 years ago Permalink
The directory input is definitely there. If not you have an older build running. Please verify with Help > Check for updates.
[expired user #6458]'s profile image [expired user #6458] posted 12 years ago Permalink
I definitely installed 7.0.0.4053. Just checked.
ansgar's profile image ansgar posted 12 years ago Permalink
So you did NOT check Help > "Check for updates" - r4053 does not have that, and it is not the latest build, which is r4160.
[expired user #6481]'s profile image [expired user #6481] posted 12 years ago Permalink
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's profile image jfalch posted 12 years ago Permalink
the mysql command line client is called mysql.exe on windows, and mysql on unix-like systems.
what kind of system are you running ?
[expired user #6481]'s profile image [expired user #6481] posted 12 years ago Permalink
Operating System: Windows 7 Home Premium 64-bit (6.1, Build 7601) Service Pack 1 (7601.win7sp1_gdr.120503-2030)
jfalch's profile image jfalch posted 12 years ago Permalink
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.