MySQL Users Conference 2006 “MySQL is at the heart of revolutionary changes in computer history.“—Tim O'Reilly
 Co-presented by O'Reilly Media, Inc. and MySQL AB
 Conference Coverage


What Do You Mean There's No Backup?

Mike Kruckenberg, Principal Software Engineer, OpenAir
Jay Pipes, Community Relations Manager, North America, MySQL AB

Track: DBA
Date: Wednesday, April 26
Time: 11:00am - 11:45am
Location: Ballroom F

There's a great sense of reassurance in knowing that your MySQL instance is regularly backed up and ready to be restored. It's a job that tends to get pushed off to last, but until it's done there's no escaping that nagging thought that you are vulnerable.

This session on planning and executing a backup and restore of MySQL data starts with a review of the often-overlooked pre-implementation steps important to consider. After looking at the planning process we'll delve into the variety of ways the plan can be accomplished with existing tools or by building one yourself.

What, I have to plan this? Yes, the first step in backing up data is asking users of the data what they require from a backup and restore. There are a slew of questions one might ask, which include:

  • Why are you backing up the data?
  • What needs to be backed up?
  • How frequently does the backup need to occur?
  • How long should the backup be preserved?
  • Where should the backup be stored?
  • What are the restore expectations?
  • Who can request restoration of what parts of the data?

With requirements in hand, you're ready to look at existing tools. This presentation will review the following tools:

  • filesystem backups
  • mysqldump
  • mysqlhotcopy
  • InnoDB Hot Backup (ibbackup)
  • innobackup
  • cluster
  • MySQL Administrator

This session will look at each of these tools, where they can be used, how they meet a variety of backup and restore requirements, and how to execute a backup and restore using them. The session concludes with a look at building a custom backup tool.

Diamond Sponsor

Business Objects
Hewlett Packard

Platinum Sponsors

Four J's Development Tools, Inc
GoldenGate Software, Inc.

Gold Sponsors

Actuate Corporation
Data Direct Technologies
Dell Inc.
Dolphin Interconnect Solutions
Embarcadero Technologies
EMC Centera
Lumen Software
Novell, Inc.
Rackspace Managed Hosting
Red Hat
Sun Microsystems
The SCO Group
Zmanda, Inc.

Media Sponsors

Conference Guru
Database Trends and Applications
DevtownStation News
IPTV Industry
Linux Journal
Methods and Tools newsletter
Sys Admin magazine
The ServerSide
The Women's Technology Cluster
Web Host Industry Review
WiMAX Industry

In-Kind Sponsors

Griffin Technology

Sponsor Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact us at

Download the MySQL Users Conference Sponsor/Exhibitor Prospectus

Conference News

To stay abreast of conference news and to receive email notification when registration opens, please sign up here.

Press and Media

For media-related inquiries, contact Suzanne Axtell at

Copyright MySQL AB and O'Reilly Media, Inc.
MySQL O'Reilly