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 ...

Get MySQL for Python now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.