Add optional `--no-tablespaces` parameter to `db export`

[garywong-bc]

As of MySQL 5.7.31, wp db export returns an error message (although the export still runs) of: now requires the PROCESS privilege

I'd like to add an optional parameter in $assoc_args as in: --no-tablespaces

I didn't see this Issue yet.. is no-one else seeing this? https://github.com/wp-cli/db-command/pulls?q=is%3Apr+tablespace

For further details, see:

• https://forums.cpanel.net/threads/cpanel-33473-mysql-dump-process-privilege-error-after-5-7-31-update.675657/
• https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-31.html

[broksonic21]

We ran into same issue - I'd love this to be addressed.

[chesio]

@schlessera I would suggest to move this issue to https://github.com/wp-cli/db-command/ for better visibility.

[schlessera]

Looks like it makes sense to include --no-tablespaces by default and provide an opt-out for that default for advanced use case (maybe --include-tablespaces as the opt-out?).

[noxludo]

As an agency, I use the wp db import/export commands for maintenance for all my customers (backup, restoration, migration)… and I have this error since my hosting company had updated all these servers. We need an update to add --no-tablespaces by default to be consistent with this recent mysql update as quickly as possible.

[schlessera]

Fixed via #182