Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I searched here and googled for this answer but had no success.

I need to block the export option from a user at my MySQL database, is there a way to do it? I already blocked the update and edit options.

share|improve this question
What are you trying to do? Is this from some kind of write-only logging setup, or will users need to be able to read data? – Zoredache Jan 10 '12 at 22:25
Hello, users will be permited to read the data, but not allowed to dump the data. – Rodrigo Ferrari Jan 18 '12 at 16:47
up vote 1 down vote accepted

And Google did not reveal the MySQL documentation about that topic? My Google did:

The solution is the opposite of Minimum permissions for a user to perform a mysqldump?

share|improve this answer
I searched it, but did not found any instruction to deny dump...the other options I did! – Rodrigo Ferrari Jan 10 '12 at 21:39
Love "The solution is the opposite of Minimum permissions for a user to perform a mysqldump?" – ceejayoz Jan 10 '12 at 21:41
Thanks, I´m portuguese and some words in english to search is difficult to me. – Rodrigo Ferrari Jan 10 '12 at 22:58

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.