cancel
Showing results for 
Search instead for 
Did you mean: 

Using --no-tablespace option when backing up Magento 2 databases

Highlighted

Using --no-tablespace option when backing up Magento 2 databases

Hi - I run a nightly cron job to back-up to backup my SQL databases using mysqldump.

 

This has started to display the following error on all my databases:

Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

One of the solutions for this is to run the mysqldump using the --no-tablespace option.

 

Is this a safe practice, and recommended practice, to implement with Magento 2 databases?

2 REPLIES 2
Highlighted

Re: Using --no-tablespace option when backing up Magento 2 databases

Are you using the root user or a database user to run the mysqldump? 

 

Did you assign the necessary privileges (in this case PROCESS) to the user? 

Highlighted

Re: Using --no-tablespace option when backing up Magento 2 databases

Hi - the job is defined in the cron tab of the user's cPanel.

 

I get the same error if run the backup script from SSH using the user login and the root login.

 

All privileges are assigned to the database for the user.

 

This script ran fine for about 5 years. I don't think the version of SQL has updated. We are still running v5.6.49.

 

My understanding is that the tablespaces are reliant on a global privilege and not a user privilege.