Recovery
Individual recovery scenarios vary widely, ranging from disk hardware failures to corrupted data files to accidentally dropped tables, and many points in between. In this section, we provide an overview of recovery procedures.
In general, you need two things to perform a database recovery: your backup files and your binary logs. Performing a recovery consists of:
Restoring the database from the last backup
Applying the binary logs to bring the system completely up to date
If you do not have binary logging enabled, the best you can do is restore the system to the last full backup.
Get Managing & Using MySQL, 2nd Edition 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.
