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

[Andy Heath]

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
>