2016-03-15-mysqldump_permissions.md

Mysqldump permissions

Category: mysql Generated on 2016-03-15

User permission to use mysqldump properly

Using mysqldump with --opt (or anything else that locks tables)

Required permissions: SELECT, LOCK TABLES

Using mysqldump with --single-transaction

Only for InnoDB tables, see docs

Required permissions: SELECT