0

i want to develop some php stuff with a friend together. We managed to sync our local projects with an subversion repository on unfuddle.com and with subclipse. Now we need to now how to synchronize the local mysql databases, too. (We both use xampp and we want to use Mysql Workbench to mange the tables)

It's not an option for us to use an online database, because we want to able to write and test code offline.

I'm really a noob at mysql dbs, i just know how to let my php work with them. so a programm or a eclipse plug-in which could let use the unfuddle repository would be perfect.

Thank you very much,

Someonelse

Improve this question
1
  • 1
    Send each other your bin logs :D Commented Aug 22, 2011 at 0:23

1 Answer 1

Reset to default
3

First of all, it's a bad idea to share a development database. It makes it very difficult to get consistency when other people may be modifying your data. It will very likely interfere with your thought process while coding.

I would recommend adding your database schema (or snapshots) to the svn repository and load them on each database instead. Once you get more comfortable with this, you can start looking at using an ORM like Propel to manage your database schema and preferably a whole framework like Symfony as well.

Now, if you're really stubborn about doing this (and a little crazy too) If you're in the same LAN, look at master-master replication.. It might work remotely too, but depending on the amount of data being read/written it might be really laggy. Again, you'll likely end up having problems regardless of what route you go with if you decide to share a single db.

Cheers!

Improve this answer
Sign up to request clarification or add additional context in comments.

4 Comments

Thanks for the answer. I dont quite undestand everything, but its ok. My friend knows more about this, maybe he knows what to do. I think the master-master replication is what we want, but why is it laggy? The dbs dont dont neeed to sync on every edit, just when we want them to
master-master is real time, and there's no standard way to make them sync only when you want them to.. If that's what you want, I'd recommend you add a snapshot to your source control instead, then load it to your database.
also.. if you're learning source control from scratch, you might as well use git instead. It's much better and faster than svn. Here's a good tutorial: codingsnippets.com/getting-started-with-git
thanks for the clarification and recommendation. we'll probably use the snapshot solution.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.