…=’innodb‘ into outfile ‘/tmp/dump.sh’; Query OK, 328 rows affected (46.88 sec) In other case I needed to restore Innodb tables from mysqldump because of corrupted Innodb tablespace – to do this I had to clean all .frm files which correspond to innodb tables…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… in Innodb dictionary but .frm not created or not completely written. Partially written .frm files or .frm being unsync with internal Innodb dictionary …you may experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should write about …
Post: Add an option to Fail on Innodb Initialize failure, Please ?
October 11, 2007 By 9 Comments
… accessing Innodb tables is also very obfuscated: error : Incorrect information in file: ‘./prod/user.frm‘ How this supposed to tell you Innodb (or… this error message and think it is indeed .frm corruption – trying to restore .frm from backup or other servers and being extremely frustrated as…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…I hear from customers who migrated from MyISAM to InnoDB – can I just copy .ibd files from …restore only single table from backup (sometimes developers kill only single table, not whole database 
) – to copy single table from….frm, table.MYD, table.MYI files, but so nice here – just can copy InnoDB …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… innodb only this can greatly cut down on the lock time by syncing the frm files. Enable –slave-info when backing up from… dropped. Basically when restoring may take less time that trying to load a logical backup. Restoring your data from backup is another topic… a limiting factor on restore time when done inline. When do we typically use mydumper restores: Restoring a single file Restoring a single schema…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
…). These release notes are (as always) available from the online Percona XtraBackup documentation. This release … the normal method of copying the FRM files and non-InnoDB tables. By doing a two-…data loss or a strang combination of a restored backup and previous data. Bug Fixed: #737569 (Valentine…
