This week we talk with Chander Kant, CEO of Zmanda, about how Zmanda Recovery Manager makes backup and recovery of MySQL backups very easy, whether you are using storage level snapshots, hot backup tools or even logical backups. Full and incremental backups (and restores!) are made simpler with the community (free) version and with the enterprise (commercial) version.
This week we have Lenz Grimmer with us to speak about snapshot backups in general, MySQL backups with snapshots, and mylvmbackup, a script Lenz wrote and maintains to easily take consistent MySQL snapshot backups.
Rate/review us in iTunes (website with a link to open in iTunes, or link to iTunes [may not work in Chrome, does work in Firefox]).
In the backup glossary we asked if anyone knew how to get logical data out of physical InnoDB files. Mike Hamrick of Blue Gecko wrote in to say that Percona's InnoDB recovery tool helps to do just that. He writes:
"The 'page_parser' tool will read ibdata files or individual .ibd files and turn them into a series of 16k page files suitable for processing with a tool called 'constraints_parser' which spits out a number of tab separated lines of table data suitable for a LOAD DATA INFILE.