[wp-hackers] Keep local DB in sync with remote DB

[Alex Hempton-Smith]

Hi,
I'm moving my development over to a local WAMP server, instead of uploading
files and checking the changes every time.
How would I keep my local mySQL database in sync with my remote mySQL
database?

The remote database is hosted at Dreamhost, so the database has a
mysql.mydomain.com
 address, rather than localhost, but when I use that on the local WAMP
server it shows "Error establishing a database connection".
Many thanks,
Alex