TalkPHP - How to backup mysql with cron?

TalkPHP (http://www.talkphp.com/forums.php)

- MySQL & Databases (http://www.talkphp.com/mysql-databases/)

- - How to backup mysql with cron? (http://www.talkphp.com/mysql-databases/9488-how-backup-mysql-cron.html)

xy8797

02-20-2013 08:33 AM

How to backup mysql with cron?

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!

All times are GMT. The time now is 11:34 AM.