I’m testing xtrabackup and I have some problems restoring a database. Perhaps someone could give me some pointers.
First I use innobackupex-1.5.1 --copy-back to restore data. After that mysql stopped functioning. One thing I noticed is that innobackupex-1.5.1 copies everything in the backup directory, including xtrabackup specific files and increments to the /var/lib/mysql directory.
I then purged and reinstalled mysql and manually copied all the relevant files (ib*,mysql/,%mydb%/. Now, through mysql workbench, I could see my database again, but not the tables within it. Although they are listed in the /var/lib/mysql/%mydb%
The reason is that by copying back, the permissions on the file were no longer owned by mysql
sudo chown -R mysql:mysql /var/lib/mysql