title: Development and Production Database?
body: <p>I'm working with PHP &amp; mySQL.  I've finally got my head around source control and am quite happy with the whole development (testing) v production v repository thing for the PHP part.</p>
  
  <p>My new quandary is what to do with the database.  Do I create one for the test environment and one for the production environment?  I currently have just the one which both environments use, leaving my test data sitting there.  I kind of feel that I should have two, but I'm nervous in terms of making sure that my production database looks and feels exactly the same as my test one.</p>
  
  <p>Any thoughts on which way to go?  And, if you think the latter, what the best way is to keep the two databases the same (apart from the data, of course...)?</p>