Can I set up a cron job use following command:

mysqldump --opt -uUsername -pPassword testdb > testsql.sql

or to execute a shell script, like this:

sh script.sh

Perhaps something like this would be more favorable:


#!/bin/sh

date=`/bin/date +%m-%d-%Y`

/usr/bin/mysqldump --opt -uUsername -pPassword testdb > /home/YourUsername/testsql-$date.sql


Put that in a file.sh and you can execute it with "sh file.sh" or via cron "/bin/sh /home/YourUsername/file.sh > /dev/null"

my host doesn't allow SSH... so I have to use this way to back up my SQL DBs...

i'll try this... thanks...

Originally posted by FrzzMan
my host doesn't allow SSH... so I have to use this way to back up my SQL DBs...

i'll try this... thanks...

/bin/sh isn't SSH.



Edit: If you don't want to recieve STDOUT via email you use > /dev/null .. if you want to recieve nothing, use &2>1 aswell (iirc)

I know it isn't SSH, thank for your info anyway...

It worked... thank you all...