June 18, 2013

Comment: Btw xtrabackup is not only backup..

…) to suspend innobackupex-1.5.1: Suspend file ‘/var/lib/mysql/xtrabackup_suspended’ xtrabackup: suspend-at-end is enabled. xtrabackup: uses…: File name ./ibdata1 InnoDB: File operation call: ‘open’. InnoDB: Error in opening ./ibdata1 100213 9:52:19 InnoDB: Operating system error number 13 in a file…

Post: Connecting orphaned .ibd files

… 3 *************************** 2. row *************************** TABLE_ID: 13 ID: 16 NAME: idx…_PAGE_OFFSET 4 ordinal page number from start of space… in ibdata1. # ./ibdconnect -o /var/lib/mysql/ibdata1 -f /var/lib/mysql/sakila…ibdata1: $ ./ibdconnect -o ibdata1 -f t2.ibd -d sakila -t actor … Error

Comment: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas

mysql/datafiles/ \ –target-dir=/data/mysql-ibbackups/datafiles/ 100113 20:19:00 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: File name –target-dir=/data/mysql-ibbackups/datafiles/ibdata1

Post: Copying InnoDB tables between servers

ibdata1 to /data/vadim/mysql/export//ibdata1 >> log scanned up to (3 769009554) …done Copying ./mysqlnumber 3 768598528 (6 %) …. InnoDB: Doing recovery: scanned up to log sequence number…0 1560320 …. id 0 1559932, 13 rows to undo InnoDB:… progress of import in error.log InnoDB: import: extended …