O'Reilly logo

Effective MySQL Backup and Recovery by Ronald Bradford

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image
1
The Five Minute DBA
You have just inherited a production MySQL system and there is no confirmation that an existing MySQL backup strategy is in operation. What is the least you need to do? Before undertaking any backup strategy there are some necessary prerequisites about your database size and storage engine usage that have a direct effect on your system availability during any backup approach.
In this chapter we will discuss the approach necessary to identify a minimum functionality backup, including:
•  Determine your database size
•  Determine your storage engine usage
•  Locking and downtime implications
Approaching a MySQL Backup
There ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required