Replicating MySQL DB to development machine - bad idea?
- by Joel
I am considering replicating a production MySQL database to my development machine so I've always got current data.
The production database is externally hosted. My development machine is behind an unreliable internet connection. It is entirely possible that the development machine could be disconnected from the internet for extended periods of time (hours).
Would there be any adverse effect on the production database by doing this?
(I don't strictly need live data - but it would be nice, and good excuse to dabble with replication. If the consensus is that this is a bad idea, I'll set up a daily job to import the previous night's backup into my development database)