Andrew Fletcher published: 3 August 2021 1 minute read
When attempting to backup mysql using the mysqldump command
mysqldump -u root -p database_name > backup.sql
However, it is throwing an error:
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
What to do?
Reading through the mysqldump documentation, you need use --no-tablespaces. So the command becomes
mysqldump -u root -p database_name > backup.sql --no-tablespaces