This week we continue our series on backup tools, we talk about the backup tools that ship with MySQL.
Previous backup series podcast:
Backup glossary [Backup series #1]
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.