You need the FILE
privilege in order to be allowed to use SELECT...INTO OUTFILE
, which seems to be what mysqldump --tab
uses to generate the tab-separated dump.
This privilege is global, which means it may only be granted "ON *.*
" :
GRANT FILE ON *.* TO 'backup'@'%';