Not the answer you need?
Register and ask your own question!

A problem when preparing an Incremental Backup with innobackupex

CofycCofyc EntrantCurrent User Role Participant
I created full backup at /path/to/base, and incremental ones in /path/to/incr/<1,2,3..>.

But, when i restore backup, i got a weird problem.

First, i start with full backup, (step 1)


innobackupex --apply-log --redo-only base/</pre>


but when i (step 2)


innobackupex --apply-log --redo-only base/ --incremental-dir /path/to/incr/1</pre>


I got `basemysql`, `basemydb`, `baseanotherdb`, ... directories created in current working directory.

Is this a innobackupex bug? Or how can i do it correctly?

Here is partial log:

<cite>Quote:</cite>
...
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
120503 12:08:58 InnoDB: Starting shutdown...
120503 12:09:00 InnoDB: Shutdown completed; log sequence number 1045397503747
innobackupex: Starting to copy non-InnoDB files in '/backup/mysql/my.example.com/tmp/incr/1/'
innobackupex: to the full backup directory '/backup/mysql/my.example.com/tmp/base'
innobackupex: Copying file '/backup/mysql/my.example.com/tmp/base/xtrabackup_binlog_inf o'
innobackupex: Creating directory '/backup/mysql/hostname/tmp/basemysql'
innobackupex: Copying file '/backup/mysql/my.example.com/tmp/base/columns_priv.frm'
innobackupex: Copying file '/backup/mysql/my.example.com/tmp/base/help_category.frm
...

You see, there is a directory basemysql created...

P.S. xtrabackup version is 2.0.0
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.