Chapter 5 Review

In this chapter, we have learned:

How to do database backups
The LOCK TABLES syntax
How to use the FLUSH statement
How to make a backup of individual files
How to backup data stored in an InnoDB storage engine
What is a good backup strategy
How to do a point-in-time recovery
Hot to specify recovery time and specify recovery position
How to do table maintenance
How myisamchk works
How to repair tables and optimize tables
How to set up a table maintenance schedule

Let us go to chapter 6.

© 2007 John Michael Pierobon

Notes