Backups: A Video Presentation By Keith Murphy From the June 2008 Boston MySQL User Group

The Boston MySQL User Group was lucky enough to get Keith Murphy to speak at the June User Group meeting, about backups.

Links referred to in the presentation:

MyLVMBackup by Lenz Grimmer

InnoDB Hot Backup:
Prices are at:
and at the time of this writing are:
1-Year License € 390 USD$ 605 per server
Perpetual License € 990 USD$ 1540 per server

prices are at:,3
Current prices are between the range of $100-$450, and a license is needed for each server and each client. So if you have 1 server and 3 clients, you need 4 licenses.

Online Backup
This is interesting reading about online backup, an article about how the online backup works at:

This page (at the bottom, under "Replication") states that the desired behavior is that the binary log does not log the restore or the backup. However, it does state that this is not implemented yet, nor even decided upon.

There's also a great page on Online Backup at the MySQL Forge:

And if you're short on time, the manual has a short page at

Folks mentioned:


It was mentioned that some people use a code repository to backup their database:

Trackback URL for this post: