# xtrabackup incremental is failing against Percona server 5.6

**URL:** <https://forums.percona.com/t/xtrabackup-incremental-is-failing-against-percona-server-5-6/4495>\
**Category:** Percona XtraBackup\
**Created:** [November 4, 2015, 6:50pm UTC](https://forums.percona.com/t/xtrabackup-incremental-is-failing-against-percona-server-5-6/4495 "2015-11-04T18:50:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![prakash\_bala](https://avatars.discourse-cdn.com/v4/letter/p/c37758/32.png) [@prakash\_bala](https://forums.percona.com/u/prakash_bala)\
**Post date:** [November 4, 2015, 6:50pm UTC](https://forums.percona.com/t/xtrabackup-incremental-is-failing-against-percona-server-5-6/4495/1 "2015-11-04T18:50:51Z")

</div>

[root@gtemp1-sora1 ~]# mysql  
Welcome to the MySQL monitor. Commands end with ; or \g.  
Your MySQL connection id is 19  
Server version: 5.6.26-74.0 Percona Server (GPL), Release 74.0, Revision 32f8dfd

Copyright (c) 2009-2015 Percona LLC and/or its affiliates  
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

======================  
[root@gtemp1-sora1 ~]# innobackupex --user=bkpuser --password=s3cret --incremental /data2/mysql --incremental-basedir=/data2/mysql/2015-11-04\_23-29-23  
151104 23:54:30 innobackupex: Starting the backup operation

IMPORTANT: Please check that the backup run completes successfully.  
At the end of a successful backup run innobackupex  
prints “completed OK!”.

151104 23:54:31 version\_check Connecting to MySQL server with DSN ‘dbi:mysql:;mysql\_read\_default\_group=xtrabackup;mysql\_socket=/var/lib/mysql/mysql.sock’ as ‘bkpuser’ (using password: YES).  
151104 23:54:31 version\_check Connected to MySQL server  
151104 23:54:31 version\_check Executing a version check against the server…  
151104 23:54:31 version\_check Done.  
151104 23:54:31 Connecting to MySQL server host: localhost, user: bkpuser, password: set, port: 0, socket: /var/lib/mysql/mysql.sock  
Using server version 5.6.26-74.0  
innobackupex version 2.3.2 based on MySQL server 5.6.24 Linux (x86\_64) (revision id: 306a2e0)  
incremental backup from 1634336 is enabled.  
xtrabackup: uses posix\_fadvise().  
xtrabackup: cd to /var/lib/mysql  
xtrabackup: open files limit requested 0, set to 1024  
xtrabackup: using the following InnoDB configuration:  
xtrabackup: innodb\_data\_home\_dir = ./  
xtrabackup: innodb\_data\_file\_path = ibdata1:12M:autoextend  
xtrabackup: innodb\_log\_group\_home\_dir = ./  
xtrabackup: innodb\_log\_files\_in\_group = 2  
xtrabackup: innodb\_log\_file\_size = 50331648  
151104 23:54:31 \>\> log scanned up to (1643465)  
xtrabackup: Generating a list of tablespaces  
Error: failed to execute query FLUSH NO\_WRITE\_TO\_BINLOG CHANGED\_PAGE\_BITMAPS: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

---

<div class="post-metadata">

**Author:** ![prakash\_bala](https://avatars.discourse-cdn.com/v4/letter/p/c37758/32.png) [@prakash\_bala](https://forums.percona.com/u/prakash_bala)\
**Post date:** [November 4, 2015, 7:01pm UTC](https://forums.percona.com/t/xtrabackup-incremental-is-failing-against-percona-server-5-6/4495/2 "2015-11-04T19:01:19Z")

</div>

Sorry, user error 🙂
