Hi there
This redhat/linux server running apache when I run the command below in shell command prompt it would work but however when run as cron it would just say mysqldump not found.
For instance the command below for backing up one our our database:
mysqldump --opt -u foo -pfoo database > database.sql
when executed from shell prompt will work just fine, but try and run this as cron and it would say that there is no such command or cannot find mysqldump.
The shell script for the cron above that would NOT work would be:
#!/bin/sh
mysqldump --opt -u foo -pfoo database > database.sql
The shell script for the cron above that WOULD work would be:
#!/bin/sh
/home/mysql-3.23.56/bin/mysqldump --opt -u foo -pfoo database > database.sql
Does anyone have any idea? I wrote to my server ppl but they yet to reply, they hardly help anyways.... grrrr
thanks a lot.
This redhat/linux server running apache when I run the command below in shell command prompt it would work but however when run as cron it would just say mysqldump not found.
For instance the command below for backing up one our our database:
mysqldump --opt -u foo -pfoo database > database.sql
when executed from shell prompt will work just fine, but try and run this as cron and it would say that there is no such command or cannot find mysqldump.
The shell script for the cron above that would NOT work would be:
#!/bin/sh
mysqldump --opt -u foo -pfoo database > database.sql
The shell script for the cron above that WOULD work would be:
#!/bin/sh
/home/mysql-3.23.56/bin/mysqldump --opt -u foo -pfoo database > database.sql
Does anyone have any idea? I wrote to my server ppl but they yet to reply, they hardly help anyways.... grrrr
thanks a lot.