…. I want to restore this database (called tools). But I am not able to do a SINGLE DATABASE restore using the copy-back… I am able to view/access ONLY MYISAM table – but none of the InnoDB tables. Is there something which I am missing? Do… any directive in the my.cnf file to access the InnoDB table? Please help. Thanks in advance. Abhilasj
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… copying, it was required to uncompress the entire backup to restore a single table). Percona XtraBackup now supports streaming incremental backups. In previous… for compiling and running Percona XtraBackup against debug versions of InnoDB. This is only for very advanced users. The new features…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
… need to restore only some tables from a full backup maybe because your data loss affect a small number of your tables. In… is faster to recover single tables than a full backup. This is easy with MyISAM but if your tables are InnoDB the process is… back 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
… – when we need to restore only single table from backup (sometimes developers kill only single table, not whole database 
) – to copy single table from production to …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 …
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… complex systems. Instead of looking just at data restore process you better look at the whole process…5 different Data Centers via single Replication Relay server in each. Forget the single point of failure …as using sync-binlog innodb_flush_logs_at_trx_commit=1 and only using Innodb tables to be OK…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 11 Comments
… 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… table, a small one with 4 smallint columns where all we could match on was a sequence of numbers from a single…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
… requires restart of slave Copy single .ibd table from one server to different or (basically the same) restore single table from backup, possibly on different… backup 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…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
… to recover, on some specific cases, a single table from a full backup in order to …don’t have a backup or the backup restore process doesn’t work. How can I …tables and indexes (with their IDs) to the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…Innodb tables…InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… InnoDB…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… table in its own set of files. The show stopper was restore of tables. If we needed to do a restore of any table in InnoDB, we would need to restore the full InnoDB database from… in a DR situation when you have to quickly restore a single database or table. I would be interested in other comments in…
