Wrong OS user permissions mentioned in documentation
General
Escalation
General
Escalation
Description
Environment
None
Smart Checklist
Activity
Show:

Sergei Glushchenko March 26, 2018 at 6:34 AM
Would be great to explain that for backup PXB needs:
rx for datadir
rwx for tmpdir and target-dir
Done
Details
Details
Assignee

Reporter

Labels
Time tracking
2h 17m logged
Components
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created March 22, 2018 at 9:55 AM
Updated March 6, 2024 at 7:29 PM
Resolved December 25, 2019 at 6:10 PM
In xtrabackup documentation it is mentioned that non root OS user required rwx permission on the data directory for taking a backup:
https://www.percona.com/doc/percona-xtrabackup/LATEST/innobackupex/privileges.html#permissions-and-privileges-needed
In tests, it can be seen that the backup works even without write permissions.
For background info, see https://percona.slack.com/archives/C03FT9TSW/p1521706950000188