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

xtrabackup incremental is failing against Percona server 5.6

prakash_balaprakash_bala EntrantInactive User Role Beginner
[[email protected] ~]# 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.

======================
[[email protected] ~]# 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

Comments

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.