…-file-per-table –target-dir=/mnt/mysql/export ALTER TABLE data DISCARD TABLESPACE; # replace ibd with the export files SET GLOBAL innodb_import_table_from_xtrabackup = 1; ALTER TABLE data IMPORT TABLESPACE; After those being…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
… with innodb_file_per_table so the data itself was available. What they could provide us was: all the tables ibd files (Nearly… Innodb Discard the tablespace Replace the table ibd file with the one provided by the customer Import the tablespace At this point I… to find the space id in a .ibd file. #root@domU:/mnt/tables# hexdump profile_data.ibd -C | head -4 #00000000 62 bd…
Post: Percona Server 5.1.56-12.7
April 18, 2011 By Leave a Comment
… Import feature, importing .ibd files smaller than 1 MB could lead to a server crash. (Yasufumi Kinoshita) Bug #727704 – When using the Expand Table Import feature, importing .ibd files…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
… userstat. (Oleg Tsarev) Old system variable innodb_expand_import was renamed to innodb_import_table_from_xtrabackup. (Yasufumi Kinoshita) Old system variable…. (Oleg Tsarev) Bug #727704 – When using the Expand Table Import feature, importing .ibd files created on MySQL 5.0 or Percona Server versions prior…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
… ibdata1 and order_line.ibd files Second step is to prepare backup, but with special option “export” xtrabackup –defaults-file=/etc/my.reg… created .ibd file, it’s done by command: alter table order_line discard tablespace; And now you copy both order_line.ibd and… can see progress of import in error.log InnoDB: import: extended import of testexport/order_line is started. InnoDB: import: 2 indexes are detected…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
… meet certain prerequisites to be able to restore a ibd tablespace: The ibd file must be from a consistent backup with all insert… salaries.ibd files from the backup to the database data directory: # cp /tmp/2012-01-22_14-13-20/employees/salaries.ibd /var… which is not stored in .ibd file. innodb_import_table_from_xtrabackup=1 should be enabled for such advanced import process to work. You…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
… of the salaries.ibd and start it again. Later, we’ll extract those deleted rows from the ibd file and import them into the… | +————+ ~/recovery-tool# ./page_parser -5 -f data/salaries.ibd Opening file: data/salaries.ibd: [...] 71.43% done. 2012-02-14 13:10:08… recover them from the original tablespace and also from an ibd file if you have a binary backup. Just use constraint_parser…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…_expand_import extension and with innodb_expand_import=1 setting) 4) run alter table IMPORTEDTABLE discard tablespace; 5) copy .exp and .ibd files to destination server 6) run alter table IMPORTEDTABLE import tablespace; 7) enjoy progress in error.log like: InnoDB: import: extended import of…
Comment: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
… Aleksandr, I ‘ve just tried your promising tool and imported an .ibd file from 5.1.31 to 5.1.51 under debian…:30 debian mysqld: InnoDB: tablespace but not the InnoDB log files. See May 16 14:19:30 debian mysqld: InnoDB: http… you mean by “0. Create empty InnoDB tablespace.” ? Must I import .ibd into an empty database ? In this case ibdconnect does not…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
…). Import/Export Tables – XtraDB allows you to import an arbitrary  table from one server to another, by backing up the .ibd file with… checkpoints are eventually forced at the end of a log file.  XtraDB improves this with innodb_io_capacity, as well… – this restricts users to using very small transaction log files (innodb_log_file_size), which is worse for performance.  In a…
