…how to get your data back from simple Innodb Table Corruption. In more complex cases you may need to use higher innodb…recover deleted rows or dropped table. I should also mention at Percona we offer assistance in MySQL Recovery, including recovery from Innodb corruptions and deleted…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
…: we’ll delete some rows from a table in order to recover the table later. Most…to copy all the data to an output directory: The –export option…from the user is back again! Conclusion: As we learned , you can also recover single InnoDB table… In the next blog post I‘ll explain how to do recovery using…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 11 Comments
…how data was lost: MySQL had a dedicated partition on XFS file system Server was running innodb_file_per_table…deleted files. Now, here’s what I learned while working on this case: Recovering from…from a single record – customer knew that there was at least one row…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…Innodb tables do internal full table > lock if auto_increment is used so using values generated elseware > might be faster. I…deletes but there are other benefits. Also – if you’re replicating from…
