After some tweaking and help from the Percona Docs, the following is a test backup, prep and restore of the full database (not incremental).
This assumes a test environment, so please don't try this on a running production environment. Before the database can be restored, the existing one will have to be renamed or moved. The options for this are straightforward. Stop the mysql daemon and make a binary copy of the files, or rename the source folder.
0. Login as root/su
1. Prerequisite configuration items
Configure datadir and in my.cnf and reboot mysqld service
nano /etc/my.cnf
--find section
[mysqld]
--add line
datadir=/var/lib/mysql
service mysqld restart
2. Run full backup of specific database
innobackupex --defaults-file=/etc/my.cnf --user=***** --password=***** --databases=mydbname /path/to/backup/
--add line
datadir=/var/lib/mysql
service mysqld restart
2. Run full backup of specific database
innobackupex --defaults-file=/etc/my.cnf --user=***** --password=***** --databases=mydbname /path/to/backup/
3. Prepare backup files
innobackupex --apply-log --user=****** --password=****** /path /to/backup
4. Restore backup
service mysqld stop
cp –r /path/to/backup /var/lib/mysql
innobackupex --apply-log --user=****** --password=****** /path /to/backup
4. Restore backup
service mysqld stop
cp –r /path/to/backup /var/lib/mysql
chown –R mysql:mysql /var/lib/mysql
chmod –R 771 /var/lib/mysql
service mysqld start
-n
chmod –R 771 /var/lib/mysql
service mysqld start
-n
