Backup & recovery of multiple MySQL databases (InnoDB & MyISAM)
Posted
by Cymon
on Stack Overflow
See other posts from Stack Overflow
or by Cymon
Published on 2010-04-02T16:46:05Z
Indexed on
2010/04/02
16:53 UTC
Read the original article
Hit count: 423
I am working on nightly and hourly backups of MySQL Databases. There are multiple MySQL databases which are either InnoDB or MyISAM (Note: Each database is either InnoDB or MyISAM for a reason). With the 2 different types I want to make sure I am grabbing everything that is needed for backup and recovery. Here is my current plan
Nightly -mysqldump of each DB which is stored locally and remotely.
Hourly -flush binary logs and store them locally and remotely.
Weekly -expire binary logs older than a week.
I feel like I am grabbing everything that is needed for the MyISAM databases but I am concerned about the InnoDB databases and the log files (ib_logfile0, ib_logfile1, ibdata1) they create. Should I backup these files? Nightly? Hourly? Both? Do I really need them if I am already doing the above nightly and hourly backups?
© Stack Overflow or respective owner