Can no longer disable MySQL tablespaces #1324

New issue

Closed

opened 2026-06-17 17:57:17 +00:00 by zewt · 2 comments

zewt commented 2026-06-17 17:57:17 +00:00

Copy link

What I'm trying to do and why

mysqldump needs extra permissions to dump tablespaces. Prior to 2.1.6 you could disable them using --no-tablespaces if you don't use tablespaces to avoid needing extra permissions on the backup user, but this no longer works in 2.1.6 because it forces --all-tablespaces. This causes every run to output:

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

It's not fatal, it's just one command of mysqldump's failing and the rest of the output continues, but it definitely looks fatal (and isn't something people should get in the habit of ignoring).

I experimentally tried editing hooks/data_source/mysql.py to put --all-tablespaces earlier to see if simply moving it before extra_options would fix it, but --all-tablespaces still overrides --no-tablespaces. I don't know if people normally run their backups with PROCESS permissions and don't run into this, but it'd be nice to have a way to disable --all-tablespaces so it can still be run cleanly without the process permission.

Steps to reproduce

mysql_databases:

• options: --no-tablespaces

Actual behavior

No response

Expected behavior

No response

Other notes / implementation ideas

No response

borgmatic version

2.1.6

borgmatic installation method

No response

Borg version

1.4.4

Python version

No response

Database version (if applicable)

mysql 8.0.46

Operating system and version

AlmaLinux 9.8

### What I'm trying to do and why mysqldump needs extra permissions to dump tablespaces. Prior to 2.1.6 you could disable them using --no-tablespaces if you don't use tablespaces to avoid needing extra permissions on the backup user, but this no longer works in 2.1.6 because it forces --all-tablespaces. This causes every run to output: mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces It's not fatal, it's just one command of mysqldump's failing and the rest of the output continues, but it definitely looks fatal (and isn't something people should get in the habit of ignoring). I experimentally tried editing hooks/data_source/mysql.py to put --all-tablespaces earlier to see if simply moving it before extra_options would fix it, but --all-tablespaces still overrides --no-tablespaces. I don't know if people normally run their backups with PROCESS permissions and don't run into this, but it'd be nice to have a way to disable --all-tablespaces so it can still be run cleanly without the process permission. ### Steps to reproduce mysql_databases: - options: --no-tablespaces ### Actual behavior _No response_ ### Expected behavior _No response_ ### Other notes / implementation ideas _No response_ ### borgmatic version 2.1.6 ### borgmatic installation method _No response_ ### Borg version 1.4.4 ### Python version _No response_ ### Database version (if applicable) mysql 8.0.46 ### Operating system and version AlmaLinux 9.8

witten commented 2026-06-17 22:58:47 +00:00

Owner

Copy link

Thanks for filing this. It looks like it was caused by #1303. What I think I'll do as a solution is to add a database-level configuration option to disable dumping of tablespaces. Then you wouldn't need to use extra_options for this, and you could just disable dumping of tablespaces directly.

Thanks for filing this. It looks like it was caused by #1303. What I think I'll do as a solution is to add a database-level configuration option to disable dumping of tablespaces. Then you wouldn't need to use `extra_options` for this, and you could just disable dumping of tablespaces directly.

witten referenced this issue from a commit 2026-06-17 23:26:19 +00:00

For the MariaDB and MySQL hooks, add "events", "routines", and "tablespaces" options for disabling dumping of scheduled events, stored routines, and tablespaces, respectively (#1324).

witten commented 2026-06-17 23:28:14 +00:00

Owner

Copy link

This is implemented in main and will be part of the next release! The new option to disable this is just tablespaces: false in your database config. I also added similar events and routines options, and added all of these to the MySQL hook as well.

This is implemented in main and will be part of the next release! The new option to disable this is just `tablespaces: false` in your database config. I also added similar `events` and `routines` options, and added all of these to the MySQL hook as well.

witten closed this issue 2026-06-17 23:28:14 +00:00

Sign in to join this conversation.

No Branch/Tag specified

Branches Tags

main

bootstrap-multiple-latest-archives

parallel-borgmatic

command-hook-steps

2.1.6

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.1.0

2.0.13

2.0.12

2.0.11

2.0.10

2.0.9

2.0.8

2.0.7

2.0.6

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

1.9.14

1.9.13

1.9.12

1.9.11

1.9.10

1.9.9

1.9.8

1.9.7

1.9.6

1.9.5

1.9.4

1.9.3

1.9.2

1.9.1

1.9.0

1.8.14

1.8.13

1.8.12

1.8.11

1.8.10

1.8.9

1.8.8

1.8.7

1.8.6

1.8.5

1.8.4

1.8.3

1.8.2

1.8.1

1.8.0

1.7.15

1.7.14

1.7.13

1.7.12

1.7.11

1.7.10

1.7.9

1.7.8

1.7.7

1.7.6

1.7.5

1.7.4

1.7.3

1.7.2

1.7.1

1.7.0

1.6.6

1.6.5

1.6.4

1.6.3

1.6.2

1.6.1

1.6.0

1.5.24

1.5.23

1.5.22

1.5.21

1.5.20

1.5.19

1.5.18

1.5.17

1.5.16

1.5.15

1.5.14

1.5.13

1.5.12

1.5.11

1.5.10

1.5.9

1.5.8

1.5.7

1.5.7.dev0

1.5.6

1.5.5

1.5.4

1.5.3

1.5.2

1.5.1

1.5.0

1.4.22

1.4.21

1.4.20

1.4.19

1.4.18

1.4.17

1.4.16

1.4.15

1.4.14

1.4.13

1.4.12

1.4.11

1.4.10

1.4.9

1.4.8

1.4.7

1.4.6

1.4.5

1.4.4

1.4.3

1.4.2

1.4.1

1.4.0

1.3.26

1.3.25

1.3.24

1.3.23

1.3.22

1.3.21

1.3.20

1.3.19

1.3.18

1.3.17

1.3.16

1.3.15

1.3.14

1.3.13

1.3.12

1.3.11

1.3.10

1.3.9

1.3.8

1.3.7

1.3.6

1.3.5

1.3.4

1.3.3

1.3.2

1.3.1

1.3.0

1.2.18

1.2.17

1.2.16

1.2.15

1.2.14

1.2.13

1.2.12

1.2.11

1.2.10

1.2.9

1.2.8

1.2.7

1.2.6

1.2.5

1.2.4

1.2.3

1.2.2

1.2.1

1.2.0

1.1.15

1.1.14

1.1.13

1.1.12

1.1.11

1.1.10

1.1.9

1.1.7

1.1.6

1.1.5

1.1.4

1.1.3

1.1.2

1.1.1

1.1.0

1.0.3

1.0.2

1.0.1

1.0.0

0.1.8

0.1.7

0.1.6

0.1.5

0.1.4

0.1.3

0.1.2

0.1.1

0.1.0

0.0.7

0.0.6

0.0.5

0.0.4

0.0.3

0.0.2

Labels

Clear labels   

blocked

  

breaking

  

bug

  

data loss

  

design finalized

  

good first issue

  

new feature area

  

question / support

  

security

  

waiting for response

No labels

blocked

breaking

bug

data loss

design finalized

good first issue

new feature area

question / support

security

waiting for response

Milestone

Clear milestone

No items

No milestone

Projects

Clear projects

No items

No project

Assignees

Clear assignees

No assignees

2 participants

Notifications

Subscribe

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

borgmatic-collective/borgmatic#1324

No description provided.