Percona is glad to announce the release of Percona XtraBackup 1.9.2 on 28th March 2012. Downloads are available from … late BETA release in the process of going towards Percona XtraBackup 2.0.0. This is a BETA quality release and… release, you should use the current Stable version – currently 1.6.5 in the 1.6 series at the time of writing. The…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… beta release towards Percona XtraBackup 2.0! We call this version 1.9.1 as we are using the 1.9.x version numbers… production use, check out our latest stable release (which was 1.6.5 at the time of writing). This beta adds some… at once. tar4ibd functionality is replaced by functionality in the xtrabackup binary itself. The xbstream utility is added This utility has…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… recover a single table # xtrabackup_55 –backup –innodb-file-per-table –target-dir=/mnt/mysql/export/ –tables=data # xtrabackup_55 –prepare –export… with the export files SET GLOBAL innodb_import_table_from_xtrabackup = 1; ALTER TABLE data IMPORT TABLESPACE; After those being done i… log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information.
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… | Query | 0 | NULL | show processlist | 0 | 0 | 1 | +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ 5 rows in set (0….–no-lock option with Percona Xtrabackup. Many other tools have …
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… created a backup of my mysql database using the innobackupex-1.5.1 command. I have the innodb_file_per_table directive set… configuration file. I have the backup folder which contains xtrabackup log files, xtrabackup checkpoint file and a folder for my database (called…
Comment: Copying InnoDB tables between servers
March 8, 2012 By 10 Comments
…://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.10-20.1.html#5.5.10-20.1 “Old system variable innodb_expand_import_page was renamed to innodb_import_table_from_xtrabackup…
Post: Percona XtraBackup 1.5-Beta
December 13, 2010 By 6 Comments
… XtraBackup 1.5-Beta is now available for download. This release adds additional functionality to Percona XtraBackup 1.4, the current general availability version of XtraBackup. This is a beta release. Functionality Added or Changed Support for MySQL 5.5…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
Percona XtraBackup 1.6 is now available for download and is the current stable release version of XtraBackup. Options Added Added option –extra… script innobackupex-1.5.1 was renamed to innobackupex. Symbolic link innobackupex-1.5.1 was created for backupward compatibility. (Vadim Tkachenko) Bug #703070 – xtrabackup_55 crashed…
Post: Percona XtraBackup 1.6.3
September 23, 2011 By 5 Comments
… upgrade to XtraBackup 1.6.3 is strongly recommended. Under this scenario, if the server version is prior to 5.5.11 in 5.5 series… to a regression introduced in XtraBackup 1.6.2, innobackupex –copy-back did not work if the xtrabackup binary was not specified explicitly… XtraBackup 1.6.3 isstrongly recommended. Under this scenario, if the server version is prior to 5.5.11 in 5.5 series or prior to 5.1…
Post: xtrabackup-1.0
December 9, 2009 By 16 Comments
… bugs: Bug #463691 in Percona-XtraBackup: “innobackupex-1.5.1 –help goes to STDERR” Bug #463709 in Percona-XtraBackup: “innobackupex-1.5.1 –help still references innobackup as… in Percona-XtraBackup: “innobackupex-1.5.1 gets wrong temp dir” Bug #479665 in Percona-XtraBackup: “Compilation fails on windows” Bug #485011 in Percona-XtraBackup: “xtrabackup –print…
