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
Recent Comments