today-i-learnt

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