I would like to mirror Linux dev.example.com into Windows dev.example.com.local properly to be able to do development locally.
- I have already set up xampp and hosts (dev.example.com.local)
- I have created localhost mysql database instance (dev).
- I have set up Drupal 7 settings.php on local.
- I can export remote db into sql.zip file and I can import it into local db
The key question I have now is how to properly handle mysql export and import to make sure both local and remote mysql instances are in sync?
I bet Step 4 is not enough here.