You can use the Commvault software to back up and restore a MySQL server instance that is hosted in the Alibaba RDS cloud.
Supported MySQL Versions
-
MySQL 8.0.x
-
MySQL 5.7.x
-
MySQL 5.6.x
Note
To back up and restore data using MySQL version 8 on Windows, install Microsoft Visual C++ libraries.
User Account Requirements
The MySQL user account must have the following minimum permissions to perform cloud based backup and restore operations using dump-based solutions:
|
|
Example:
CREATE USER 'new_master_user'@'%' IDENTIFIED BY 'StrongPassword!';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'new_master_user'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;