I’m trying to improve MySQL from 5.6 to five.7 and every little thing appears to be working, however when I attempt to run xtrabackup I’m now getting this error:
InnoDB: Allotted tablespace ID 12 for percona/checksums, outdated most was 0 InnoDB: Working system error quantity 13 in a file operation. InnoDB: The error means mysqld doesn't have the entry rights to the listing. xtrabackup: error: xb_load_tablespaces() failed witherror code 11
Nothing has modified, mysql consumer perms, system consumer perms, listing perms, nor construction, however now I’m seeing this error. I can’t replicate the issue after I run the command as root, so it leads me to consider it’s a system permission challenge.
I quickly disabled selinux to take away it as a distractor. I additionally granted ALL to the databacker mysql consumer in case it was a brand new permission that I used to be lacking.
Right here is the command I exploit:
su -s /bin/bash databacker -c "innobackupex --user=databacker --password=p4ssw0rd --socket=/var/lib/mysql/mysql.sock --stream=tar /tmp | gzip - > /tmp/wtf.tgz"
I examined perms because the databacker consumer and all of it appears to work as anticipated:
su -s /bin/bash databacker -c "cd /tmp && contact check.txt" su -s /bin/bash databacker -c "cd /var/lib/mysql && contact check.txt"
What am I lacking?