faqts : Computers : Databases : MySQL : Common Problems : Backups

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

12 of 14 people (86%) answered Yes
Recently 6 of 8 people (75%) answered Yes

Entry

Do I need to backup MySQL's update logs?
When is it necessary to backup the MySQL update logs?

May 18th, 2000 06:24
Nathan Wallace, Thimble Smith


You might want to back up the update logs between major database
backups.  For example, you could flush the update log every 10 minutes
and copy the log file to backup.  (Think of this as an incremental
backup of the database.)  Then, when you back up all of your database
files, you can get rid of those update logs, and start saving the new
updates again.