CRON MySQL Database Backup Script

Automated MySQL DB Backup from CRON

The following code snippet used to setup the MySQL backup from CRON. This function can get the backup automatically and export it to the specified destination path. However you can customize the backup schedule and database based on your requirements

MySQL Scheduled Database Backup


#!/bin/bash

# modify the following to suit your environment
export DB_BACKUP="/backup/mysql_backup"
export DB_USER="root"
export DB_PASSWD="********"

# title and version
echo ""
echo "mySQL_backup"
echo "----------------------"
echo "* Rotating backups..."
rm -rf $DB_BACKUP/04
mv $DB_BACKUP/03 $DB_BACKUP/04
mv $DB_BACKUP/02 $DB_BACKUP/03
mv $DB_BACKUP/01 $DB_BACKUP/02
mkdir $DB_BACKUP/01

echo "* Creating new backup..."
mysqldump --user=$DB_USER --password=$DB_PASSWD --all-databases | bzip2 > $DB_BACKUP/01/mysql-`date +%Y-%m-%d`.bz2
echo "----------------------"
echo "Done"
exit 0


Related Topic How to Restore Dumped Mysql Database Backup on Ubuntu
How to Backup Mysql Database on Command line
How to Restore or Recovering Mysql Database on Command line
How to Create Simple Mysql Database Dump Backup on Ubuntu
The Client Server Approach for MySql Database Backup
SQL  mysql  database  

nScraps.com 2011   Privacy Policy  Terms of Service  Feedback