Daily user MySQL backups

**ellijay** · 06-23-2003 03:08 PM

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** · 06-28-2003 07:48 PM

Bump for help...

cPanel.net Support Ticket Number:

**ciphervendor** · 06-28-2003 08:07 PM

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.

**ellijay** · 06-29-2003 04:36 PM

Thank you SO much! Excellent.

cPanel.net Support Ticket Number:

**mweb** · 06-30-2003 12:00 AM

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

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

cPanel.net Support Ticket Number: