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.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With