Comments on: Migrate to Amazon RDS Using Percona Xtrabackup https://www.percona.com/blog/migrate-to-amazon-rds-with-percona-xtrabackup/ Thu, 11 Apr 2024 22:35:55 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Daniel Kowalewski https://www.percona.com/blog/migrate-to-amazon-rds-with-percona-xtrabackup/#comment-10969467 Wed, 25 Jul 2018 16:26:41 +0000 https://www.percona.com/blog/?p=48712#comment-10969467 Hi Danny,

In which stage of the process are you getting that error? If you’re getting it while taking the backup, make sure that xtrabackup is using a MySQL user with appropriate privileges (in particular the SUPER privilege). The credentials can be specified in a defaults file, or with the –user and –password options to xtrabackup.

-Daniel

]]> By: Danny https://www.percona.com/blog/migrate-to-amazon-rds-with-percona-xtrabackup/#comment-10969466 Wed, 25 Jul 2018 15:45:06 +0000 https://www.percona.com/blog/?p=48712#comment-10969466 Hello Daniel,
Thanks for the great write up and comparison. We’re trying using the xtraback method but are running into the following error:

ERROR 1227 (42000) at line 72: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

]]>