Hi ,
I am new to shell scripting I want to make script as to execute followng command

mysqldump -u (user name) -p(password) database name>filename.sql

this file saves with current date and time

and execute automatically at particular time which I give

Will it execute the same time every day? Then you should add it to cron. (You'll need to search the forums or FAQ for how to do that.)

To make the script, just edit a file and name it "backupmysql.sh" or something. Then cut-and-paste and edit the fields to suit your needs:

I made shell script but when I execute through shell command it execute successfully but when when i use crontab it execute the backup but shows 0 kb I did following step

step 1 : my shell script is

#! /bin/sh
USER="root"
PASS="nxsmasc"
DB="sme"
DATE=`date +%y-%d-%m`
#date=`date +%F%R` #space between date and +
#longdate=`date +%m%d%y%h%mm%ss`
mysqldump -u $USER -p$PASS $DB>/home/today_sme-$DATE.sql
echo "done"

I stored this file as /usr/bin/bck_sme.sh

step 2: when i execute comand sh bck_sme.sh it excutes successfully

step 3: now through crontab

typed command crontab -e

following entry
29 19 * 12 0-6 /usr/bin/bck_script.sh

but when it execute it shows 0 k file

Please tell where could be problem

check your mail box, read error message. maybe you will find a way

as i checked mail following found

Subject: Cron <root@ninex> /usr/bin/bck_script.sh
Date: Mon, 15 Dec 2008 20:01:01 0530 (IST)
Content-Type: text/plain; charset=UTF-8
Auto-Submitted: auto-generated
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/root>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=root>
X-Cron-Env: <USER=root>
/usr/bin/bck_script.sh: line 12: mysqldump: command not found
done

but this execute by command sh bck_script.sh
not through crontab

As always, read the FAQ first!

You just have to fix your PATH variable. When you are the command prompt, type:
You'll need the contents of these either inside your script or inside your crontab.

ALSO, you're outputting to a file in /home. That's normally INCORRECT. Your output file should be something like: