Not the answer you need?
Register and ask your own question!

innobackupex fails innobackupex: Error: Failed to copy file 'func.frm'

mboppudi@boardvantage.com[email protected] EntrantInactive User Role Beginner
Hi ,

I am getting this error. backup directory permissions is wide open and running as a root user. Getting this error. is any one have over come this situation.

121009 15:15:24 innobackupex: All tables locked and flushed to disk

121009 15:15:24 innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,
innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in
innobackupex: subdirectories of '/data/dvantagedb/ec'
innobackupex: Backing up files '/data/dvantagedb/ec/mysql/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,AR Z,CSM,CSV,opt,par}' (72 files)
cp: failed to preserve ownership for `/backup/dev_dumps/2012-10-09_15-07-50/mysql/func.frm': Invalid argument
innobackupex: Error: Failed to copy file 'func.frm': No such file or directory at /usr/bin/innobackupex line 374

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi,

    Can you share some more information like OS/Innobackex versions, ls -al output of backup dir? Are you using encryption for your backup folder?

    Regards,
    Nil
  • mboppudi@boardvantage.com[email protected] Entrant Inactive User Role Beginner
    ]# innobackupex -version
    InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
    and Percona Inc 2009-2012. All Rights Reserved.

    This software is published under
    the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

    [[email protected] bin]# cat /etc/redhat-release
    CentOS release 6.3 (Final)
    [[email protected] bin]# cd /backup/2012-10-11_11-33-16/
    [[email protected] 2012-10-11_11-33-16]# ls -al
    total 26748
    drwxr-xr-x 28 nfsnobody nfsnobody 4096 Oct 11 2012 .
    drwxrwxrwx 16 root root 4096 Oct 11 2012 ..
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 1ZXBHS
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 3S22XW
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 6HVTE1
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 8H40TL
    -rw-r--r-- 1 nfsnobody nfsnobody 196 Oct 11 2012 backup-my.cnf
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 BD5ACH
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 BWQEQJ
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 BZUH3A
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 C3FK8S
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 C7YXKI
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 companydb
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 DMLOHN
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 FKJNTO
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 FWVD53
    -rw-r
    1 nfsnobody nfsnobody 27262976 Oct 11 2012 ibdata1
    drwxr-xr-x 2 nfsnobody nfsnobody 4096 Oct 11 2012 mysql
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 PPFII0
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 QX2ZVX
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 SYST01
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 TNUHZZ
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 TVUQUW
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 UOHO9Q
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 utility
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 vta
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 WGLVAT
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 word_press_evgeny
    -rw-r--r-- 1 nfsnobody nfsnobody 4 Oct 11 2012 xtrabackup_binlog_info
    -rw-r
    1 nfsnobody nfsnobody 2048 Oct 11 2012 xtrabackup_logfile
    -rw-r--r-- 1 nfsnobody nfsnobody 0 Oct 11 2012 xtrabackup_suspended
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 YMDHPR
    drwx
    2 nfsnobody nfsnobody 4096 Oct 11 2012 YR4H4B
  • mboppudi@boardvantage.com[email protected] Entrant Inactive User Role Beginner
    Thank you for the information. database size is 1 gb I am not getting the error. The one I have problem is 9.2 GB database

    Thanks,
    Madhu
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.