My last post dealt with the installation of the Percona Xtrabackup tool for use on a Mysql innodb database.
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
–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/
innobackupex –apply-log –user=****** –password=****** /path /to/backup
4. Restore backup
service mysqld stop
cp –r /path/to/backup /var/lib/mysql
chmod –R 771 /var/lib/mysql
service mysqld start
-n