Daily user MySQL backups

Create a mysql-backup.sh file within the users directory. Place the following inside:

Code:

#!/bin/sh

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

/usr/bin/mysqldump -uUSERNAME -pPASSWORD database > /home/username/database-backup-$date.sql

Add the following cron entry:

Code:

0 1 * * * /bin/sh /home/username/mysql-backup.sh 2>&1 >/dev/null

This will run backups at 1 AM every day.

 

... and chmod it appropriately world-not-readable (700/711).

cPanel.net Support Ticket Number: