Need Insight - What is the best practice for syncing up a production database that will be used on a
- by james
I have a site set up using CakePHP and MySQL and I want to work on a test database without disrupting my live site in case something goes wrong.
I have another busy site, but my test site runs off the live database which can be occasionally nerve wracking.
What do I do if I change a table name in the test db and I want it changed in the live database? Or if I remove a record from the test database. Is there a way to diff the changes? How do I even merge those changes?
How does this interfere with live user edits and things of that nature?
Hopefully some of you working devs can share some insight!