I have started work on a wordpress site with a colleague. We are both developing the website on our local machines and have our separate databases. We share our work through Git. Now the problem is that I found out that wordpress uses the database to store some configurations regarding themes and plugins.
How can we share our database to have the same version all the time?
Just set up a database on a server that runs MySQL and allows access for both of you. Then you should change these lines in wp-config.php:
See also the WordPress support topic http://wordpress.org/support/topic/setting-up-wp-with-remote-database. Just keep the code in Git.
This is something that I struggle with as well. You have a few options, non of which are ideal. Your first is to host the database externally, IE thorugh amazon RDS, this will give a “cloud” database, that you can both access (so log as you add the IPs), or you can just use a shared host’s database. The second option is to have two separate, local DBs, and include the .sql dump in there as well, but there are problems with that as well.
I’d ask you to refer to a question I posted myself a few days ago, and got some REALLY solid answers from: Using version control (Git) on a MySQL database
Hope I helped