Exercises
SQL dump files are often very large; why is this generally not a cause for worry?
Set up a weekly backup of all databases on your server.
For a production server, what time would you choose for your regular backups?
How can you recover modifications that have been made to your data since the last dump?
For an application where any loss of data is unacceptable, how would you choose the location of your binary logfile?
Get Learning MySQL 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.
