Skip to main content Link Menu Expand (external link) Document Search Copy Copied
freistilbox Docs

Creating a database dump fails

When using just mysqldump db123 or drush sql-dump you might see this error message:

mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need (at least one of) the RELOAD privilege(s) for this operation (1227)

With newer versions of mysqldump the MySQL team introduced the requirement of privileges that we can’t provide since these provide admin level access in some cases.

This is why you should adapt your commands as such:

  • mysqldump --no-tablespaces --column-statistics=0
  • drush sql-dump --extra-dump="--no-tablespaces --column-statistics=0"

We are looking into making this easier and provide a longterm fix as well.