I'm working on a website that will be highly data-driven. Naturally this calls for databases (and lots of them). I am very new to this kind of web development so I was looking up how all this is done and how to sync any work I do before I get started, as I'm not interested in doing any work twice. The answer I'm finding seems to be pretty much "You can't sync them" for someone in my (very novice) situation. I've read something about a master/slave connection you can make, but it's very unlikely that the average web server will allow this. I've checked and I'm pretty sure mine doesn't (1&1).
SO! If it isn't possible to sync my local database with my live website database (when it comes into existence), then what is the point of using a local database at all?
Does anyone have any advice on the most efficient way to work with a non-syncable local or live database? Would there be any advantages to working with one over the other?
EDIT - I should mention this website is currently being built on my local WAMP server. It is not currently live online.