How to backup mysql with cron?

xy8797 · 02-20-2013, 08:33 AM

How to backup mysql with cron?(I am a new.)

nancy30 · 02-21-2013, 07:56 AM

Create a shell script and save it somewhere like /root/mysqlbackup.sh, because it will contain your mysql password so needs to be kept safe.

Code:

#!/bin/sh

DAY=`/bin/date +%Y%m%d`
mysqldump DATABASE -u USERNAME -pPASSWORD > /path/mysql.yourdomain.$DAY.sql

and do

chown root:root /root/mysqlbackup.sh
chmod +x /root/mysqlbackup.sh

Then set this to be executable as a cron job. Job done!