Error: cannot open ./xtrabackup_checkpoints

[Zak]

Hi having troubles with xtrabackup 

I am getting the following error.

Another post seemed to have solved the problem by putting the mysql binary path which I done to make sure its there

however still no luck!

any help appriciated

thanks 

Zak

./restore_innobackup

PATH=/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/bin/mysql ( enviroment path)

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy

and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved .

This software is published under

the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

Get the latest version of Percona XtraBackup, documentation, and help resources:

http://www.percona.com/xb/p

140526 21:41:14  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).

140526 21:41:14  innobackupex: Connected to MySQL server

Connected successfully

140526 21:41:14  innobackupex: Connection to database server closed

IMPORTANT: Please check that the apply-log run completes successfully.

           At the end of a successful apply-log run innobackupex

           prints "completed OK!".

140526 21:41:14  innobackupex: Starting ibbackup with command: xtrabackup_56  --defaults-file="/etc/my.cnf"  --defaults-group="mysqld" --prepare --target-dir=/root/percona_backsups --use-memory=1G --tmpdir=/tmp

xtrabackup_56 version 2.1.9 for MySQL server 5.6.17 Linux (x86_64) (revision id: 744)

xtrabackup: cd to /root/percona_backsups

xtrabackup: Error: cannot open ./xtrabackup_checkpoints

xtrabackup: error: xtrabackup_read_metadata()

xtrabackup: This target seems not to have correct metadata...

2014-05-26 21:41:14 7ff489e94720  InnoDB: Operating system error number 2 in a file operation.

InnoDB: The error means the system cannot find the path specified.

xtrabackup: Warning: cannot open ./xtrabackup_logfile. will try to find.

2014-05-26 21:41:14 7ff489e94720  InnoDB: Operating system error number 2 in a file operation.

InnoDB: The error means the system cannot find the path specified.

  xtrabackup: Fatal error: cannot find ./xtrabackup_logfile.

xtrabackup: Error: xtrabackup_init_temp_log() failed.

innobackupex: Error:

innobackupex: ibbackup failed at /usr/bin/innobackupex line 2560.

[root@mobeni percona_backsups]#

[Ernie Souhrada]

Hi Zak--

The error you're getting is a file not found on one of the metadata
files from Xtrabackup, so the first question that I'd ask is what's the
output of this:

ls /root/percona_backsups/

It may be the case that your actual backup is in a directory within
that directory, perhaps one marked with the timestamp when the backup
was taken, in which case you just need to change the target-dir
parameter to point to that directory, not the top-level one which
contains the backup folder.

e.

> --
> You received this message because you are subscribed to the Google
> Groups "Percona Discussion" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to percona-discuss...@googlegroups.com
> <mailto:percona-discuss...@googlegroups.com>.
> To post to this group, send email to percona-d...@googlegroups.com
> <mailto:percona-d...@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout.


--
Ernie Souhrada, CMDBA, RHCE, CCNA
Senior Architect, Percona. [ http://www.percona.com ]
email: ernest....@percona.com
phone: +1-888-401-3401 x543 [ US/San Francisco : GMT-7(DST) ]
skype: ravyn440

[Zak]

Hi Ernie

ls /root/percona_backsups/

is empty

Zak

[Ernie Souhrada]

Hi Zak--

OK, then the reason that your restore isn't working is because there is
no backup in that directory. Is the backup located somewhere else, or
have you not yet been able to take a backup in the first place?

e.

[Zak]

yes thanks

i forgot the first step!

zak

On Monday, May 26, 2014 9:50:22 PM UTC+2, Zak wrote: