Question about exporting snapshots to S3.

0

Guys, I'm a beginner here, and I have a specific question about one of the last steps regarding exporting snapshots to S3.

As indicated, the step by step would be as follows:

"> In the list of snapshots, choose the snapshot that you want to export.

For Actions, choose Export to Amazon S3. The Export to Amazon S3 window appears. For Export identifier, enter a name to identify the export task. This value is also used for the name of the file created in the S3 bucket."

The problem is that when I select the snapshot I want to export, no exclusive "Export to Amazon S3" button appears.

For me, the following buttons appear as shown in the attached image:

"> restore snapshot

copy snapshot share snapshot migrate snapshot** delete snapshot"

**(this "migrate snapshot" button is not available to me)

screenshot of where I left off in the step by step

Anyway, this is the situation:

Question 1: Am I on the right path? Question 2: Could anyone show it through images? Well, I'm a layman!

Anyway, thanks everyone! I was recommended to post my question about technical problems here!

Att, Fernando F

4 Answers
2

Just note, you will not be able to import from S3 after you export as they are stored in Apache Parquet format

profile picture
EXPERT
answered 2 months ago
EXPERT
Leo K
reviewed 2 months ago
1

Do you have some more details about the database? I pulled this from the docs:

The Export to Amazon S3 console option appears only for snapshots that can be exported to Amazon S3. A snapshot might not be available for export because of the following reasons:

The DB engine isn't supported for S3 export.

The DB instance version isn't supported for S3 export.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ExportSnapshot.html

I'm not exactly sure how current this list is:

Supported Engines

  • Amazon RDS for PostgreSQL
  • Amazon RDS for MariaDB
  • Amazon RDS for MySQL
  • Amazon Aurora PostgreSQL
  • Amazon Aurora MySQL

Not Supported Engines

  • RDS for Db2
  • RDS for Oracle
  • RDS for SQL Server

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDS_Fea_Regions_DB-eng.Feature.ExportSnapshotToS3.html

profile pictureAWS
EXPERT
David
answered 2 months ago
profile picture
EXPERT
reviewed 2 months ago
profile picture
EXPERT
reviewed 2 months ago
  • Hi, thanks for the reply.

    I checked here and here is the information I found:

    DB engine sqlserver-ex

    DB engine version 15.00.4335.1.v1

    Does this mean that it is actually in the "Not Supported Engines"? What could I do in this situation?

0

Hello,

Here's a super simple answer with yes/no to get you going:

Question 1: Am I on the right path?

  • Maybe! Checking the region and engine compatibility is a good first step.

Question 2: Could anyone show it through images?

  • No images needed for this part. Just follow these steps:

Check Region: Note the region where your RDS instance is located (e.g., US East).

Verify Engine: Identify the engine type of your RDS instance (e.g., MySQL).

Next Steps:

  • Open a web browser and visit this link: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ExportSnapshot.html
  • Look for a table titled "Supported Regions and DB Engines for Exporting Snapshots to S3".
  • Compare your region and engine type with the table.
  • Match: "Export to S3" should be available (might be a temporary glitch, refresh or contact support).
  • No Match: "Export to S3" is not supported for your setup. Consider alternative solutions like downloading the snapshot locally.

Remember: Standard buttons like "Restore Snapshot" are normal for RDS snapshots. You might not see "Export to S3" due to region or engine limitations.

profile picture
EXPERT
answered 2 months ago
profile picture
EXPERT
reviewed 2 months ago
  • Hi, thanks for the reply.

    I checked the location, everything is fine! N Virginia!

    Now regarding the Engine, I found this information here:

    DB engine sqlserver-ex

    DB engine version 15.00.4335.1.v1

    Do you know if I can perform this export? In one of the answers above, apparently it couldn't... it would be "Not Supported Engines"!

    What do you think? What could I do as a plan B, if needed?

0

Which database engine are you using? It's mentioned in documentation that not all database engines support exporting snapshots: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ExportSnapshot.html#USER_ExportSnapshot.Exporting

EXPERT
Leo K
answered 2 months ago
profile picture
EXPERT
reviewed 2 months ago