Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

are 'SELECT' and 'LOCK' privileges enough for a 'mysql database user' to take a full database backup via SSH? I am able to take a backup using these privileges, but unsure if I am backing up all the files properly. So my question is, are these two privileges enough or does the user need more privileges in order to take a proper backup?

share|improve this question

1 Answer 1

Depending on the options you use with the dump you may need more (or less). The one you definitely need is SELECT.

  • If you use triggers you need TRIGGER
  • If you use views you need SHOW VIEW
  • If you don't use --single-transaction in the dump you will need LOCK TABLES

For more info on the subject you can go to: http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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