'mysql.exe' is not Recognized as an Internal or External Command, Operable Program or Batch File
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”.
The causes for the issue may be:
- When the path to the mysql.exe tool, which is used for the DDL 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.
- 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 “Choose a Target Database” 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 DDL 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.