MySQL DBMS – /bin/sh: 1: /usr/bin/mysql: not found

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
or
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:

  1. Make sure mysql-client is installed

    To do this, please execute:

    mysql -v

    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
  2. Find the path where MySQL is installed
    which mysql
  3. 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

  1. 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.

    Thanks

    1. Hi Srini,

      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.

      Thank you!

Leave a Reply

Your email address will not be published. Required fields are marked *