Error dumping tablespaces about backup HOT 4 CLOSED

I think it likely breaks the backup, according to a very quick google research. What's inside the resulting backup ? Does it seems to contain the right output ?

from backup.

As far as I can tell the dump contains the expected stuff and the file size looks about right. It even loads fine on a test database. If something's wrong with the dump as a result of this error, it's not obvious.

from backup.

I'm not entirely sure, but it seems in recent mysql versions, the general purpose tablespaces feature allow to configure how the data is stored in disk, i.e. not having all the innodb tables in the ibdata1 files like previously.
My current understanding of this is that you might not have the same layout on disk after re-importing the dump, since you didn't have the privilege to dump this tablespace configuration.

Anyway, this is not really a backup error, but more a mysql rights thing, in the sense that there's nothing to fix here.
I'll then close this issue :)

from backup.

Hello @elthariel, since it's an error that's thrown using the default configuration (when using mysql 5.7.31 or newer), it should at least be mentioned in the documentation or part of the example configuration to have db.additional_options = ["--no-tablespaces"] (or instruct to grant PROCESS privilege to the mysqldump user).

from backup.