… mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the …SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` IMPORT TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF For …
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… by ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide. Bugs Fixed: xtrabackup_56 binary… all InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES WITH…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… and Importing Tables guide. Bugs Fixed: Percona XtraBackup would crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables …all InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed from Percona XtraBackup. After being deprecated in previous…XtraBackup would assume the table has been dropped if the tablespace was renamed after it was scanned by XtraBackup on startup and before XtraBackup …
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…in case DROP TABLE statement is used on a temporary table. Bug fixed #1084702 …fixed #1160047 and #1086978 (Raghavendra D Prabhu). Donor node would run XtraBackup indefinitely when xtrabackup …Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…/08/impossible-possible-moving-innodb-tables-between-servers/ is now available in our latest releases of XtraBackup 0.8.1 and XtraDB-6. Now…. To export table you need XtraBackup, and you can just specify table or table by mask: xtrabackup –defaults-file=/etc/my.reg.cnf –backup –tables=tpcc.order…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… need innodb_file_table mode, which ones love, and ones hate) 1) do backup of specific tables on sources server with xtrabackup (server can run InnoDB… information from system tablespace that related to exported table. Both xtrabackup –export mode and XtraDB innodb_expand_import available only in source code for…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… is that the table definition is stored in the InnoDB shared tablespace (ibdata) and the transaction IDs and log sequence numbers that …table was “exported” with Xtrabackup as this exports essential information from main tablespace which is not stored in .ibd file. innodb_import_table_from_xtrabackup…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In …’re just using Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway) you can…
Post: Percona XtraBackup 1.6.3
September 23, 2011 By 5 Comments
… Xtrabackup. If the innodb_file_per_table server option is being used and DDL operations, TRUNCATE TABLE, DROP/CREATE the_same_table or ALTER statements on InnoDB tables are executed while taking a backup, an upgrade to XtraBackup…
