Welcome to WebmasterWorld Guest from 18.104.22.168
I've got this line of code which enables me to backup the database on a daily basis. However this does not work and I know why after all this time.
You need to login as root to run the command, now I think I need to create a bash script that enables you to login as root and then run the command.
Then I suppose you need to setup a cron job so that it executes the bash script at a given time. Yeah?
This is the line of code:
30 09 * * * /usr/bin/mysqldump --opt -uusername -ppassword dbname ¦ gzip > /home/sites/domain.com/web/mysqlbackup_`date +\%d\%m\%y`.sql.gz