Managing databases from local to live

I created a development mirror on my local machine when I set up my multisite. This worked fine as I was the only person working on my system.

Now that I have people adding content to the sites I loose the ability to sync my database back and forth because it removes any pages/posts created on the live server that aren’t in the local database.

I find myself stuck at the moment as I won’t develop on my live server and wp import/export isn’t a suitable option either.

Whats the best way to go about managing this?