Thanks for reaching out to us via AWS re:Post. I just saw this post and checked with my peers and found the below info.
The minor version MySQL 8.0.29 release has been deprecated and that's the reason that you couldn't find the version in the list any more. At this point, recommendation is for customers that have visible symptoms of a crash we recommend they do a Point-In-Time-Restore (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIT.html ) to recover the database. Please accept my sincere apologies on behalf of AWS for the inconvenience caused by this.
When the new version is released and available on RDS we’ll inform you and the rest of our AWS community on our announcements page here: https://aws.amazon.com/new/
If you would like to downgrade your instance to version 8.0.28, below options are available:
- Using Native MySQL import export tool:
You can use tools like mysqldump/Mydumper/Myloader to import and migrate from existing RDS MySQL instance on 8.0.29 to another instance on 8.0.28 version.
Please kindly review the below documentation for more details:
[+] Importing data from a MySQL or MariaDB DB to a MySQL or MariaDB DB instance - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.SmallExisting.html
[+] Importing Data to an Amazon RDS MySQL or MariaDB DB Instance with Reduced Downtime - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html
- Using AWS Database Migration Service:
Please use the below resources to get more familiar with DMS working and settings before getting stared with the service:
[+] Migrate to an Amazon RDS or Aurora MySQL DB instance using AWS DMS: https://aws.amazon.com/premiumsupport/knowledge-center/migrate-mysql-rds-dms/
[+] What is AWS Database Migration Service? - https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html
[+] How AWS Database Migration Service works - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.html
Hope this helps in your project.
Dear Customer - there was an issue found with this version, for more details pertaining to it and w.r.t. your RDS instance I would request you to kindly log a case with premium Support AWS RDS Team..
RDS MySQL 5.6 > 5.7 Update Issuesasked 6 months ago
RDS MySQL not upgrading minor version (even though it shows "upgrading")asked 6 months ago
Aws Aurora RDS Mysql instance unusual cpu spike patternasked 8 months ago
RDS MySQL 8.0.29 version is deprecated. Could not do upgrade or modify anything.asked 22 days ago
MySQL upgrade to version 8.0.17asked 3 years ago
Unable to upgrade from version 5.7 to 8 MySQLAccepted Answerasked 7 months ago
Mysql 8.0.29 issues (version disappear)asked 22 days ago
MySQL upgrade to version 5.7asked 3 years ago
RDS MYSQL 8.0 parameter group value is not updatingasked 8 months ago
Cant Modify or Update MySQL RDS Database. "Minor version 8.0.29 has been deprecated."asked 19 days ago