- Newest
- Most votes
- Most comments
Since you did not specify what database engine it is, I will hazard a guess and assume its either MySql or PostgreSQL, For Mysql all you need to do is take a backup using mysqldump and then copy it to S3 or download it onto your corporate network for long term storage. https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
Similarly for PostgreSQL, you can use pgdump https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
and if you search online, you will find multiple examples of how to use both of these utilities. If your database in neither MySql nor PG, please update your DB engine and similar steps can be made suggested for that db engine.
If I understand correctly you are referring to stopping db instance with instance backup for added safety.
you can refer to https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_StopInstance.html
Another good website is https://www.mssqltips.com/sqlservertip/5503/how-to-save-costs-on-nonproduction-sql-server-rds-instances/ but the feature not limited to sql server instances.
Relevant content
- asked 2 years ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 3 years ago