What's the best way to store a MySQL database in source control?
- by Marplesoft
I am working on an application with a few other people and we'd like to store our MySQL database in source control. My thoughts are two have two files: one would be the create script for the tables, etc, and the other would be the inserts for our sample data. Is this a good approach? Also, what's the best way to export this information?
Also, any suggestions for workflow in terms of ways to speed up the process of making changes, exporting, updating, etc.