… the same server. This will allow you to compare and restore values (potentially corrupted via user error or other issues) with….sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` DISCARD TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF mysql -N…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… directory during the backup stage. During the copy back stage (restore) it is copied back to data directory. After the backup… all InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… directory during the backup stage. During the copy back stage (restore) it is copied back to data directory. After the backup… all InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… need to restore only some tables from a full backup maybe because your data loss affect a small number of your tables. In… alter the schema of the table after the backup has been taken. The variable innodb_file_per_table must be enabled. Then, our… again! Conclusion: As we learned , you can also recover single InnoDB table as with MyISAM but knowing in advance that there are…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… we need to restore only single table from backup (sometimes developers kill only single table, not whole database 
) – to copy single table from production… as with MyISAM tables when you just copy table.frm, table.MYD, table.MYI files, but so nice here – just can copy InnoDB tables in fully…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…TABLE STATUS versus 265 MB index size with the optimization disabled. OPTIMIZE TABLE OPTIMIZE TABLE is mapped to ALTER TABLE … ENGINE=InnoDB for InnoDB tables…a separate ALTER TABLE after restoring the data from a dump would actually make the restore slower; mysqldump –innodb-optimize-keys ignores…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
… dedicated partition on XFS file system Server was running innodb_file_per_table There was a production master and two slaves, all… of the data The important tables were all InnoDB Having a backup, customer has first attempted to restore from backup on the production… and see what you get. If InnoDB Data Dictionary was not overwritten by an attempt to restore from the backup, actually second…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…, especially for complex systems. Instead of looking just at data restore process you better look at the whole process which is… careful such as using sync-binlog innodb_flush_logs_at_trx_commit=1 and only using Innodb tables to be OK in most cases. There are still some edge cases such as modifying meta data stored in MyISAM tables…
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
… be no way to make Innodb avoid touching it. Even when we dropped all Innodb tables (for test purposes) Innodb still was crashing if… reimporting couple of tables rather than full dump and restore. The bug which we found during attempt to dump tables with innodb_force_recovery… have some impact. Innodb tables rarely become corrupt Indeed even if you leave out crashes in my experience Innodb tables become corrupted more seldom…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
… while you need to restore only single 20GB table is very non-productive Open InnoDB tables in parallel. Currently opening table is serialized, and it is especially bad at start time, when InnoDB takes probes during opening table…
