How to copy only Mysql database structure from development to production server (production server have data, and development server no )

Question

As the question says, i create, delete columns from tables in my development server, after i finish all changes, i will like to apply the news columns created or deleted on development server to production server, problem is, how to only update changes of table structures only without affecting production server data(where its not necessary).

What i have tried is, if in development server i create x column on y table, then i have to manually create or delete all those columns on production server.

nologin · Accepted Answer · 2020-07-12 08:43:38Z

1

You should/can create a file migration.sql with your sql-statements regarding the schema-migration.

There are several migration-techniques which might fit your needs. It is always needed to take care about a fallback/rollback mechanism if sthg is failing.

Possibilities are:

working with temp-tables and copying.
data processing to the new schema on the fly

Prepare your backup!

Have a look at e.g.: https://flywaydb.org/

answered Jul 12, 2020 at 8:43

nologin

1,45010 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3296414 Over a year ago

Found some answers here, thanks. stackoverflow.com/questions/4580417/…

Collectives™ on Stack Overflow

How to copy only Mysql database structure from development to production server (production server have data, and development server no )

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related