Can Restore from S3 use the files backed up by mysqljump to restore the database instance?

Question

I used mysqljump to back up the database, uploaded the sql file to S3 and used Restore from S3 to restore the database, and then failed and reported an error: "Incompatible-restore"
My database version and engine are the same, why does it show incompatibility?
Engine
MySQL Community
Engine version
8.0.35

S3
![Backup files on S3](/media/postImages/original/IMBnrHNW7IRq6vpa-i64mjSA)

Restore from S3 configuration
![Restore from S3 configuration](/media/postImages/original/IMz--DmwQgTLOF2PHdqezarQ)

IAM role permissions are automatically generated
![IAM role](/media/postImages/original/IMpMjDhzwYRPiAebSUVWrUjQ)

Database instance error message

```

May 23, 2024, 01:34 (UTC+00:00)	DB instance restarted
May 23, 2024, 01:35 (UTC+00:00)	DB instance shutdown
May 23, 2024, 01:38 (UTC+00:00)	The database instance was put into incompatible-restore. Unable to restore database.The backup file in S3 is invalid, or parameter values were incompatible.
May 23, 2024, 01:42 (UTC+00:00)	DB instance put into incompatible-restore state. RDS recommends that you initiate a point-in-time-restore.
```

Didier_Durand · Answer

Hi,

Did you look at the Limitations section of https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.html ?

Some may apply to your case:

```
* You can only import your data to a new DB instance, not an existing DB instance.
* You must use Percona XtraBackup to create the backup of your on-premises database.
* You can't import data from a DB snapshot export to Amazon S3.
* You can't migrate from a source database that has tables defined outside of 
the default MySQL data directory.
* Percona Server for MySQL isn't supported as a source database because it can contain 
compression_dictionary* tables in the mysql schema.
* You must import your data to the default minor version of your MySQL major version 
in your AWS Region. For example, if your major version is MySQL 8.0, and the default 
minor version for your AWS Region is 8.0.28, then you must import your data into a MySQL 
version 8.0.28 DB instance. You can upgrade your DB instance after importing. For information 
about determining the default minor version, see MySQL on Amazon RDS versions.
* Backward migration is not supported for both major versions and minor versions. For 
*example, you can't migrate from version 8.0 to version 5.7, and you can't migrate from 
version 8.0.32 to version 8.0.31.
* etc
```
Best,

Didier

Can Restore from S3 use the files backed up by mysqljump to restore the database instance?

Relevant content