While dumping a mysql database , and if you receive the error :
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
A possible solution to fix this problem , is by using the --no-tablespaces
option , so your database dump command , will look like this :
mysqldump --no-tablespaces -u user_name -p db_Name > backup_file.sql
Using --no-tablespaces
option , will suppress CREATE LOGFILE GROUP
, and CREATE TABLESPACE
statements , in the generated dump . This is related to, the ndb
cluster storage engine .