Sync database structure/data for development
I have recently started on a project that is being developed for personal and for work related objectives. I have setup an SVN server to sync my project files between my work and home machines where I do my development. My issue now is how to synchronize my MySQL database between the two locations?
Would it be best to just mysqldump the whole database structure into a .sql file and add that to the SVN?
I would setup a remote access MySQL server, but my concern is that one location may not have access to the database if the internet connection at either location goes down.