We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [xtrabackup]

XtraBackup : Percona's Open Source Backup Utility

Filter by
Sorted by
Tagged with
2
votes
2answers
4k views

Restore InnoDB to different machine

I currently have backups that were taken with Percona XtraBackup of all my MySQL databases. My specific scenario is that I want to restore a month old InnoDB database snapshot to my local machine for ...
2
votes
1answer
3k views

InnoDB: “Only one log file found” after binary import

My first one on DBA... After successful upgrading a master MySQL server 5.5 to 5.6.17 (CentOS 6 VPS serer), I done and moved my binary backups to a slave server (same version 5.6.17 but different ...
-1
votes
1answer
1k views

mysql xtrabackup missing binary logs

It seems xtrabackup is not backing up binary logs, although it creates xtrabackup_binlog* with apparently correct information inside. Should the binary logs be copied manually beforehand or is this a ...
1
vote
1answer
4k views

Is it safe to use mysqldump to backup and restore a master-master cluster

Not sure if the specifics matter but just to get it out of the way I am talking about a Galera cluster on XtraDB (MariaDB). I have a master-master setup and am interested in backing up and restoring ...
1
vote
2answers
3k views

ib_logfile0 and ib_logfile1 got deleted

After restoring from a percona-xtrabackup without a preparation step, ib_logfile0 and ib_logfile1 were not present in the restore data. Therefor during startup the following message is observed: ...
2
votes
2answers
6k views

XtraBackup fails with my.cnf Percona Configuration

After using a percona optimized .cnf file the backup fails Installing my.cnf # service mysql stop (Installed my.cnf) # rm ib_logfile0 # rm ib_logfile1 # service mysql start Mysql creates new log ...
2
votes
1answer
6k views

Can I use a Percona Xtrabackup backup to restore a single table?

I've been playing around with the Xtrabackup tool for a month now, and I got to admit : it is really powerful ! I'm still testing it to backup database servers between 5 and 150 GB and the backup/...
2
votes
3answers
1k views

xtrabackup prepare - after dump or before restore?

i have doubts about xtrabackup --apply-log. is there any difference when use it? should it be done right after dump or before restore (even few months later)? seems stupid, but maybe i missing ...
3
votes
2answers
246 views

Percona Xtrabackup on Suse EL 10 — Failing

I have evaluated Percona Xtrabackup successfully and it works like a charm on my several CentOS / RHEL servers! Hats off to the team! But my problem starts when I tried to install this on one of my ...
1
vote
1answer
2k views

Percona xtrabackup Prepare Fails

I made a backup and according to Percona it completed successfully. Now I'm trying to prepare it and having the following issue: ./xtrabackup_55 --defaults-file="/etc/my.cnf" --defaults-group="...
2
votes
1answer
513 views

xtrabackup backup grants?

I'm using MySQL 5.5 + Opensuse 12.3 . After face an issue with mysqldump (appear be a bug with OpenSuse Mysql distribution) I have looking for others backup solution. I found the xtrabackup from ...
1
vote
3answers
2k views

Ubuntu / MySQL / Percona XtraBackup gives error “sh: 1: xtrabackup_55: not found”

Hello I installed Ubuntu 12.04.2 LTS on a fresh box. This installed MySQL 5.5.29. I installed percona-xtrabackup-2.0.6-521.tar.gz, and moved the executables to /usr/bin/ But innobackupex is ...
4
votes
1answer
428 views

Backing up a 400-500 GB database on MySQL/Amazon RDS?

We have an Amazon RDS small instance for a MySQL datawarehousing database. Database size will be around 400-500 GB very shortly. What is the best way to backup our database? Can it be done ...
5
votes
2answers
6k views

Which hot backup tools for MySQL InnoDB database : Percona XtraBackup, Zmanda Recovery Manager Enterprise or Community or…? [closed]

I manage a PHP/MySQL website : max 500 simultaneous users / average of 4000 per hour in update/read 1 MySQL Community Server (5.1) - (Xeon / 16 Go RAM) InnoDB Storage engine on 100 tables for 1.4 Go ...
2
votes
2answers
4k views

Best option to back up mysql innodb partition

We have a number of tables which we plan to partition based on months. The issue now before we can drop those partition we would like to perform backup. One option we found is this link http://www....
1
vote
1answer
819 views

Unable to take backup of mysql database using Xtrabackup

I am trying to take mysql backup without any downtime but unable to take the backup using Xtrabackup . Actual Database is almost about 40+ GB in size. I am trying to first satisfy myself. Hence, I ...
3
votes
1answer
343 views

innobackupex is failing while exporting backup

I am using perl script which is working fine in one of my other box which used to take individual schema backups & finally take all schema together using percona innobackupex. I have following ...
7
votes
1answer
6k views

Is Percona xtrabackup the right choice for my 500GB MySQL backup?

I have a MySQL db with 500GB, consisting mainly of Innodb tables, and one big (200GB) MyISAM table. My current backup strategy is copying the db files to an external harddrive. This causes a downtime ...
2
votes
1answer
2k views

Problem with Error: InnoDB: page … log sequence … number is in the future!

i know this question was asked before, but i am at a point where i am really stuck and do not know how to continue with this problem and i would really like to know, what causes this error to come up. ...
31
votes
3answers
41k views

What is the recommended way to backup a MySQL/Amazon RDS database to S3?

I have two purposes for this: To have an offsite backup in case of a region wide problem with Amazon Web Services. To copy production data from a production billing account to a beta billing account. ...
1
vote
1answer
1k views

xtrabackup “failed to read metadata” [closed]

Doing a staging run setting up a new xtrabackup restore script I'm running into a somewhat cryptic error I can't readily google a solution for. I'm working with an incremental backup design. During ...