… old data to their current data on … have a consistent binary backup at a…table, run: ALTER TABLE tblname DISCARD TABLESPACE Copy the .exp and .ibd files from…TABLE `’, table_name, ‘` DISCARD TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide. Bugs Fixed: xtrabackup_56 binary…thread data in the log copying thread which could cause XtraBackup to crash. Bug fixed #1166888. Package dependency has been changed from abstract mysql…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… available from our …MySQL 5.6 buffer pool dump is copied into backup directory during the backup stage. During the copy back stage (restore) it is copied…tables. Bug fixed #1169169. Tables…data_file_path option which could cause backup to fail. Bug fixed #1169726. For the Debian and the Linux binaries…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…MySQL. Change Data Capture can be used to: Monitor a database table, or tables for changes. Improve ETL performance by identifying the data… binary log stores it progress in a metadata table: $ mysql -e ‘select * from…table FlexCDC copies the contents of database rows which change into special tables…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…MySQL 5.5.3 Prior to MySQL 5.5.3 a statement that opened a table only held meta data…table metadata, a table ALTER that alters a big table can keep executing without any hindrance, copying rows from the table…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…from the table “salaries”. After the “accidental” deletion of rows you should stop MySQL, take a copy… B) InnoDB Table Monitor The index information can also be taken directly from MySQL…binary backup. Just use constraint_parser without the -D option (deleted) and you will recover all the data…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… binary log position you’ll need to point your MySQL Slaves created from this snapshot. 4) Snapshot created, now you want to let MySQL… by running UNLOCK TABLES or simply closing connection. 5) Mount backup Filesystem: mount /dev/Main/dbbackup /mnt/backup 6) Copy data to backup…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…mysql-data for my datadir, and mysql-logs for my binary logs. I also have the latest snapshot of the mysql-data logical volume taken named ‘mysql-data…TABLE `salaries` /* generated by server */ … Now, let’s restore our data from…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…these major components: Percona XtraBackup for MySQL for binary backups mydumper for logical backups mysqlbinlog …-transactional tables (i.e. myisam), use –rsync option. This will rsync a copy of …. Restoring your data from backup is another topic. Piecing together data after accidental data loss is …
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… as on ability to restore data from backup which can be far from being enough to restore …MySQL. Yet another way is using DRBD to get a standby MySQL server or at least synchronously replicated master binary… many trashed copies to deal with. If you have just one or several small tables corrupted …
