0

I want to replicate the schema of an AWS RDS instance (A) to a new RDS instance (B). I want B to have the same structure and databases as A, but I do not B to have the data of A. I want the tables in B to be empty. Is it possible to achieve this in AWS? Both A and B are MySQL instances.

I tried setting up B by restoring it from A's snapshot and unchecking the "copy tags" option, but it still copied the data to B.

looserfruit
  • 1
  • 3
  • 1
    You can use `pg_dump` to get a data-only `.sql` output file and then use `psql` to apply it on the new database: https://stackoverflow.com/questions/43228951/backup-of-postgresql-database-design-without-data – Mohammad Teimori Pabandi Feb 28 '23 at 10:36

0 Answers0