Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Attempt to automate as much as possible the backup of dreamhost users and mysql databases in an account.
Python
branch: master
Failed to load latest commit information.
LICENSE Changed license to GPLv3.
README.md Add configuration file support. closes #4
dhbackup.cfg.sample
dhbackup.py Fix bug where a missing configuration file would throw an error on mi…

README.md

Dreamhost Auto Backup

Good backup systems need to be automatic. I needed a simple script to backup all mysql databases and user files on my Dreamhost account. This is my attempt to automate this process as much as possible.

You can read more from Dreamhost's Personal Backups at http://wiki.dreamhost.com/Personal_Backup.

Note: this script is yet under the early stages of development. All planned features are recorded in the issues section. See how you can contribute below.

Requirements

  1. Create an API key with the following functions: user-list_users, mysql-list_users;
  2. Activate your dreamhost backups user account;
  3. Set up passwordless login between your main account and the backups server;

I also recommend creating a separate mysql user with only SELECT permissions and add it to any database that you wish to backup.

Installation

The quick summary is as follows:

  1. Download the script and put it anywhere you want.
  2. Configure using command line options or a configuration file.
  3. Schedule the backup with a cron job.

Download

You can download the zipball/tarball from github, or the script file directly from the tree, but the prefered way is to do a git clone. This way it's easy to stay up to date.

Example

mkdir -p ~/scripts
cd ~/scripts
git clone https://github.com/helderco/dh-auto-backup.git

Update

cd ~/scripts/dh-auto-backup
git pull

Run from anywhere (optional)

If you already have a $PATH accessible folder in your home, skip the first two commands.

mkdir -p ~/bin
echo 'export PATH="$PATH:~/bin"' >> ~/.bash_profile

ln -s ~/scripts/dh-auto-backup/dhbackup.py ~/bin/dhbackup

Configure

The script is configurable through command line options, configuration files, or both. If both are provided, command line options override configuration file options.

Command line

The command line interface provides a basic configuration mechanism to avoid having to store passwords and other sensitive information in configuration files.

The simplest setup is to create a mysql user for backups only and assign it to any database you want to backup. Then provide the authentication to the script:

dhbackup -u user_backups -p s3cr3tp4 -k 6SHU5P2HLDAYECUM

Run win dhbackup -h for available options.

Configuration file

A configuration file has more options. Read the dhbackup.cfg.sample file for instructions.

Make it run automatically

The whole idea is to make the script run daily or at another set period. Create a cronjon, and optionally receive a report by email each time it's run.

Contribute

I'm interested in community improvements, so be free to contribute. You can also submit feature requests and report any issues or bugs with the script in the issues section.

Guidelines

I'm taking a few guidelines in consideration for writing this script.

  • Make it compatible with Python 2.5, since at this time it's what you have by default.
  • Avoid as much as possible external dependencies. This way the user doesn't need to install anything else.
  • Make it a single script:
    • freedom to move the file around without having to have a group of files under the same subdirectory;
    • configuration file should be able to be found on a few standard places (i.e., user's home dir, script's dir).
Something went wrong with that request. Please try again.