Daily user MySQL backups

[ellijay]

Is there any way a user can script a daily backup of their MySQL databases into their home diretory?

cPanel.net Support Ticket Number:

 

[ellijay]

Bump for help...

cPanel.net Support Ticket Number:

 

[ciphervendor]

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

#!/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:

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

This will run backups at 1 AM every day.

 

[ellijay]

Thank you SO much! Excellent.


cPanel.net Support Ticket Number:

 

[mweb]

Originally posted by ciphervendor
/usr/bin/mysqldump -uUSERNAME -pPASSWORD database

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

cPanel.net Support Ticket Number: