Skip to Main Content
MySQL® Administrator's Bible
book

MySQL® Administrator's Bible

by Sheeri K. Cabral, Keith Murphy
May 2009
Intermediate to advanced content levelIntermediate to advanced
888 pages
20h 33m
English
Wiley
Content preview from MySQL® Administrator's Bible

Chapter 13. Backups and Recovery

The most important responsibility a database administrator has is performing backups and recoveries. In almost every case, data is an organization's primary asset and keeping that asset safe is of utmost importance. Backups and recovery are necessary in case of disaster, but are also critical in setting up replication, upgrading, migrating, and troubleshooting unexpected data changes.

This chapter has two goals. The first goal is to give an overview of the various methods of backups available to a database administrator. The second goal is to help you to understand that there is more to backups and recovery than just being able to perform the actual operations of backup and recovery. Backup and recovery are parts of the big picture of planning for disasters and recovering from them, as well as setting up new slave servers and test/development environments.

Backing Up MySQL

A number of terms are associated with backup and recovery. Before covering the various methods of performing backups, it's important to define some terminology first:

  • Logical Backup — A logical backup is created by saving information that represents the logical database structures using SQL statements like CREATE DATABASE, CREATE TABLE, and INSERT. It is not correct to say that a logical backup is a text representation of the database server because there can be non-text binary data in logical backup. Other ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

MySQL® Administrator's Guide

MySQL® Administrator's Guide

MySQL AB
Microsoft® SQL Server 2005 Management and Administration

Microsoft® SQL Server 2005 Management and Administration

MCDBA Ross Mistry, MCSE Chris Amaris, MCSE Alec Minty

Publisher Resources

ISBN: 9780470416914Purchase book