When performing drush sql-dump, should I set the site in maintenance mode or will this command makes sure a coherent dump will be generated even if users are busy using Drupal? I can't find confirmation in the documentation.

1 Answer 1


According to Moshe's answer in advantages of drush bam vs. drush sql-dump / drush sql-connect, the answer is no. drush sql-dump does the right thing and will result in a consistent backup.

  • 2
    This is correct. sql-dump calls through to mysqldump or pg_dump, which are guaranteed to be atomic operations. Feb 17, 2012 at 19:16
  • many thx for the answer. Well i am convinced! You point me into the right direction.
    – zero
    Feb 17, 2012 at 22:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.