Follow

Auto mysql backup is a fantastic script to create daily , weekly and monthly backup of mysql db’s .  I am using this in my most of the DB servers . The main advantage is , it will do a good level of compression ( backup file )

Download the script :-

http://sourceforge.net/projects/automysqlbackup/

Configuration :-

cp  automysqlbackup-2.5.1-01.sh  /etc/automysqlbackup/automysqlbackup.sh

mkdir –p /etc/automysqlbackup/

vi   /etc/automysqlbackup/automysqlbackup.conf

To create a config file just copy the code between “### START CFG ###” and “### END CFG ###   to /etc/automysqlbackup/automysqlbackup.conf from automysqlbackup-2.5.1-01.sh

In the configuration you need to change only the following

# Username to access the MySQL server e.g. dbuser

USERNAME=root

# Password to access the MySQL server e.g. password

PASSWORD=password

# Host name (or IP address) of MySQL server e.g localhost

DBHOST=localhost

# List of DBNAMES for Daily/Weekly Backup e.g. “DB1 DB2 DB3”

DBNAMES=”wordpress_db  forum_db”

# Backup directory location e.g /backups

BACKUPDIR=”/backup/MysqlAuto”

# Email Address to send mail to? ([email protected])

MAILADDR=[email protected]

# setup a cron to execute the mysql backup script.

30 00 * * *  bash  /etc/automysqlbackup/automysqlbackup.sh

Enjoy !! you done that..It’s a fantastic tool for mysql daily weekly and monthly backup . ..You can sleep with out worrying about your DB’s