How can I schedule a daily backup of my database to be emailed to me?
- Log onto your control panel and select the domain you wish to backup databases for.
- Click on "Scheduled Tasks" Icon > System User
- Click "Schedule a Task" Icon
- To run a task at 1.01am every day enter the following information.
Enabled: Check this box
Minute: 1
Hour: 1
Day of the Month: *
Day of the Week: *
Command:/usr/bin/mysqldump --opt -hMySQL-V4-001.web24.net.au -uUSERNAME -pPASSWORD DATABASENAME |gzip |uuencode db_backup.sql.gz |mail -s "Database backup" youremail@domain.com.au
Substitute the appropriate values for USERNAME PASSWORD DATABASE NAME and youremail@domain.co.au **EXACTLY** as shown above.
