How to backup a MySQL Server with read_ony enabled without having SUPER privilege?
(Doc ID 3016985.1)
Last updated on JUNE 11, 2024
Applies to:
MySQL Enterprise Backup - Version 8.0 and laterInformation in this document applies to any platform.
Goal
Since privilege SUPER is deprecated, if the backup user doesn't have such privilege, it will prevent mysqlbackup to succeed when performing a backup operation, showing some messages like:
WARNING: MySQL query 'CREATE TABLE IF NOT EXISTS mysql.backup_progress ... : 1290, The MySQL server is running with the --read-only option so it cannot execute this statement
WARNING: MySQL query 'CREATE TABLE IF NOT EXISTS mysql.backup_history ... : 1290, The MySQL server is running with the --read-only option so it cannot execute this statement
WARNING: MySQL query 'CREATE TABLE IF NOT EXISTS mysql.backup_history ... : 1290, The MySQL server is running with the --read-only option so it cannot execute this statement
What privilege should be granted to the backup user to replace the SUPER privilege?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |