Posted by OldAccount on December 22, 2009 at 3:47pm
It's been quiet on the CODUG site lately, eh? Allow me to make some noise, please. :-)
My test and live sites are starting to become way out of sync, and I'm not sure how to resolve it. I want to start using the Deploy module so this doesn't happen again, but it sounds like you need to have matching databases to start off with, which mine definitely aren't at this point. I have new content (content types, nodes, images, etc.) on the test site that I don't want to lose, and also have content solely on the live site that I don't want to lose.
Any ideas how best to get them closely matched again? I apologize this is a somewhat vague request, please ask me to clarify anything unclear.
Thanks!
Comments
maatkit
You might look at http://code.google.com/p/maatkit/ . I haven't used it, but it appears to be actively developed. You can try on a some copies of your current database to see if it works. Otherwise, you are left with either http://www.webyog.com/en/index.php (sqlyog) or doing it by hand.
I'll try and respond to questions a bit more frequently and will be looking at maatkit myself.
Hope this helps.
Versioning control
I would look into creating version control on your servers. If you used Git or CVS and made your base web folder the main directory. You could push and/or pull from either server to the other server. Link to git tutorial: http://www.kernel.org/pub/software/scm/git/docs/gittutorial.html
Freelancer
Twitter sdudenhofer
seth@osjournal.net