Hello All,
I used restore DB backup script : https://gist.github.com/DamianCaruso/931358?signup=true
As I am new to Xtrabackup I am facing some difficulties on how to restore an incremental backup. In more details:
Full backup:
/home/navman/…/data/backups/full/2015-12-23_23-52-31/
Incremental backup:
/home/navman/…/data/backups/incr/2015-12-23_23-52-31/2015-12-23_23-52-41/
/home/navman/…/data/backups/incr/2015-12-23_23-52-31/2015-12-24_22-00-03/
/home/navman/…/data/backups/incr/2015-12-23_23-52-31/2015-12-25_22-00-02/
After preparing my incremental backups
I am facing below error. In MySQL I have multiple databases running in MySQL. So without stop MySQL and without doing Original data directory ‘/var/lib/mysql’ empty. How can restore db backup for single database?
innobackupex-1.5.1 failed:
---------- ERROR OUTPUT from innobackupex-1.5.1 ----------
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/ubuntu
IMPORTANT: Please check that the copy-back run completes successfully.
At the end of a successful copy-back run innobackupex-1.5.1
prints “completed OK!”.
innobackupex-1.5.1: Error: Original data directory ‘/var/lib/mysql’ is not empty! at /usr/b