Re: [support] WAS Why .. now 3 ways to save the db which is best

Sorry - should have made the environment clear ..

Drupal 7.4, drush 4.4, mysql 14.14, PHP PHP 5.3.5.

andy

Following on from my post one twig up in this thread ..

So now I have three ways to save the database:

1. syncing from another machine with %dump=wherever... in the alias
2. drush sql-dump --result-file=wherever...
3. drush sql-sync @mysite @mysite

They all produce different sql - which is best?

From a processing perspective admittedly 3. is terrible because I presume it exports the db then re-imports it.

I seek a reliable practice to adopt then if I always do it the same way I can happily shove the current db in a git repo (hey its only a small database).

andy