Backing Up Mysql Databases - Adding Scheduled Cron Job

[ShiftPoint]

I recently had to setup a cron job on a debian apache/mysql server to backup multiple mysql databases. Here is an example of the script I created.

The name of the script is

backup_dbs.sh

Code: Select all

#!/bin/bash

homedir=/tmp
#homedir=/root
#logger -i -s -d "started running script backup_dbname.sh"

#Backup Site1-blog
sudo rm -rf $homedir/Site1-blog_dump.*
/usr/bin/mysqldump -u root --password=enter_password Site1-blog > $homedir/Site1-blog_dump.sql
sudo zip $homedir/Site1-blog_dump.zip $homedir/Site1-blog_dump.sql
sudo mv -f ${homedir}/Site1-blog_dump.zip /home/UserFolder/mysql_backups/


#Backup Site1-forum
sudo rm -rf $homedir/Site1-forum_dump.*
/usr/bin/mysqldump -u root --password=enter_password Site1-forum > $homedir/Site1-forum_dump.sql
sudo zip $homedir/Site1-forum_dump.zip $homedir/Site1-forum_dump.sql
sudo mv -f ${homedir}/Site1-forum_dump.zip /home/UserFolder/mysql_backups/


#Backup Site1-news
sudo rm -rf $homedir/Site1-news_dump.*
/usr/bin/mysqldump -u root --password=enter_password Site1-news > $homedir/Site1-news_dump.sql
sudo zip $homedir/Site1-news_dump.zip $homedir/Site1-news_dump.sql
sudo mv -f ${homedir}/Site1-news_dump.zip /home/UserFolder/mysql_backups/


Then add something like this to the crontab via the command:

Code: Select all

sudo crontab -e

Then enter this:

Code: Select all

4 0 * * * /bin/bash -c "/root/backup_dbs.sh" >> /dev/null 2>&1

This will run every night at 12:04 am. Everyday of the week. Also here is a good site that explains cron format.

http://ss64.com/osx/crontab.html