How can restore backup without doing Original data directory 'mysql' empty.

Anandvastrad · December 30, 2020, 4:23pm

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 ----------

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

hvo408 · December 30, 2020, 4:32pm

What options do you pass to the innobackupex command? Try adding --force-non-empty-directories.

Anandvastrad · December 30, 2020, 4:32pm

I added

$INNOBACKUPEXFULL --defaults-file=$MYCNF --force-non-empty-directories --copy-back $FULLBACKUP > $TMPFILE 2>&1

How can resolve below error.?

~$ sudo sh restorebackup.sh /home/…/…/data/backups/full/2016-01-03_23-55-24 /

restorebackup.sh: MySQL backup script
started: Wed Jan 13 02:52:21 PST 2016

Restore 2016-01-03_23-55-24

Preparing …

Restoring …
stop: Unknown instance:
mysql start/running, process 8092
innobackupex-1.5.1 failed:

---------- ERROR OUTPUT from innobackupex-1.5.1 ----------

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: Starting to copy InnoDB system tablespace
innobackupex-1.5.1: in ‘/home/…/…/data/backups/full/2016-01-03_23-55-24’
innobackupex-1.5.1: back to original InnoDB data directory ‘/var/lib/mysql’
innobackupex-1.5.1: Error: Cannot overwrite file: /var/lib/mysql/ibdata1 at /usr/bin/innobackupex-1.5.1 line 2128.

Anandvastrad · December 30, 2020, 4:32pm

Before restore, I have 1 full backup and 3 incremental backups and 2nd Full backup,Newly data added in every backup. After executing restore script on 1st Full backup I am getting all data to till 2nd full backup not to till 1st full backup. May I know why this behavior happening in my script. Any suggestion.