Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What does AWS RDS snapshot include?

To me I care more about the schema, functions and triggers, and less on the data itself. From AWS document(https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html), it doesn't address my question clearly.

Amazon RDS creates a storage volume snapshot of your DB instance, backing up the entire DB instance and not just individual databases. ... Since the snapshot includes the entire storage volume, the size of files, such as temporary files, also affects the amount of time it takes to create the snapshot.

like image 542
jack2684 Avatar asked Sep 05 '25 15:09

jack2684


2 Answers

As far as I am aware, the schema, data, functions and triggers are all included. It includes all databases in the instance.

If you specifically don't want data to be backed up then you would need to create a manual backup process.

like image 172
Alex Bailey Avatar answered Sep 09 '25 18:09

Alex Bailey


Being block level backups, AWS RDS snapshots include schema and data.

If you want a schema-only backup then use pg_dump with the --schema-only directive for PostgreSQL or mysqldump with --no-data for MySQL.

like image 21
Jonathan Jacobson Avatar answered Sep 09 '25 19:09

Jonathan Jacobson