We are a software development company and are using WordPress for static portion of the web site. Naturally, all our workflow is built around version control: multiple developers -> continious integration -> staging -> deployment.
Our challenge with integrating WordPress into our workflow is that its database is stuck like a bone in the throat: you cannot put it into the version control, easily roll back, promote from staging to production etc.
I am wondering what people do in similar situations? I would like to find a way to integrate WP into the development workflow and not the other way around 🙂
Clarification we want to “develop” and test pages on the staging system and when ready then move them over to the production as part of the version upgrade process. We don’t want to do full replication of the staging database to production.
That’s a common question and one that I’ve worked on tackling. I’ve written some code to address these issues albeit the code’s not ready for distribution. Basically the idea is to create scripts to import the content and then version control the scripts. (Actually my approach uses a custom import/export format designed to be easy to hand-modify, but the idea is similar.)
Anyway, there are some related questions over on StackOverflow’s sister site WordPress Answers:
UPDATE
Per the clarification, this would probably be helpful too:
Hope this helps.
-Mike
I’ve just hit the same problem. For now we are using MySQL dump files to export/import database content, but it gets ugly with several people working on the database changes.
Since the team that works on the project is all internal and consists of just a few people, I’m thinking into the direction of locking the database dump file in VCS. Subversion had this functionality built-in, but we are using git, which, I think, is conceptually opposite of any kind of locking.
Probably we’ll have a workaround script with pre-commit hook to check for the existence of a lock file next to the dump. The person who committed the lock file will be the only one allowed to commit the dump. Once he finishes the work, he will need to commit the removal of the lock file.
It sounds ugly, I know. But I’ve thought about it for a while and don’t see an elegant solution yet.
If you’re only using WordPress for static content, then any tool/methodology for version controlling databases should work – for example, work the mysql command line tools into your CI and deployment routines.