Cannot Use Backup DB Utility after Host Tranfer

[JE2009]

I had the backup utility plugin working on a test store under my host. I tranferred the store to my client's host (fatcow), well now the plugin does not work it breaks with "result code: 127" "0 => sh: mysqldump: command not found" "ERROR: Could not locate the MYSQLDUMP backup utility. BACKUP FAILED".

I found some posts which mentioned the problem was the way the host setup the mysql dump. I contacted the host and this is the message they send me:

"Since cgi and apache are running off different servers I would recommend using the -h command after the mysql dump. You should then be able to just reference the sql host and database credentials to perform the dump.."

Now I am a newbie when it comes to PHP, so I have no clue how to implement what they told me. As a long shot I tried modifying the file backup_mysql.php under admin/languages/english. Well it didin't work.

From:
"define('LOCAL_EXE_MYSQLDUMP', '/usr/bin/mysqldump'); // used for backups"

to the following:
"define('LOCAL_EXE_MYSQLDUMP', '/usr/bin/mysqldump.sh'); // used for backups"

Any suggestions how to make it work?

I am using the following:
zen cart 1.3.8
backup_mysql_plugin_v1-3

[DrByte]

... I would recommend using the -h command after the mysql dump. You should then be able to just reference the sql host and database credentials to perform the dump.."

The addon already operates that way.
The problem is more likely that the mysqldump binary doesn't exist on *your* server, or (and this is very common) the client isn't kept up-to-date since few people use command-line tools on a server other than the one the database is actually on.