Is there any way a user can script a daily backup of their MySQL databases into their home diretory?
cPanel.net Support Ticket Number:
Is there any way a user can script a daily backup of their MySQL databases into their home diretory?
cPanel.net Support Ticket Number:
Bump for help...
cPanel.net Support Ticket Number:
Create a mysql-backup.sh file within the users directory. Place the following inside:Add the following cron entry:Code:#!/bin/sh date=`/bin/date +%m-%d-%Y` /usr/bin/mysqldump -uUSERNAME -pPASSWORD database > /home/username/database-backup-$date.sqlThis will run backups at 1 AM every day.Code:0 1 * * * /bin/sh /home/username/mysql-backup.sh 2>&1 >/dev/null
Thank you SO much! Excellent.
cPanel.net Support Ticket Number:
... and chmod it appropriately world-not-readable (700/711).Originally posted by ciphervendor
/usr/bin/mysqldump -uUSERNAME -pPASSWORD database
cPanel.net Support Ticket Number: