Configuration

[expired user #8308]'s profile image [expired user #8308] posted 10 years ago in General Permalink
Hi all,

In the settings there is a field to fill in the location of MySQL command line programs.

I am on Windows 7. Witch command line programs are they referring to?

Thank you,

Sebastiaan.
kalvaro's profile image kalvaro posted 10 years ago Permalink
The helper software that comes with MySQL Server. You'll have it if you've installed a local server (not if you only connect to remote servers).
ansgar's profile image ansgar posted 10 years ago Permalink
Exactly. That's the "bin" directory where for example mysql.exe resides.
[expired user #8308]'s profile image [expired user #8308] posted 10 years ago Permalink
The mysql server (mariadb) is on another computer than heidisql.

Is it a good idea to install mysql server witch includes the 'bin' directory on my heidisql / windows machine?

In other words do the bin tools also work on a remote server?

Does anybody know what those tools include?

Thanks a bundle.

Sebastiaan.
ansgar's profile image ansgar posted 10 years ago Permalink
These tools can connect to your local or to remote mysql servers. For example, mysqldump.exe expects the "--host=XYZ" parameter, which is an IP or host name. So, it's quite handy to have them locally.

And, to answer your initial question, this is the directory you can fill into the HeidiSQL setting "MySQL command line programs". With this directory set, you can click "Tools" > "Launch command line". And probably more in the future.
kalvaro's profile image kalvaro posted 10 years ago Permalink
This is one of those situations where the mere need to ask suggest you don't need it ;-)

In any case, you don't need to install a server you aren't going to use. If the MySQL installer doesn't allow to uncheck server components (haven't tried myself) you can always get the separate download.
[expired user #8308]'s profile image [expired user #8308] posted 10 years ago Permalink
Hi Kalvaro,

Thanks a million Hero !

Sebastiaan.

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