Skip to main content

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