Error when export data base
Once at time on the blog pages, we already considered export/import large files to MySQL. Sometime, if this operations does on the customer side and you have limited rights there, you can faced with error:
mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces.
Solution is very simple 🙂 Moreover solution we can found in the error text.
Problem: How to fix mysqldump error?
Solution: Just add option --no-tablespaces to command, for example:
mysqldump --no-tablespaces -h localhost -u database_name -p user_name > /path/to/file/data_base.sql