How do I mirror a database from remote Linux into Windows localhost?

Question

I would like to mirror Linux dev.example.com into Windows dev.example.com.local properly to be able to do development locally.

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.

stefgosselin · Accepted Answer · 2011-12-02 20:58:30Z

2

Step 4 is enough, they both will be in sync until you change data on one or the other instance.

As a bonus tip, you can ease this procedure by using drush to sync your environnements, via the use of drush aliases.

More details on this here.

Good-luck friend, happy coding.

answered Dec 2 '11 at 20:58

stefgosselin

2,9111 gold badge22 silver badges34 bronze badges

I like answers of @greg-anderson and @betaride too but this one in my opinion is the most relevant to the question. – Refineo Dec 15 '11 at 10:44

Add a comment |

greg_1_anderson · Accepted Answer · 2011-12-03 14:33:41Z

1

You need only add an important step 5 to the above list:

Unfortunately, drush sql-sync is not currently supported on Windows. Patches welcome!

answered Dec 3 '11 at 14:33

greg_1_anderson

21k2 gold badges27 silver badges44 bronze badges

thank you , as you noticed I am looking for a Windows compatible solution here. – Refineo Dec 3 '11 at 16:24

Add a comment |

BetaRide · Accepted Answer · 2011-12-03 16:04:38Z

1

A very hand module for this is backup and migrate. It creates or intalls a complete backup of your db with one mouse click.

answered Dec 3 '11 at 16:04

BetaRide

5,33717 silver badges31 bronze badges

Add a comment |

3 Answers 3