Our workflow under ACCESS db is to upload the whole database each time changes are made to the website. We've not got a test version of a MySQL database and would like to learn the "best" method of keeping the local and remote versions synchronized. I did a search for "Synchronization" in this topic and was surprised there were no hits. So my question is: does anyone synchronize a local MySQL database with a remote one on WinHost? What do you use?
You might want to look at MySQL Workbench. (Here's the sync doc.) We also have a blog post/tutorial called, Using mysqldump to backup and restore your MySQL database/tables. That might be worth a read as well.