Summary
It has been a long road from the beginning of this book. We have gone from merely installing MySQL for Python to doing some pretty sophisticated things with it. We have moved beyond merely using the database to using Python to do programmatic administration.
In this chapter, we have seen several ways to back up and restore a MySQL database. We have looked at:
When it is advisable to backup a running system instead of shutting it down
The procedure for taking a snapshot of a running MySQL server
What backup methods are available to a python database developer
Which privileges are required when using certain archiving methods
From here, the sky is the limit for you. You have the Python and MySQL foundation necessary to design and develop even large, database-driven applications.
Naturally, there is more to learn about MySQL. That is for the coming chapters of the book.
