Is it possible to copy a dev. database schema over a prod. one, but keep the prod. database' data?
0
votes
2
answers
923
views
I'm using MySQL 5.6. I have a production database and a development database.
As I'm developing the application, I sometimes need to add new columns/tables to the database. Is it possible, when I'm ready to update the production database, to take the dev. schema and "lay it over" the production schema, but let the production server keep its data?
Currently, I'm just using
mysqldump
and dumping out the whole database, and then copying it over the top of the other. It's working at the moment because the app isn't entirely in production mode, yet, but it's not gonna work forever.
Asked by zaemz
(163 rep)
Sep 11, 2014, 10:50 PM
Last activity: Sep 12, 2014, 09:29 AM
Last activity: Sep 12, 2014, 09:29 AM