Skip navigation links

The world's most popular open source database

Login | Register

Developer Zone
Downloads
Documentation

MySQL Server
MySQL Enterprise
MySQL Workbench
MySQL Cluster
MySQL Connectors
Topic Guides
Expert Guides
Other Docs
Archives
About

Documentation Library
- Table of Contents

Search manual:

MySQL Backup and Recovery

Preface and Legal Notices »

Section Navigation [Toggle]

MySQL Backup and Recovery

MySQL Backup and Recovery

Abstract

This is the MySQL Backup and Recovery extract from the MySQL 5.5 Reference Manual.

Document generated on: 2013-06-18 (revision: 35444)

Table of Contents [+/-]

Preface and Legal Notices

1. Backup and Recovery [+/-]

1.1. Backup and Recovery Types

1.2. Database Backup Methods

1.3. Example Backup and Recovery Strategy [+/-]

1.3.1. Establishing a Backup Policy
1.3.2. Using Backups for Recovery
1.3.3. Backup Strategy Summary

1.4. Using mysqldump for Backups [+/-]

1.4.1. Dumping Data in SQL Format with mysqldump
1.4.2. Reloading SQL-Format Backups
1.4.3. Dumping Data in Delimited-Text Format with mysqldump
1.4.4. Reloading Delimited-Text Format Backups
1.4.5. mysqldump Tips

1.5. Point-in-Time (Incremental) Recovery Using the Binary Log [+/-]

1.5.1. Point-in-Time Recovery Using Event Times
1.5.2. Point-in-Time Recovery Using Event Positions

1.6. MyISAM Table Maintenance and Crash Recovery [+/-]

1.6.1. Using myisamchk for Crash Recovery
1.6.2. How to Check MyISAM Tables for Errors
1.6.3. How to Repair MyISAM Tables
1.6.4. MyISAM Table Optimization
1.6.5. Setting Up a MyISAM Table Maintenance Schedule

2. Using Replication for Backups [+/-]

2.1. Backing Up a Slave Using mysqldump
2.2. Backing Up Raw Data from a Slave
2.3. Backing Up a Master or Slave by Making It Read Only

3. Backing Up and Recovering an InnoDB Database [+/-]

3.1. The InnoDB Recovery Process
3.2. Forcing InnoDB Recovery
3.3. InnoDB Checkpoints

A. Licenses for Third-Party Components [+/-]

A.1. Ant-Contrib License
A.2. ANTLR 3 License
A.3. ANTLR 3.3 License
A.4. Boost Library License
A.5. Bouncy Castle 1.7 License
A.6. c3p0 JDBC Library License
A.7. dtoa.c License
A.8. Editline Library (libedit) License
A.9. FindGTest.cmake License
A.10. Fred Fish's Dbug Library License
A.11. getarg License
A.12. GLib License (for MySQL Proxy)
A.13. GNU General Public License Version 2.0, June 1991
A.14. GNU Lesser General Public License Version 2.1, February 1999
A.15. GNU Libtool License
A.16. GNU Readline License
A.17. Google Controlling Master Thread I/O Rate Patch License
A.18. Google Perftools (TCMalloc utility) License
A.19. Google SMP Patch License
A.20. jboss-common-jdbc-wrapper.jar License
A.21. lib_sql.cc License
A.22. Libaio License
A.23. libevent License
A.24. Libiconv License
A.25. libintl License
A.26. Linux-PAM License
A.27. LPeg Library License
A.28. Lua (liblua) License
A.29. LuaFileSystem Library License
A.30. md5 (Message-Digest Algorithm 5) License
A.31. memcached License
A.32. nt_servc (Windows NT Service class library) License
A.33. OpenPAM License
A.34. OpenSSL v1.0 License
A.35. Paramiko License
A.36. PCRE License
A.37. Percona Multiple I/O Threads Patch License
A.38. Python License
A.39. Red HAT RPM Spec File License
A.40. RegEX-Spencer Library License
A.41. RFC 3174 - US Secure Hash Algorithm 1 (SHA1) License
A.42. Richard A. O'Keefe String Library License
A.43. SHA-1 in C License
A.44. Simple Logging Facade for Java (SLF4J) License
A.45. zlib License
A.46. ZLIB.NET License

Copyright © 1997, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices

Top / Next / Table of Contents

Developer Zone
Documentation
Developer Articles
News & Events
Forums
Lists
Bugs
Worklog
Planet MySQL
Labs

Downloads
MySQL Community Server
MySQL Proxy
MySQL Cluster
MySQL Workbench
MySQL Connectors
Archives

Documentation
MySQL Reference Manuals
MySQL Workbench
Expert Guides
Topic Guides
MySQL Cluster
Other Documents
About
Archives

About MySQL
Contact Us
How to Buy
Partners
Job Opportunities
Site Map

Legal
Legal Policies
Your Privacy Rights
Terms of Use
Trademark Policy
Contributor Agreement

© 2013, Oracle Corporation and/or its affiliates