Engine Yard Developer Center

Copy database tables to/from different environments

Reasons for copying databases tables to/from different environments:

  • You have multiple applications using independent tables within a single database that you want to deploy as independent environments.
  • You are splitting your application into multiple applications. These applications will each reside in their own environments and each segment of the application addresses its own distinct set of tables.

How to Copy Database Tables

MySQL

mysqldump [dbname] [table1] [table2] ... [tableN] | gzip > /db/migration_tables.sql.gz

PostgreSQL

pg_dump -Fc [dbname] -t [table1] -t [table2] ... -t [tableN] > /db/migration_tables.pgz

If you have feedback or questions about this page, add a comment below. If you need help, submit a ticket with Engine Yard Support.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.

Powered by Zendesk