- Newest
- Most votes
- Most comments
From my knowledge is that you can't natively restore from Parquet in AWS.
I know for example in MS SQL you can backup natively a full MS SQL Backup .BAK to an S3 bucket which you can later restore. This would be the knowning way to use an intergrated backup..
You may be able to achieve the same thing with a different database format.
If you start with understanding the process to restore, you can see what methods might work for saving / downloading locally. Here's an example of restoring a mySQL backup from On-premise to RDS. It contains a list of limitations and recommendations from importing data from S3 to RDS which is helpful. The documentation below focuses from on-prem to RDS, but since you're asking for the backup to be downloaded and stored locally, many of the same limitations and recommendations apply.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.html
Here's another answer on backing up the data using mysqldump. I know you said you are not able to interface with the database to run the tool, however it is the tool for the job. Running it on an EC2 instance or MySQLWorkbench are options.
Relevant content
- asked 8 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 9 months ago