Database Reference
In-Depth Information
Summary
By now you probably understand that making backups is important. It can save you from
plenty of problems and frustrations. Being skilled in restoring backups can make life as a
database administrator easier, and help you to turn major problems into minor ones that can
be resolved easily. Developing and adhering to a good backup policy ensures that all of
your efforts and skills are brought together in an effective manner.
As mentioned near the start of this chapter, there are quite a few utilities that you can use to
make backups of your data, as well as other methods (e.g., replication). Using
mysqldump
is the easiest and in some ways the best. As an administrator, you should know how to use
it well and how to restore dump files. To that end, complete the exercises in the next sec-
tion to get some practice.
