Software World of Harshad Pandit

Hi

Plz, help me out i want to allow one of my linux user to run this below bash script to take mysql database backup.

[b]Shell Script:[/b]



#!/bin/bash
TIMESTAMP=`date +%m-%d-%y-%H%M`

cd /home/backups/mysql

find /home/backups/mysql/*.tar.gz -mtime +7 -exec rm -f {} ;


# my database
DBNAME=my_database
mysqldump --opt -c -e -Q -u MYSQL_USER -p'MYSQL_PASSWORD' $DBNAME > $DBNAME.sql
tar czpf $DBNAME.$TIMESTAMP.tar.gz $DBNAME.sql
rm -f $DBNAME.sql



But when i am running this script as a normal user it is giveing me an error of "Permission denied"

Thanks
Harshad Pandit
alias(PHP Pandit)
Harshad Pandit's Blog