Hello together, I have a small problem with the Xtrabackup from percona. Sometimes it happens that iI have problkems with the rights for Data in the Data dir afert restoring a backup. It happens not everytime so i have no clue where the error happens. Any suggestions where I can start for searching?
Hello @Totto,
This is normal behavior. One of the required steps when restoring a backup is to fix file permissions. Here’s a high-level example set of steps:
# cd /path/to/backup
# xtrabackup --prepare
# xtrabackup --copy-back --target-dir /var/lib/mysql
# chown -R mysql:mysql /var/lib/mysql
# systemctl start mysql