mysql - How to automate update process between 2 databases -


i'm quite new mysql , in database management in general.... i've solve scenario: in development stage web site has database in local machine , tables dedicated contain information data used application ,during development records of tables grow , when move production want update production server new data... can advise best practice automate update process local production database.

thanks in advance

the road doing have each database know how far has migrated.

you should absolute use liquibase or flyway it. if have simple database environment these 2 work. both of these track changes in version files database keep track of.

if need more complexity, in sharded environment, need roll own tool this.


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -