Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm working on a project using git for version handling. What is the best approach to include a mysql database in the cvs?

For example, if I checkout the database and install it at home, make some changes and check it in, I would like the changes I've made to be merged into the database. And I would like to be able to rollback these changes.

share|improve this question
    
That depends on the database. –  surfasb Jan 18 '12 at 20:25
add comment

1 Answer

With the projects I've seen and the databases I've managed, usually the best way to do this is to script the scheme and then include the scheme with the commit along with a script of the changes you make. That also makes it rather easy to compare changes.

Also look here:

http://stackoverflow.com/questions/173/how-do-i-version-my-ms-sql-database-in-svn

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.