[lug] mysqldump versus snapshot versus..

[dio2002 at indra.com]

> steve at badcheese.com wrote:
>> The only thing tricky about doing DB backups is getting a good, solid
>> snapshot of the DB.  This generally means 'locking' the tables as you
>> dump them.
>
> Or... get a real commercial DB with a "quiescent" mode specifically
> designed for the purpose where the DB tables are stopped and changes are
> written to logical logs while the snapshot is being taken.
>
> Just a thought.

all good thoughts.  my app happens to be using mysql so the choice is out
of my control for right now unless i want to rewrite it and i don't :-). 
thanks for the insight.