'mysql.exe' is not Recognized as an Internal or External Command, Operable Program or Batch File

Symptoms

On the import into the MySQL database the following error arises: “'mysql.exe' is not Recognized as an Internal or External Command, Operable Program or Batch File”.

Causes

The causes for the issue may be:

  • When the path to the mysql.exe tool, which is used for the <acronym title="Data Definition Language">DDL</acronym> and data loading, is not specified neither in the PATH system environment variable nor in the Windows registry.
  • There is no MySQL Server “Client Programs” installed on the computer.

Solutions

  • SQLWays automatically searches the PATH environment variable and the Registry for the entry with the path to the installed MySQL client or server programs and uses this information to specify the path to the BIN directory containing mysql.exe tool used for SQL code and data load explicitly in the batch file.
    But if there is no such information in the system, it is required to specify the path explicitly on the “Specify Import Options” page. Please, see the screen-shot below for the example:

  • If no “Client Programs” are installed at the computer where the import is running, it is required to install them. To do this please run the installation of the server, but exclude all the options except for the “Client Programs” as it is shown in the picture below:

    After the installation the mysql.exe command line tool used to run the <acronym title="Data Definition Language">DDL</acronym> and data import, will reside in the folder you specify during installation. Please, refer to the first point of this article to setup the path to the mysql.exe tool.



More about Ispirer Systems