AWS Backup support Amazon RDS mysql schema level backup?

AWS Backup does not directly support schema-level backups for Amazon RDS MySQL databases. AWS Backup is designed to create full backups of RDS instances, including all databases and schemas within the instance.

However, if you need to perform schema-level backups for your Amazon RDS MySQL database, you can use native MySQL tools like mysqldump. This command-line utility allows you to create logical backups of specific schemas or databases within your RDS MySQL instance.

To use mysqldump for schema-level backups, you would run a command similar to this:

mysqldump -h <hostname> -u <username> -p <specific_schema_name> > backup.sql

This approach gives you more granular control over which schemas to back up, but it's important to note that this is not an AWS Backup feature. Instead, it's a method you would need to implement and manage separately from AWS Backup.

For comprehensive database backups and disaster recovery purposes, it's recommended to use AWS Backup in conjunction with Amazon RDS's built-in backup features. These provide full instance backups and point-in-time recovery capabilities, which are crucial for overall database protection.
Sources
Long-term backup options for Amazon RDS and Amazon Aurora | AWS Database Blog
How AWS Backup works with supported AWS services - AWS Backup