I've recently started putting some Drupal installations in to source control. Editing modules and the like is pretty easy since they're obviously just text files. I run in to issues with the database though.
My current idea is to run a cron job to pull in database from the live server every night to keep things up to date.
The current method is to just drop the local db and then mysqldump the live one on to my local machine.
I'm pretty sure doing it the way I currently am could cause me to lose things like content types and fields if I make new ones on the local machine and then the 'outdated' live db gets pulled in.
What is the best way to approach this situation?