BlueOnyx MySQL Backup Script

Overview

bo-backupmysql is a shell script that automatically backups the local MySQL server on a BlueOnyx Server or VPS.

Quicklinx
BlueOnyx Homepage
BlueOnyx VPS Hosting
TeleMedia Publications
Download: RPM \| PKG
$Id: blueonyx-mysqlbackup.html,v 1.5 2010-04-24 16:40:06 obiwan Exp $

Features

Creates nightly compressed dumps of the local MySQL server
Automatically purges older dumps
Fully configurable through config file
Repairs and optimizes all databases
Email-report to Server-Admin account
Checks free space/avoids filling up filesystem
Installable as BlueOnyx PKG or Centos RPM
Licensed under a BSD license
Automatic updates and enhancements (if installed with the PKG version)

Requirements

This script is specifically geared towards BlueOnyx servers, it won't work on any other platform. If you're running a recent version of BlueOnyx the package/script should work on all configurations. Just make sure you have at least the same amount of free space available on /home that your MySQL databases currently uses.

License

BSD

Disclaimer

This software is provided ``as is'' and any express or implied warranties, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose are disclaimed. In no event shall SCS TeleMedia AG be liable for any direct, indirect, incidental, special, exemplary, or consequential damages (including, but not limited to, procurement of substitute goods or services; loss of use, data, or profits; or business interruption) however caused and on any theory of liability, whether in contract, strict liability, or tort (including negligence or otherwise) arising in any way out of the use of this software, even if advised of the possibility of such damage.

Installation

Installing the PKG (recommended)

Download the latest package from here and install it in the BlueOnyx Admin GUI:

Login as user admin
Navigate to Software Updates | Third Party Software
Click Install Manually and either upload the previously downloaded PKG file or paste the URL

Once installed bo-backupmysql will send a nightly report to the admin user on your server. To receive the nightly email reports, make sure you either read the mail of user admin directly (i.e. POP3-client or webmail) or you have setup a forwarding under Personal Profile | Email.

Please note:

The PKG installs also the telemedia-blueonyx-repository for yum on the system so that you will automatically receive updates to the script. If you do not wish the telemedia-blueonyx-repository to be installed, use the RPM version of the script below and download updates from this page.

Installing the RPM

Download the latest RPM package from here and install it via

rpm -i telemedia-bo_backupmysql-1-X.XX.i386.rpm

Configuration

There is a sample config file at /etc/bo-backupmysql.conf with all settings explained. The configuration file will only be used if present and only the values that are not commented out with a #, else a few sane defaults will be used.

The possible settings in the config file are:


# Set the dateformat used for the filename of the dump:
#DATE=`date +%Y%m%d%H%M`
#
# Set the hostname if you dont want the value retrieved from the system at runtime:
#HOSTNAME=`hostname -f`
#
# Set the destination directory for backups
#BDIR=/home/backup
#
# Set the destination filename for the backups/dumps:
#FNAME=${BDIR}/${HOSTNAME}_${DATE}.backup.sql
#
# Set the maximum age in days for older backups/dumps in $BDIR:
#MAXAGE=20
#
# Set the process priority (nice) of the bo-backupmysql script 
# [see man nice/renice/ps for more information] :
#BENICE=10

Feedback

We appreciate your feedback, please report any bugs, problems or wishes for enhancements through our feedbackform.

Changelog

1.16 [12.04.2010]	Initial public release
1.19 [17.04.2010]	Bugfixes (cronjob, pw-handling)
1.20 [24.04.2010]	Bugfixes (purgejob, pw-handling)