Backup db with mysql option --no-tablespaces since MySQL 8.0.21

ℹ️ Support
1

Hi,
Since the update of MySQL to 8.0.21 my backup script for nc db was raising this error:
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces.

I solve this by following this answer.

My question is: Is my backup complete if I add the new option --no-tablespaces? Do I miss some information doing that? (Information I’ll need to backup nc in a failure case.)

Here is my full command: mysqldump --single-transaction --no-tablespaces -u ${db_user} -p${db_password} ${db_name} > ${db_backup_file}

Thank’s for you insights!

1 Like
2

Same problem here!
I’d really love to get a confirmation!

THX!

Best regards!

3

Same here.

I did not add the –no-tablespaces yet, since it seems that despite the error message the dump file is being crated properly.

4

Same here. Is out there any confirmation that --no-tablespaces option won’t destroy the database for recovery?
tnx.