Announcement

Announcement Module
Collapse
No announcement yet.

(Repost) InnoDB: Operating system error number 13 in a file operation

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • (Repost) InnoDB: Operating system error number 13 in a file operation

    Apologies vauvarin, we needed to restore the server and we lost the past couple days of posts. Please find your post and the response below and also in the image

    ---
    InnoDB: Operating system error number 13 in a file operation. #1 Yesterday, 02:21 AM
    Hi,

    This is my environnement:

    Ubuntu 12.04 LTS
    Maria DB 5.5
    Percona Xtrabackup
    WordPress Multisite

    I try to backup my DB with Xtrabackup

    innobackupex --defaults-file=/etc/mysql/my.cnf --user=user --password=xxx --no-lock --stream=tar /var/www/myprojet/backup | gzip - > /var/www/myprojet/backup/mariadb_backup.tar.gz

    ... but i have an error during the process:

    "InnoDB: Operating system error number 13 in a file operation.
    The error means mysqld does not have the access rights to the directory. File name ./ibdata1 ... "

    This is the access rights of /etc/lib/mysql show by " ln -l /etc/lib/mysql" :

    drwxr-xr-x 2 mysql mysql 4096 May 5 00:00 mysql
    -rw-rw---- 1 mysql mysql 18874368 May 5 02:17 ibdata1

    The error message speak about mysqld not mysql. Is it the problem?

    Do you have any idea how to solve this problem?
    Thanks


    --
    miguelangelnieto
    Percona Support Engineer

    Error 13 means: "OS error code 13: Permission denied"

    You should be running innobackupex as root user (unix user, not mysql one).

    The user you specify is used to connect to mysql and run some commands there, but it uses the unix user to copy files from the filesystem. So, in order to copy files from the datadir, the tool has to be executed as root.

    Also, check apparmor log, maybe it is causing problems.
    Is this an emergency? Get immediate assistance from Percona Support 24/7. Click here.
Working...
X