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

 

 

 

Related articles

Andrew Fletcher18 Mar 2024
Resolving CVE-2022-48624 less issue
To resolve the CVE-2022-48624 vulnerability on Ubuntu using Nginx, it's crucial to understand that the issue lies within the "less" package, not Nginx itself. The vulnerability affects "less" before version 606, where close_altfile in filename.c in less omits shell_quote calls for LESSCLOSE,...