If you get one of the following error messages during the setting up of SqlBak on Linux or during the execution of a backup job:
MySQL DBMS – /bin/sh: 1:/usr/bin/mysql: not found
MySQL DBMS – /bin/sh: 1:/usr/bin/mysqldump: not found
it means that the SqlBak app could not find the path to the MySQL executables. By default, SqlBak searches for MySQL files in the /usr/bin/mysql directory.
How to resolve the problem
Follow these simple steps to resolve the issue:
Make sure mysql-client is installed
To do this, please execute:
In response, you should receive something similar to:
mysql Ver 14.14 Distrib 5.7.29, for Linux (x86_64) using EditLine wrapper
If you get an error message that the command was not found, then please install mysql-client through the standard package manager. For Ubuntu, run the following:
sudo apt-get install mysql-client
Find the path where MySQL is installed
Specify MySQL path for SqlBak
sudo sqlbak -us -ms <your/path/to/mysql>
2 thoughts on “MySQL DBMS – /bin/sh: 1: /usr/bin/mysql: not found”
Trying to setup incremental backup with LAMPP mysql in ubuntu. The fullback runs fine.
Have updated the path for mysql and mysql dump for SQLBak.
But currently get the following errorL
“Job execution error: #[DBMS-MYSQL:100001] /bin/sh: 1: mysqladmin: not found”
Please advice on how to fix the same.
Sorry, but for now, there is no way to specify a path to mysqladmin directly, but we plan to add this option later.
For now, to resolve the issue, please add the directory where mysqladmin is to the PATH variable for the superuser, you can find more details on how to do it on the web. Note, all the paths should be done as a superuser.