Sample Header Ad - 728x90

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