We are using MySQL version 5.0 and most of the tables are InnoDB. We run replication to a slave server. We are thinking of backing up the MySQL log files on a daily basis.

Questions

  • Is there any other way of doing an incremental backup without using the log files?
  • What are the best practices when doing incremental backups?
Edit
Report