Forums

I have a script which runs as a schedule task, which backs up the database every day, but since one week, it has been failing with the below error. When I run the script manually, it works fine. Has anyone faced this issue? Wondering if it has something to do with the account with which the scheduled tasks are run as from my account it’s working fine.

Error:

mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table fmb_thalisignupitem at row: 46893

It looks like you're not using the --no-tablespaces command-line flag for mysqldump -- see this help page for the details.

Thanks for the reply. I am actually using a library which backs up the database and pushes it to Dropbox. So I am not running the command directly. But I wonder why its working when I run it manually?

Maybe you could somehow configure it.