db icon indicating copy to clipboard operation
db copied to clipboard

error output but also success snapshot?

Open kevzettler opened this issue 3 years ago • 1 comments

I'm getting this error but it also says a snapshot was made successfully. I'm concerned that its taking invalid snapshots.

mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
Successfully made snapshot of database - hash 9ecae82faec85196449a3e2ffa13f25eb0db95d35e9d2cabf14f530e

kevzettler avatar Jan 14 '22 01:01 kevzettler

to fix this I had to add the --no-tablespaces to the mysqldump commands. I'm not sure what the side effects are. Apparently this can also be remedied with Grant PROCESS permissions on the user account.

seems his may be a feature added in newer mysql? found more info from this blog post at: https://anothercoffee.net/how-to-fix-the-mysqldump-access-denied-process-privilege-error/

kevzettler avatar Dec 10 '22 05:12 kevzettler